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