Demo Academy
SQL Fundamentals with DuckDB
Learn the SQL you need for analytics — SELECT to JOINs — using DuckDB, the in-process analytics database.
- 7 lessons
- 2 runnable labs
- ~2h
DuckDB Speedrun
A two-lesson taste of courses-as-code, synced from GitHub.
- 2 lessons
- 1 runnable lab
Window Functions in Depth
RANK, LAG, and rolling aggregates — the SQL that turns row-by-row data into answers about change over time.
- 2 lessons
- Intermediate
- ~1 h
dbt + DuckDB: Local Analytics
A full transformation pipeline on your laptop: dbt models compiled straight into an in-process DuckDB.
- 2 lessons
- Intermediate
- ~1.5 h
Querying JSON and Nested Data
Structs, lists, and raw JSON columns — how to unnest the messy shapes real APIs hand you.
- 2 lessons
- Intermediate
- ~45 min