DuckDB for Beginners

OpenLearnia

SQL that quacks

Learn DuckDB with a guided book, then run real queries in an in-browser playground and web shell—powered by DuckDB-WASM.

Start reading Open Playground Global Wall

SELECT
  species,
  count(*) AS n,
  avg(bill_length_mm)
FROM penguins
GROUP BY 1
ORDER BY n DESC;

Three ways in

Pick the path that fits how you learn.

Book
Chapter-by-chapter DuckDB, with runnable SQL cells in the browser.
Start reading
Playground
Notebook cells, sample datasets, and shareable URL hashes—no backend.
Open Playground
Shell
A classic duckdb> prompt via DuckDB-WASM in your tab.
Launch Web Shell

Runs in your browser

DuckDB-WASM loads once and stays local. No install, no account, no server round-trip for your queries—just open a tab and quack away.