Skip to content
learning path

A Practical Dive Into Data Build Tool (dbt)

Get a practical understanding of Data Build Tool, its features, and how to use them with this labs-based course!
Difficulty: Intermediate
Duration: Up to 15 hours and 50 minutes
Students: 611
Rating: 4.6/5
Start
Unlock your potentialBuild the skills and confidence you need to make a real impact.
Learn your wayThis content is flexible and engaging so you can take charge of your learning journey.
Showcase your expertiseApply what you've learned to track your progress and strengthen your understanding.
Content overview
About
Author

Content overview

12 steps
There are 12 Hands-on Labs in this learning path
Difficulty: Beginner. Duration: Up to 40m.
HANDS-ON LAB
Beginner
Duration: Up to 40 minutes
Create Your First dbt (Data Build Tool) Project
In this lab, you will learn what is dbt, why it is super helpful for data transformations, and you will install it and create your first dbt project.
Difficulty: Beginner. Duration: Up to 40m.
HANDS-ON LAB
Beginner
Duration: Up to 40 minutes
Configure a dbt Profile and Define Sources
In this lab, you will configure a dbt profile to connect to a PostgreSQL database, and you will define sources to be used in a dbt project.
Difficulty: Beginner. Duration: Up to 1h.
HANDS-ON LAB
Beginner
Duration: Up to 1 hour
Create and Execute Your First dbt Models
In this lab, you will create your first dbt models. You will create a model starting from the dbt sources, and you will create another one starting from the existing model. You will then execute and materialize them in the PostgreSQL database.
Difficulty: Beginner. Duration: Up to 1h.
HANDS-ON LAB
Beginner
Duration: Up to 1 hour
Working With Full-Refresh dbt Models
In this lab, you will understand what are full-refresh dbt models, and you will create two models by using the table materialization type.
Difficulty: Beginner. Duration: Up to 1h.
HANDS-ON LAB
Beginner
Duration: Up to 1 hour
Working With Incremental dbt Models
In this lab, you will understand what are incremental dbt models, and you will create two models by using the incremental materialization type.
Difficulty: Intermediate. Duration: Up to 1h.
HANDS-ON LAB
Intermediate
Duration: Up to 1 hour
Working With Ephemeral dbt Models
In this lab, you will understand what are ephemeral dbt models, and you will create an ephemeral dbt model that will be then leveraged by a full-refresh model. You will then review what dbt has materialized and what has not.
Difficulty: Intermediate. Duration: Up to 1h.
HANDS-ON LAB
Intermediate
Duration: Up to 1 hour
Understand and Use dbt Jinja Macros
In this lab, you will understand what Jinja macros are and why they are helpful. You will then leverage the most important native macros source and ref, and you will create a custom macro.
See all