Skip to main content

Home Data Engineering

course

Introduction to dbt

Advanced

4.4+

Updated 01/2025

This course introduces dbt for data modeling, transformations, testing, and building documentation.

Start course for free

Included for FreePremium or Teams

dbtData Engineering4 hours16 videos58 exercises4,750 XP10,959Statement of Accomplishment

Create Your Free Account

Google LinkedIn Facebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

dbt, or the data build tool, has taken the data world by storm. This course introduces you to the concepts, terminology, and methods of using dbt to implement an example data warehouse. You'll gain an understanding of what dbt is, when it should be used, and best practices when implementing data warehousing. You will work with real datasets and perform extract, load, and transform operations as implemented in data analyst, data engineering, and analytics engineering roles. Learners will develop the skills to define a data warehouse from scratch, model and transform data, and build tests and documentation! This course will provide you with a solid foundation to build upon in your dbt journey, regardless of the type of data warehouse you intend to implement. Gain confidence about how and when to use dbt by working through exercises using SQL and shell commands.

Prerequisites

Data Warehousing Concepts Introduction to Shell Joining Data in SQL

1

Welcome to dbt

What is dbt?

Users of dbt

Version of dbt

dbt subcommands

Creating a dbt project

Initializing a dbt project

Creating a project profile

Working with a first project

dbt project workflow

Running a project

Modifying a model

2

dbt models

What is a dbt model?

Features of a data model

dbt model statements

Creating a dbt model

Updating dbt models

Config files

Updating a dbt model

Hierarchical models in dbt

No hierarchy model creation

Hierarchical model creation

Updating model hierarchies

Model troubleshooting

Error classification

Process of troubleshooting

Troubleshooting model errors

3

Testing & Documentation

Introduction to testing in dbt

Built-in tests

Defining tests on a model

Finding bad data

Creating singular tests

Steps to develop a singular test

Verifying trip duration

Verifying test queries

Creating custom reusable tests

Testing, testing, testing

Implementing a reusable test

Updating from singular to reusable test

Creating and generating dbt documentation

dbt docs Command Options

dbt documentation flow

Creating dbt documentation

4

Implementing dbt in production

dbt sources

Orderly YML

Models, sources, or both?

Adding a source

Kernels of truth

ZIP is the code

SCD2 with dbt snapshots

Snapshot process

Snapshot issue

Adding a snapshot

Automating with dbt build

What can't dbt build do?

Helping the intern!

Putting it all together

Course review

Introduction to dbt

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Don’t just take our word for it

*4.4

from 22 reviews

68%

18%

0%

14%

0%

Highest to Lowest
Lowest to Highest
Most recent
Top reviews

Adama K.

26 days

Great introduction. Allah aspects are well presented. Very usefull for a beginner.

Jono P.

about 2 months

Covers foundational topics well, and excellent practice exercises in the terminal.

Zweitze V.

about 2 months

Excellent. Although dbt has its own courses, this Datacamp course taught me a few new tricks!

Matthew M.

3 months

Great introduction to dbt

Julia R.

4 months

Great walk-through first steps in dbt with practical examples

"Great introduction. Allah aspects are well presented. Very usefull for a beginner."

Adama K.

"Covers foundational topics well, and excellent practice exercises in the terminal."

Jono P.

"Excellent. Although dbt has its own courses, this Datacamp course taught me a few new tricks!"

Zweitze V.

Join over 15 million learners and start Introduction to dbt today!

Create Your Free Account

Google LinkedIn Facebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.