Courses/Data/dbt From Zero: Hands-On Labs with DuckDB
Shadab Barmare

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.

6 students enrolled
Free lesson·32h·Data

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