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
596
Students: 596
4.6/5
Rating: 4.6/5
Start
Enhance your skill set
Develop essential skills for thriving in real-world scenarios.
Stay focused, stay committed
Boost your learning journey by enrolling: stay focused, consistent and achieve your goals with ease.
Earn a certificate of completion
Show your skills and build your credibility when you include them in your resume and LinkedIn profile.
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