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!
Intermediate
Up to 15h 50m
512
4.6/5
Enroll
Enhance your skill setDevelop essential skills for thriving in real-world scenarios.
Stay focused, stay committedBoost your learning journey by enrolling: stay focused, consistent and achieve your goals with ease.
Earn a certificate of completionShow your skills and build your credibility when you include them in your resume and LinkedIn profile.
12 steps
There are 12 Hands-on Labs in this learning path
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.
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.
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.
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.
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.
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.
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