Surfalytics
All pet projects
Data Engineering beginner ⏱ 6–8 hours

dbt Fundamentals

Learn dbt from scratch using GitHub Codespaces and Docker — models, tests, sources, and documentation in a single project.

dbtSQLAnalytics EngineeringDocker
View project on GitHub

What you’ll build

A complete beginner dbt project running in GitHub Codespaces: raw source declarations, staging models, a mart, generic and singular tests, and auto-generated docs. The fastest way to get dbt on your resume with real code.

Skills you’ll practice

  • dbt project setup: profiles.yml, dbt_project.yml
  • Writing models: ref(), source(), CTEs
  • Testing with dbt: not_null, unique, accepted_values, relationships
  • Generating and serving dbt documentation

The full project guide is for members

Join Surfalytics to unlock every step of this project, all other projects, the full course, and the private community.

7-day free trial · Cancel any time