DuckDB Speedrun

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

2 lessons
1 runnable lab
Updated August 2026

Start course

Everything in this course is free to read — no account needed. Sign in to track your progress.

Try a lab from this course

This is a real lab from lesson 2, “Your first query” — press Run.

Lab: One real query

Starting DuckDB…SQLAbout 3 min

Find the pro users

Two of the three users are on the pro plan. Select only them.

Defined for youSetup that runs before your code

CREATE OR REPLACE TABLE users (id INTEGER, name VARCHAR, plan VARCHAR);
INSERT INTO users VALUES
  (1, 'Ada', 'pro'), (2, 'Grace', 'free'), (3, 'Edsger', 'pro');

SELECT * FROM users;

Hint 1

Strings take single quotes: WHERE plan = 'pro'