Chapter 1: Introduction to SQL & Basic Queries

We begin with a quick introduction to relational databases, SQL syntax, and how data is stored in tables. You’ll learn how to create tables, insert data, and run basic SELECT queries. We’ll also cover filtering with WHERE, sorting using ORDER BY, and column aliases. This chapter forms the foundation for all query building.

Chapter 2: Aggregations and Grouping

This section covers essential analytical functions like COUNT, SUM, AVG, MIN, and MAX. You’ll learn how to use GROUP BY and HAVING to summarize and filter grouped data—skills commonly used in reporting and dashboards.

Chapter 3: Joins and Subqueries

Here, we explore how to combine data from multiple tables using INNER JOIN, LEFT JOIN, and RIGHT JOIN. You’ll also practice writing subqueries inside SELECT, FROM, and WHERE clauses. These concepts are crucial for solving real-world data problems.

Chapter 4: Window Functions & Practice

This final chapter introduces powerful window functions such as ROW_NUMBER(), RANK(), and LAG(), which are used in advanced analytics and interviews. The session ends with guided query practice, mini case studies, and tips on how to approach SQL questions in interviews confidently.