All courses

SQL Fundamentals with DuckDB

Learn the SQL you need for analytics — SELECT to JOINs — using DuckDB, the in-process analytics database.

• 8 lessons
• 2 runnable labs
• ~2h

DuckDB Speedrun

A two-lesson taste of courses-as-code, synced from GitHub.

• 2 lessons
• 1 runnable lab

RANK, LAG, and rolling aggregates — the SQL that turns row-by-row data into answers about change over time.

• 2 lessons
• Intermediate
• ~1 h

Facts, dimensions, and the grain — how to shape tables so every later query gets simpler.

• 2 lessons
• Beginner
• ~45 min

A full transformation pipeline on your laptop: dbt models compiled straight into an in-process DuckDB.

• 2 lessons
• Intermediate
• ~1.5 h

Why analytics engines read Parquet 100× faster than CSV, and how to work with it directly.

• 2 lessons
• Beginner
• ~40 min

From raw files to answers with dataframes — the working core of analytical Python.

• 2 lessons
• Beginner
• ~2 h

Idempotency, backfills, and alerts — what separates a script that ran once from a pipeline you can trust.

• 2 lessons
• Advanced
• ~1.5 h

Structs, lists, and raw JSON columns — how to unnest the messy shapes real APIs hand you.

• 2 lessons
• Intermediate
• ~45 min

Freshness, volume, and validity checks — catch broken data before your stakeholders do.

• 2 lessons
• Intermediate
• ~1 h

The terminal as a data tool: inspect, slice, and convert files before anything heavier gets involved.

• 2 lessons
• Beginner
• ~1 h