Free Learning Paths

Start here

Comprehensive SQL

Master SQL from foundations to advanced window functions. 8 modules covering everything you need for data analyst interviews.

8–12 weeks

6 modules

36 lessons

~20 hr 35 min total

160+ questions

What you'll learn

1

SQL Foundations

8 lessons · 4 hr 30 min

Introduction to Databases & SQL20 min SELECT and FROM Basics35 min Filtering with WHERE45 min Logical Operators: AND, OR, NOT45 min Pattern Matching: LIKE, IN, BETWEEN50 min Working with NULL30 min Sorting with ORDER BY20 min Limiting Results with LIMIT25 min

2

Aggregating & Grouping Data

6 lessons · 3 hr 25 min

Introduction to Aggregate Functions35 min GROUP BY Fundamentals40 min Filtering Groups with HAVING25 min NULL Handling in Aggregations25 min Conditional Aggregation with CASE WHEN45 min Combining Aggregation Techniques35 min

3

Working with Multiple Tables

8 lessons · 4 hr 5 min

Understanding Table Relationships15 min Combining Results with UNION40 min INNER JOIN Fundamentals35 min LEFT and RIGHT OUTER JOINs35 min FULL OUTER JOIN25 min CROSS JOIN30 min Self-Joins30 min Joining Multiple Tables35 min

4

Subqueries & CTEs

4 lessons · 2 hr 20 min

Understanding Subqueries35 min CTE Fundamentals40 min Building with Multiple CTEs25 min CTE Patterns for Common Problems40 min

5

Date, Time & Text Functions

5 lessons · 3 hr 20 min

Date/Time Data Types and Extraction45 min Date Arithmetic and Truncation30 min String Functions35 min Pattern Matching and String Splitting45 min Combining Functions45 min

6

Windows Functions

5 lessons · 2 hr 55 min

Introduction to Window Functions30 min PARTITION BY and Ranking Functions40 min LAG and LEAD35 min Aggregate Window Functions25 min Window Frames and Advanced Patterns45 min