Insert coin · Runs in your browser · No install

DuckDB TutorialLearn DuckDB online — nothing to install

DB Quacks is a free game for learning DuckDB SQL. Every query runs live in your browser through DuckDB-WASM, so you can learn DuckDB online without installing a single thing.

What is DuckDB?

DuckDB is a fast, in-process analytical database — often described as "SQLite for analytics." It runs anywhere, needs no server, and is built for the kind of grouping, filtering, and aggregating you do when analyzing data. Its SQL dialect is friendly and expressive, with quality-of-life features that make analytical queries shorter and clearer than in many older databases.

Best of all, DuckDB compiles to WebAssembly (DuckDB-WASM), which means it can run entirely inside a web browser. DB Quacks uses exactly this: when you type a query and hit run, real DuckDB executes it on real data right there in the editor. Nothing is faked — the results you see are computed by the same engine analysts use in production.

What you will learn

• Core SQL in the DuckDB dialect: SELECT, WHERE, ORDER BY, GROUP BY
• Joining tables and using subqueries and CTEs
• Aggregate and window functions for analytics
• Reading files directly — querying CSV, JSON, and Parquet without a load step
• DuckDB conveniences like SHOW TABLES, DESCRIBE, and USING SAMPLE

Why DuckDB is worth learning

DuckDB has become a go-to tool for data analysts and engineers who want speed without infrastructure. You can point it at a Parquet file and start querying immediately, embed it in a Python or Node script, or — as here — run it in the browser. Learning DuckDB gives you a portable analytical skill that transfers directly to real data work.

Work through the interactive lessons at your own pace — Duckbert, our pixel-art duck guide, walks you through levels like "The SAMPLE Awakens" and "Parquet and Recreation" — then apply what you have learned in the story-driven SQL challenges or dig into deeper topics on the Row by Row blog.