AR+TECHGet started

DATA / ENGINEERING LEARNING PATH

Learn dbt
with a clear path.

Build modular, tested, documented SQL transformations for analytics workflows.

Intermediate3 learning stages6 topics
Start learning
LEARNING PATH / 01

dbt

BEGINNERADVANCED
AR+TECH
OverviewRoadmapPracticeProjectsInterview prepProgress
THE BIG PICTURE

What is dbt?

dbt helps organize SQL transformations as maintainable projects. Learn models, sources, tests, documentation, materializations, and deployment practices.

WHY LEARN THIS
  • Make analytical SQL easier to test and maintain
  • Document how datasets are derived
  • Organize transformation work into clear dependencies
PREREQUISITES
  • SQL fundamentals recommended
  • Git basics are useful
LEARNING ROADMAP

A clear route from foundation to fluency

Explore dbt through beginner, intermediate, and advanced learning levels. Topic status is illustrative demo progress only.

3 LEARNING LEVELS
01Beginner

Beginner

Build fluency with the core ideas and everyday building blocks.

02Not Started

Sources and refs

Represent dependencies and source data.

BeginnerPractice Interview
02Intermediate

Intermediate

Combine concepts into reliable, useful workflows.

01Not Started

Tests and documentation

Add data assertions and explain model purpose.

IntermediatePractice Interview
02Not Started

Materializations

Choose how models are built and stored.

IntermediatePractice Interview
03Advanced

Advanced

Reason about scale, trade-offs, security, and optimization.

01Not Started

Incremental models

Build models that process changes efficiently.

AdvancedPractice Interview
02Not Started

Deployment patterns

Plan environments, reviews, and reliable releases.

AdvancedPractice Interview

Status labels are sample progress and are not linked to a user account.

TURN CONCEPTS INTO SKILL

Hands-on practice

Try focused learning activities that reinforce the dbt concepts you have just explored.

01

Build a staged SQL model

Practice this skill
02

Add tests to a key metric

Practice this skill
APPLY WHAT YOU LEARN

Project ideas for dbt

Use a project to connect technical concepts to a practical problem and its constraints.

Explore project guides
PROJECT IDEA / 01

Documented analytics model layer

Demo project outline · dbt learning application

Explore projects
PROJECT IDEA / 02

Incremental warehouse transformation

Demo project outline · dbt learning application

Explore projects
CONNECT LEARNING TO THE CONVERSATION

dbt interview preparation

Review your understanding and practice explaining your choices in a clear, structured way.

Explain materialization choicesDiscuss testing and lineagePractice model failure scenarios
dbt interview Explore scenarios
COMMON SCENARIOS TO CONSIDER
01

Handle an upstream schema change

02

Reduce a long-running build

YOUR FUTURE LEARNING DASHBOARD

See how the topics connect.

A real learner dashboard could track progress by topic and stage when user accounts are introduced.

Demo Progress · not user data
dbt pathDEMO
Beginner0 / 2 explored
Intermediate0 / 2 explored
Advanced0 / 2 explored
0 completed0 in progress6 not started
Keep the learning connectedBrowse all skills Get guidance