Powered by Mastria

Demo Academy

All With labs analytics data-engineering duckdb sql

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
1. 01Reading JSON
2. 02Unnesting lists
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
1. 01First look at a file
2. 02DuckDB as a CLI
Command-Line Data Tools
The terminal as a data tool: inspect, slice, and convert files before anything heavier gets involved.
- 2 lessons
- Beginner
- ~1 h