Rishabh Goswami1st class free
Rishabh Goswami
Online classes

Rishabh Goswami

Qualification: B.Tech / B.E.

Class mode: Online

Rating: 0.0· (0 reviews)

Location: Kanpur, Uttar Pradesh

10 years Teaching experience
English, Hindi Languages
Weekdays/Weekend Availability

About Rishabh

Rishabh Goswami is a dedicated tutor who specializes in creating a supportive learning environment. He teaches in both English and Hindi, ensuring clear communication with his students. Rishabh focuses on breaking down complex topics into understandable segments, making it easier for learners to grasp key concepts. His approach emphasizes student engagement and personalized assistance, helping each student reach their academic goals effectively.

Courses by Rishabh

What You Will Learn

This course covers the fundamentals of SQL and guides you to advanced concepts step by step. You will start with basic database knowledge and gradually learn more complex SQL techniques.

Weekend 1: Introduction to Databases & SQL Fundamentals

  • Understand what databases and RDBMS are.

  • Learn about tables, rows, columns, and keys.

  • Install SQL tools and learn SQL syntax.

  • Practice using the SELECT statement and filtering data.

Weekend 2: Data Filtering and Aggregation

  • Use comparison and logical operators.

  • Handle NULL values and utilize aggregate functions like COUNT, SUM, and AVG.

  • Group data using GROUP BY and filter groups with HAVING.

Weekend 3: Joins

  • Differentiate between primary and foreign keys.

  • Learn various join types including INNER JOIN, LEFT JOIN, and FULL OUTER JOIN.

Weekend 4: Advanced Querying Techniques

  • Explore subqueries and common table expressions (CTEs).

  • Use CASE statements for conditional logic.

  • Practice query optimization techniques.

Weekend 5: Window Functions & Analytics SQL

  • Learn to use window functions like ROW_NUMBER and RANK.

  • Understand how to calculate running totals and partition data.

Weekend 6: Data Quality & ETL Testing Using SQL

  • Practice data validation and duplicate detection.

  • Learn about ETL testing concepts and root cause analysis.

Weekend 7: SQL for Modern Data Platforms

  • Understand data warehousing concepts and schemas.

  • Learn about SQL in modern platforms like Snowflake and Azure Databricks.

Weekend 8: Industry Readiness & Interview Preparation

  • Practice frequently asked SQL interview questions.

  • Engage in scenario-based challenges and mock interviews.

Throughout the course, you will work on hands-on assignments using real-world datasets. You will build your skills progressively, from basic SQL queries to advanced data analysis techniques.

Kanpur, Uttar Pradesh
Online
8 weeks
English, Hindi
Upon enquiry
Weekdays/Weekend

What students say

0.0
0 reviews

No reviews yet.

Ready to start learning Complex Sql Query Writing? Book a free demo with Rishabh.

Rishabh Goswami
Rishabh Goswami

0.0(0 reviews)

On Call 1st class free

Start Your Teaching Journey Today

Join thousands of tutors who are sharing their knowledge and helping students succeed.

Start getting Students

Explore Tutors by Location and Skills

Find Expert tutors across India for Popular Subjects, Skills and Cities

Popular courses

    Popular Locations

      Popular Searches