Master new skills with our 21-day learning paths, broken into easy 5-minute daily lessons.

Start your journey for free.

data Advanced 21 lessons

dbt (Data Build Tool)

Transform data in the warehouse using software engineering best practices. Master the Analytics Engineering workflow with dbt Core.

dbt (data build tool) has created a new role: the Analytics Engineer. This course teaches you to transform data *inside* your warehouse using SQL and Jinja templating. You will learn to build modular data models, document your data automatically, and write tests to ensure data quality. We cover the shift from ETL (Extract-Transform-Load) to ELT, version control for data models, and deploying dbt projects in production. This is the industry standard for modern data transformation.

✅ 100% Free & Lifetime Access
⏱️ 5-Minute Lessons (Bite-sized learning)
🚀 21-Lesson Path (Independent modules)
📱 Mobile Friendly (Learn anywhere)
Analytics Eng
Start Learning
Secure Enrollment via SSL

Complete Course Syllabus

  • 1
    The ELT Workflow
    Why transformation happens in the warehouse now.
  • 2
    dbt Fundamentals
    Models, sources, refs, and the DAG (Directed Acyclic Graph).
  • 3
    Testing & Docs
    Writing data tests and generating documentation sites.
  • 4
    Jinja Templating
    Using loops and macros to write powerful SQL generators.
  • 5
    Deployment
    Scheduling jobs and managing environments (Dev vs Prod).

Estimated completion time: 21 lessons • Self-paced learning • Lifetime access

Career Outlook

Estimated Salary
$110k - $150k

Career Paths

Analytics Engineer $110k-$160k
Data Engineer $120k-$170k
BI Architect $115k-$150k

What You Will Learn

Build modular data transformation pipelines using SQL and dbt
Implement software engineering practices like testing and version control for data
Automate documentation generation for data lineage and dictionaries
Use Jinja templating to write DRY (Don't Repeat Yourself) SQL code
Deploy dbt projects to production using CI/CD workflows

Skills You Will Gain

dbt Core Analytics Engineering Jinja Templating SQL Modeling Data Testing

Who Is This For

Data Analysts
Data Engineers
BI Developers

Prerequisites

Strong SQL
Git Basics

dbt (Data Build Tool) FAQs

Is this ETL?

It is the 'T' in ELT (Transform in warehouse).

SQL required?

Yes, dbt is primarily writing SQL files.

Core vs Cloud?

We teach Core (CLI) for deep understanding.

Why popular?

Brings software dev rigor to messy data work.

Need more info?
All Reork courses are 100% free, self-paced, and fully accessible on mobile devices. No prior experience is required. Read our full Platform FAQ.

Tech Stack & Tools

dbt Core
dbt Cloud
Snowflake/BigQuery
Git
VS Code

Recommended Next Steps

Snowflake Data Warehousing

data Advanced

Master the modern cloud data warehouse. Learn Snowflake's unique architecture, separation of storage and compute, and zero-copy cloning.

Excel VBA Automation

data Intermediate

Automate boring spreadsheet tasks. Master the Visual Basic for Applications (VBA) language to create macros, loops, and custom user forms.

Graph Neural Networks

data Advanced

Unlock the power of relational data. Learn to build Graph Neural Networks for social networks, molecule discovery, and recommendation systems.

Start Learning