Milestone 1 · SQL
Complete SQL
Write any query, from joins to window functions, stored objects, and tuning.
Hide lessonsShow all 67 lessons
Databases & SetupLessons 1–4
Reading Data — SELECTLessons 5–14
- 05Lesson 5: Your First Query — SELECT & FROM12 min
- 06Lesson 6: Filtering Rows — WHERE Clause14 min
- 07Lesson 7: Multiple Conditions — AND, OR, NOT12 min
- 08Lesson 8: Sorting Results — ORDER BY10 min
- 09Lesson 9: Limiting Results — LIMIT / TOP / FETCH10 min
- 10Lesson 10: Removing Duplicates — DISTINCT9 min
- 11Lesson 11: Working with NULL Values14 min
- 12Lesson 12: Column Calculations — Arithmetic10 min
- 13Lesson 13: Renaming Columns — AS (Aliases)9 min
- 14Lesson 14: Pattern Matching — LIKE & Wildcards12 min
Filtering & LogicLessons 15–17
Writing & Changing DataLessons 18–22
Database DesignLessons 23–26
AggregationLessons 27–29
JoinsLessons 30–35
Subqueries & Set OperationsLessons 36–40
SQL FunctionsLessons 41–44
Advanced SQL ObjectsLessons 45–51
Window Functions & CTEsLessons 52–57
- 52Lesson 52: Window Functions — OVER & PARTITION BY19 min
- 53Lesson 53: Window Frames — Running Totals and Moving Averages (ROWS / RANGE BETWEEN)19 min
- 54Lesson 54: Ranking — ROW_NUMBER, RANK, DENSE_RANK17 min
- 55Lesson 55: LAG, LEAD, FIRST_VALUE, LAST_VALUE17 min
- 56Lesson 56: CTEs — WITH Clause17 min
- 57Lesson 57: Recursive CTEs — Hierarchies & Trees20 min
Advanced SQL PatternsLessons 58–61
Performance & OptimizationLessons 62–64
Real-World & InterviewLessons 65–67
