Skip to content
Press
QQ
to open this menu
Pricing & Plans
Request a demo
Login
Start Free Trial
Training Library
Big Data
Courses
A Practical Dive Into Data Build Tool (dbt)
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
Difficulty: Intermediate
Up to 15h 50m
Duration: Up to 15 hours and 50 minutes
611
Students: 611
4.6/5
Rating: 4.6/5
Start
Unlock your potential
Build the skills and confidence you need to make a real impact.
Learn your way
This content is flexible and engaging so you can take charge of your learning journey.
Showcase your expertise
Apply 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
12
Difficulty: Beginner. Duration: Up to 40m.
HANDS-ON LAB
Beginner
Up to 40m
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
Up to 40m
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
Up to 1h
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
Up to 1h
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
Up to 1h
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
Up to 1h
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
Up to 1h
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