Skip to main content
CF

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 the largest open marketplace for online courses on the internet. Founded in 2010 by Eren Bali, Oktay Caglar, and Gagan Biyani and headquartered in San Francisco, the company went public on the Nasdaq in 2021 under the ticker UDMY. The platform hosts well over two hundred thousand courses across software development, IT and cloud, data science, design, business, marketing, and creative skills, taught by tens of thousands of independent instructors. Roughly seventy million learners use it worldwide, and the corporate arm — Udemy Business — supplies a curated subset of that catalog to enterprise customers.

Because Udemy is a marketplace rather than a single editorial publisher, the catalog is uneven by design. The strongest material lives in the long-form, project-based courses authored by working engineers — full-stack JavaScript, React, Node.js, Python data science, AWS, Docker and Kubernetes, mobile development with Flutter and React Native, and cloud certification preparation. The CourseFlix listing under this source is the slice of that catalog that has been mirrored here for offline-friendly viewing, organized by topic and updated as new releases land. Pricing on Udemy itself swings dramatically with the site's near-permanent sales, which is why the platform is best treated as a deep reference catalog: pick instructors with strong reviews and a track record of updating their material rather than buying on the headline price alone.

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

Course content

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

Related courses

Frequently asked questions

What is The Data Bootcamp: Transform your Data using dbt™ about?
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…
Who teaches The Data Bootcamp: Transform your Data using dbt™?
The Data Bootcamp: Transform your Data using dbt™ is taught by Udemy. You can find more courses by this instructor on the corresponding source page.
How long is The Data Bootcamp: Transform your Data using dbt™?
The Data Bootcamp: Transform your Data using dbt™ contains 25 lessons with a total runtime of 4 hours 10 minutes. All lessons are available to watch online at your own pace.
Is The Data Bootcamp: Transform your Data using dbt™ free to watch?
The Data Bootcamp: Transform your Data using dbt™ is part of CourseFlix's premium catalog. A CourseFlix subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch The Data Bootcamp: Transform your Data using dbt™ online?
The Data Bootcamp: Transform your Data using dbt™ is available to watch online on CourseFlix at https://courseflix.net/course/the-data-bootcamp-transform-your-data-using-dbt. The page hosts every lesson with the integrated video player; no download is required.