Introduction to dbt Core

dbt Setup for Azure PostgreSQL

SQL and Jinja Templating

dbt Tests

Incremental Models, Docs, and Snapshots

Building Your First Mart

Practice

Assignment

Gotchas & Pitfalls

Week 10 Lesson Plan (Teachers)

Week 10 Lesson Plan (Teachers)

Content coming soon...

Suggested Topics to Cover

• Demo: live dbt init, dbt run, dbt test cycle showing the full workflow end to end
• Demo: writing a Jinja macro and showing the compiled SQL output with dbt compile
• Workshop: students set up their dbt project and create their first staging model
• Pair exercise: one student writes a staging model, the other adds tests, then swap
• Discussion: when incremental models make sense vs full refresh
• Live debugging: introduce a common dbt error (circular ref, missing source) and fix it together
• Code review: students present their mart models and explain design decisions
• Time allocation guidance: note that dbt installation and profiles.yml setup can consume 30-60 minutes; plan accordingly
• Pre-class setup: students should have dbt Core installed and dbt debug passing before class
• Assessment rubric: dbt project structure, test coverage, documentation quality, mart correctness

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0

*https://hackyourfuture.net/*

Found a mistake or have a suggestion? Let us know in the feedback form.