Milestone 1 · SQL
SQL from zero
Query, filter, aggregate, and join tables with confidence.
Hide lessonsShow all 35 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
AggregationLessons 18–20
JoinsLessons 21–26
Subqueries & Set OperationsLessons 27–31
