Skip to main content
CourseFlix

The Data Bootcamp: Transform your Data using dbt™

4h 10m 51s
English
Paid

This course teaches you dbt™ from scratch. You follow a real project and see each step. You start with dbt Cloud. You connect it to Snowflake or another warehouse. You then build models, add sources, write tests, and use the docs.

What You Learn

You learn how dbt helps you shape and clean data. You write SQL models, and dbt runs them in the right order. You use SQL with Jinja to add logic. This gives you clear and repeatable steps in your project.

How dbt Works

You write code, then run it with the dbt run command. dbt builds only the models that need updates. This keeps your work fast. You test each model, update it, and run it again without long waits.

dbt also makes clean docs for your project. These docs help you track sources, models, and tests as your project grows.

Project You Build

You work with data from a sample company called GlobalMart. They sell home and office items. Their data team wants to test dbt for reports. They need clear tables for profit and other metrics.

You use dbt to shape their data and build these tables step by step. This shows you how a real team would use dbt in daily work.

About the Author: udemy

udemy thumbnail

Udemy is a global online marketplace for teaching and learning. It connects students with instructors who share skills in many fields.

Who Uses Udemy

Millions of learners use Udemy to gain skills for work and personal growth. Companies, governments, and nonprofits also use Udemy to train their teams.

What Udemy Offers

Udemy provides a curated set of business and technical courses. These courses help teams build practical skills and support ongoing learning at work.

Watch Online 25 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 25 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Introduction to the Course
All Course Lessons (25)
#Lesson TitleDurationAccess
1
Introduction to the Course Demo
02:47
2
What is dbt?
04:08
3
ELT vs ETL - What is better?
04:46
4
How the Course is Structured
01:57
5
Reading the Project Brief
01:57
6
Setting up dbt Cloud
02:17
7
Setting up Snowflake Data Warehouse
17:53
8
Setting up Github
03:00
9
Connecting to the Database and Github
09:51
10
Initialising dbt Cloud
04:44
11
Taking a Tour of dbt Cloud
17:11
12
Developing Models in dbt
19:13
13
Understanding Modularity and REF Functions in dbt
31:26
14
Working with dbt_project.yml
06:52
15
Working with Sources in dbt
14:00
16
Introduction to Testing in dbt
03:05
17
How to Create Generic Tests in dbt
20:17
18
How to Create Singular Tests in dbt
10:32
19
How to Generate and work with dbt Documentation
16:36
20
How to use JINJA in dbt
13:02
21
How to Create Macros in dbt
13:16
22
How to use Packages in dbt
08:43
23
How to use Seeds (CSV files) in dbt
08:01
24
Deploying on dbt
14:33
25
A Quick Goodbye Note
00:44
Unlock unlimited learning

Get instant access to all 24 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription