dbt From Zero, Part 2: Project Anatomy & Your First Models
Learn how a dbt project is organised and build your first models on CocoaCo’s chocolate-shop data. You build views with dbt run, check them with dbt show and fix failing models by reading their errors. Part 2 of the dbt From Zero series.
1 student enrolled
Free lesson·2h·Data
What you'll learn
What each folder and setting in a dbt project is for
What a model is, and the rules every model follows
Building models as views in your own schema with dbt run
Checking results with dbt show and reading the SQL dbt sends to the database
Building one model or one folder with --select
Reading dbt and DuckDB error messages to fix a failing model
Syllabus
Lab 1 — Project anatomy & your first model
- •Concept: What’s inside a dbt project?
- •Guided walkthrough: build your first model
- •Lab 1 Challenge: CocoaCo’s first recipes
- •Lab 1 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
1 lab: 2 lessons, 1 hands-on challenge, 1 quiz (about 2 hours)
Prerequisites
- •Completed Part 1, "dbt From Zero: Hands-On Labs with DuckDB", with dbt debug ending in "All checks passed!"
- •The cocoaco_dbt project and the cocoaco.duckdb file from Part 1 on your computer
- •Reading a basic SQL query with GROUP BY. HAVING is introduced in this lab.
- •About 2 hours
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

