The learning path

Learn SQL

A practical beginner path. Each lesson pairs a short explanation with exercises you run right here in the browser — against realistic datasets, with hints and solutions when you get stuck.

▶ Live
Try a live lesson: Filtering with WHERE
Run real SQL against the Garden Shop dataset, right in your browser.
→
  1. 01
    Welcome to the Shed
    What SQL is · the workbench · your first SELECT
  2. 02
    Data Types Before Deep Querying
    Numbers · strings · dates · booleans · nulls
  3. 03
    Select, Filter, and Sort
    WHERE · AND/OR · IN · BETWEEN · LIKE · ORDER BY
  4. 04
    Aggregations and Grouping
    COUNT · SUM · AVG · GROUP BY · HAVING
  5. 05
    Joins
    INNER · LEFT · multiplication · anti-joins
  6. 06
    CASE Logic and Derived Columns
    Calculated columns · CASE WHEN · COALESCE
  7. 07
    Dates, Strings, and Nulls in Practice
    Date math · string cleanup · safe null handling
  8. 08
    DML — Measure Twice, Cut Once
    INSERT · UPDATE · DELETE · transactions
  9. 09
    Query Debugging and Common Mistakes
    Reading errors · wrong answers without errors
  10. 10
    Practical Analytics Patterns
    Top-N · rates · cohorts · windows · CTEs
  11. 11
    Freeform Playground
    Built-in practice · bring your own CSV / Parquet

🚧 More lessons are being written. The first interactive lesson (Filtering with WHERE) is live above — the rest of the path is on the way.