dbt From Zero: Hands-On Labs with DuckDB
Learn dbt step by step, one concept per lab. You build a real data project for a fictional chocolate shop, CocoaCo, and every lab ends with a challenge and a quiz. No dbt experience needed.
What you'll learn
• What dbt is and where it fits in a modern data stack (ELT)
• Setting up dbt Core with DuckDB on your own computer, from installation to a successful connection test
• Building models and reading raw tables with source()
• Linking models with ref() and reading the lineage graph (DAG)
• Choosing between views, tables, ephemeral and incremental models
• Testing data quality with generic and singular tests
• Documenting a project and publishing the docs site
• Writing Jinja and reusable macros
• Using seeds, packages (dbt_utils) and snapshots (history tracking)
• Running and selecting models like a professional
Syllabus
Lab 0 — Welcome & Setup
- •Concept: What is dbt and why does it exist?
- •Guided walkthrough: install and connect
- •Lab 0 Challenge: Open the CocoaCo pantry
- •Lab 0 Quiz
Feedback & Certificate
- •Course Feedback (Required for Certificate)
What's included
Certificate of completion
Complete every lesson and the short feedback form to download your CtrlSkill certificate
Course material
16 labs, about 2 hours each
Prerequisites
- •• A computer running Windows, macOS or Linux, with permission to install software
- •• Reading a basic SQL query (SELECT, FROM, WHERE). Everything else is taught.
- •• No cloud account and no cost: everything runs on your own computer with DuckDB, a free database installed in Lab 0
- •• About 2 hours per lab
Who is this for?
- •• Data analysts who write SQL and want to build reliable data pipelines
- •• Students and career changers moving into data analytics or analytics engineering
- •• BI developers who want to understand how the data behind their dashboards is built

