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.