
1st class free
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.
What students say
Similar tutors with Skills
Similar tutors with locations
Ready to start learning Complex Sql Query Writing? Book a free demo with Rishabh.

0.0(0 reviews)