The Data Bootcamp: Transform your Data using dbt™

Learn dbt™ from scratch. Build data models, perform testing, generate documents & become an all rounded Data Engineer!

4.41 (654 reviews)
Udemy
platform
English
language
Data Science
category
instructor
3,184
students
4 hours
content
Jun 2022
last update
$79.99
regular price

What you will learn

Learn how to use dbt end-to-end through a realistic project, hands-on project

Learn the fundamentals of dbt including connecting to a data warehouse, developing models, working with sources, creating tests, deploying and much more

Understand how dbt is beneficial in a modern data stack and how the Extract, Load and Transform process works

Learn how to use Macros and Packages in dbt to simplify and reuse your code

Learn how dbt can work with complex SQL queries

Perform Testing in dbt such as singular tests, generic tests and source testing

Develop documentation for your models, understand modularity and dependancies in dbt

Learn about the dbt Project Structure and how to set up your own project

Understand how to use JINJA in dbt

Learn how to deploy in dbt under a schedule and investigate run time errors

Learn how to use Seeds and Analysis in dbt

Description

Are you looking for a cutting-edge way to extract load and transform your data? Do you want to know more about dbt™ and how to use it? Well, this is the course for you. Welcome to The dbt Bootcamp: Transform your Data using dbt.


In this course you are going to learn all about dbt™, from setting up dbt™ cloud, connecting it to Snowflake or a warehouse of your choice, developing models, creating sources, doing testing, working with the documentation and much more.


This course is for beginners, we will go through a realistic project and cover each of the steps mentioned in a practical approach.


dbt™ is a data modelling tool that makes life much easier for analysts and engineers. It allows you to write SQL queries without having to worry about dependencies. dbt™, like traditional databases, is built on SQL, but it has additional functionality built on top of it utilizing templating engines such as JINJA.

This effectively lets you to retrieve, rearrange, and organize your data using additional logic in your SQL. You may then compile and run this code using dbt's™ run command to retrieve just the pieces you need in the transformations. It can also be swiftly coded, tested, and adjusted without having to wait for it to process all your data. In addition to that, it’s automated documentation is a big time saver.

The project we will be working on is about a fictitious company called GlobalMart. GlobalMart sells household items like furniture, office equipment, Appliances and Electronics. They are in the process of hiring a small data team and would like to try out dbt™ for their data transformations. They require some reporting tables about their profits and want to use dbt™ to transform their data to get them what they want.


By the end of this course, we will work through the project and end up accomplishing the following:


1. Setting up a dbt™ Cloud Account

2. Connecting to a Database (in this case Snowflake)

3. Connecting dbt™ to a repository like GitHub

4. Understanding the dbt™ cloud interface

5. Building and Running Models in dbt™

6. Using Modularity in dbt™

7. Creating and Referencing Sources

8. Performing Tests in dbt™ including Singular and Generic Tests

9. How to Create and Generate Documentation in dbt™

10. How to Deploy in dbt™

11. How to use Jinja

12. Using Macros and Packages in dbt™

13. Using Seeds and Analyses in dbt™


This is a great, comprehensive which will really up-skill you not only in dbt but the extract, load and transform process as well.


Thank you so much for choosing this course and I’ll see you in the next lecture.


Content

Introduction

Introduction to the Course
What is dbt?
ELT vs ETL - What is better?
How the Course is Structured

Setting up dbt

Reading the Project Brief
Setting up dbt Cloud
Setting up Snowflake Data Warehouse
Setting up Github
Connecting to the Database and Github

Getting Started with dbt

Initialising dbt Cloud
Taking a Tour of dbt Cloud

Models and Modularity in DBT

Developing Models in dbt
Understanding Modularity and REF Functions in dbt

Working with YML files

Working with dbt_project.yml
Working with Sources in dbt

Testing and Documentation on dbt

Introduction to Testing in dbt
How to Create Generic Tests in dbt
How to Create Singular Tests in dbt
How to Generate and work with dbt Documentation

Using Macros, Packages and Seeds in DBT

How to use JINJA in dbt
How to Create Macros in dbt
How to use Packages in dbt
How to use Seeds (CSV files) in dbt

Deploying on dbt

Deploying on dbt
A Goodbye Note

Screenshots

The Data Bootcamp: Transform your Data using dbt™ - Screenshot_01The Data Bootcamp: Transform your Data using dbt™ - Screenshot_02The Data Bootcamp: Transform your Data using dbt™ - Screenshot_03The Data Bootcamp: Transform your Data using dbt™ - Screenshot_04

Reviews

CARMICHAEL
September 1, 2023
I am learning quite well. My only issue is this tutorial is using an old version of DBT and Snowflake. The tutorial must be updated using the newer ones because some of the UI parts for DBT and Snowflake are now different. Sometimes some itty bitty parts of the examples are also different.
Nazmi
August 25, 2023
Postives + Good and understanable explonations for teaching dbt Negatives: - Old Content: Snowflake and dbt have different UIs now -Low Q&A: You probably won't find your problem in this section -You probably have lots of errors but can't find in the course, you need lots of googling -Videos are not edited well: there are lots of silent moments in it
Ufuk
May 19, 2023
The course material is done without taking into account the interface changes on Snowflake, where you cannot put your data, models from dbt. The course staff does not help you with this either and your trial with Snowflake and dbt gets expired. Very unprofessional.
Basanti
February 7, 2023
I go through first with DBT which was totally new for me but i was able to understand the concept through this training
Etienne
December 5, 2022
Cours intéressant jusque là mais pas de structure claire sur l'articulation du cours, et sous titres avec beaucoup de fautes, notamment sur les abréviations et initiales
Yeyner
December 1, 2022
Excellent course, it has exceeded my expectations, I have learned more than I was looking for, as a recommendation you need to update some videos because the integration interface of DBT with Snowflake has changed a bit but it is possible to configure it.
David
November 6, 2022
Good basic course on Dbt. Very light on transformations. But, in the allotted time, a good end to end course to get you started, and covering dbt cloud which is what I wanted.
Rajashekhar
September 18, 2022
Precise explanation of each topic. Really helped me to gain the knowledge and basics of DBT with this course. Hands on explanation is efficient way of teaching any topic. Thanks for this course
Venkata
September 5, 2022
All the topics so far are basic and well connected all the topic. Looking more deeper configuration and scheduling of the DBT pipeline.
Igor
August 22, 2022
Great course. One note to the author of that course: Sounds like you prefer to drink water quite often :) LOL
João
August 22, 2022
Curso muito bom, principalmente para quem nunca trabalhou com o DBT, estou adorando estudar esse curso.
Jack
August 21, 2022
Pretty good, quick runthrough, which is what I needed for DBT currently. Would love a more extensive course too. This is a great starting point for anyone though, Thank you for great course!
Paresh
August 3, 2022
On the positive side, instructor speaks with clear and consistent voice and covers most aspects of dbt cloud. On the other hand, I often felt like I spent a little too much time watching the instructor type out SQLs. Emphasis was more on how to navigate to the different parts of dbt cloud to access dbt functionalities instead of explaining core concepts and what problems those functionalities solve. Instructor seems to be confused between upstream and downstream while explaining what "dbt run -s +mymodel" does. I'd think the sources that you depend on are called upstream.
Jason
June 13, 2022
This course is good and covers the fundamental setup for dbt to work. It will even be better if more topics cover the dbt parts (e.g. jinja, package, etc.) how it makes dbt even more special and when it could be used. For example, setting up variables and for-loop are too fundamental to talk about jinja.
Kazuhei
May 8, 2022
I started a new role and I had to learn dbt quickly and came across this new course. This is exactly I was looking for! She explained all terms such as model, macro, Jinja, yaml etc.. in a simple way and gave me hands-on exercises along her explanation. I really like she was very clear on these concepts. The course is not too difficult, yet is very useful.

Charts

Price

The Data Bootcamp: Transform your Data using dbt™ - Price chart

Rating

The Data Bootcamp: Transform your Data using dbt™ - Ratings chart

Enrollment distribution

The Data Bootcamp: Transform your Data using dbt™ - Distribution chart
4638648
udemy ID
4/12/2022
course created date
5/7/2022
course indexed date
Bot
course submited by