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)

Introduction to dbt Core

Content coming soon...

Suggested Topics

• What dbt is and why it exists: SQL transformations as software engineering
• dbt Core (open source CLI) vs dbt Cloud (managed service)
• The ELT pattern: extract and load first, then transform with dbt
• How dbt fits into the modern data stack alongside ingestion tools and BI platforms
• Key dbt concepts: models, sources, refs, materializations
• The dbt project structure: dbt_project.yml, models/, seeds/, macros/
• How dbt compiles Jinja+SQL into pure SQL and runs it against your warehouse
• Why analytics engineers use dbt: version control, testing, documentation, lineage

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.