The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero from Udemy

Become a dbt professional from scratch with this single course, solving a real-world problem step by step. We cover both theory and hands-on practice. Delivered by an instructor with 20+ years of Data Engineering experience. This is the

This course is the TOP RATED and the

"Excellent course. Edit: I managed to pass the dbt certification exam. I couldn't have done it without your help. Again, it's an awesome course. "

"Fantastic course. Well-chosen examples perfectly illustrate the many features that are covered. The pacing is spot on and it is easy to replicate the examples."

"I love how you're explaining everything at just the right level. "

New: dbt Certification questions and certification interview.

Thank you for joining us for The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero - we are super excited to have you in the course.

The structure of the course is designed to have a top-down approach. It starts with the Analytics Engineering Theory - all you need to know to put dbt (Data Build Tool) in context and to have an understanding of how it fits into the modern data stack. We start with the big picture; then, we go deeper and deeper. Once you learn about the pieces, we will shift to the technicalities - a practical section - which will focus on putting together the dbt “puzzle”. The practical section will cover each and every single dbt feature present today through the construction of a complete, real-world project; Airbnb. This presents an opportunity for us to show you which features should be used at what stage in a given project, and you will see how dbt is used in the industry.

We put special focus on getting everyone up and ready before the technical deep dive; hence we will start off by setting up our Development Environment:

MAC Development Environment Setup
WINDOWS Development Environment Setup
IDE dbt Extension Installation
Creation and Activation of Virtual Environments
Setting up Snowflake
Using the dbt Power User Visual Studio extension

Once we are ready - among several other technical topics, the following features will be covered;

dbt Models
dbt Materializations
dbt Tests
dbt Documentation
dbt Sources, Seeds, Snapshots
dbt Hooks and Operations
Jinja and Macros
dbt Packages
Analyses, Exposures
dbt Seeds
Data Visualization (Preset)
Working with Great Expectations (dbt-expectations)
Debugging tests in dbt
dbt Orchestration

Once the theory and the practical stages are finished, we will dive into the best practices and more advanced topics. The course is continuously updated; whenever dbt publishes an update, we adjust the course accordingly, so you always be up to date.

Who is this course for?

Data Engineers
Data Analysts
Data Scientists
BI Developers
BI Analyst

... and anyone who interacts with data lake/data warehouse/data lakehouse or uses SQL.

Course Level Explained (Zero > Hero)

The course has no expectations about your abilities and starts education from zero. Every exercise is an unavoidable step in your studies. In the same way, don't start an exercise of a superior level without completing the preceding ones: you will be in difficulty if you do so. Practice is the only way to learn, and it cannot be taken lightly. We will be next to you along the journey and you have our absolute support.

When the Airbnb project is presented to you, you must do it entirely, without omitting any guidelines, and by understanding the objective. A project "almost completely" done is often a project "totally incomplete" for us. Give special attention to detail. Your only reliable source of information regarding the instructions is the pedagogical team, don't trust the "I've heard".

By the time you complete the course, you will be equipped with both a very solid theoretical understanding and practical expertise with dbt. All the fundamentals, dbt features, best practices, advanced techniques and more will be covered in our course, which will make you become a master in dbt. Are you ready? ;)

How to get help?

We just published our initial round of Discussions on Udemy which is the easiest and most efficient way for you to post questions, receive answers, and peruse questions from other students. If you have questions or feedback, please reach out to us.

That wraps it up for us for now.

Once again, thank you for being a part of this course.

We can't wait to get started with you soon.

All the best,

Zoltan C. Toth

dbt Mark and the dbt logo are trademarks of dbt Labs, Inc.

What's inside

Learning objectives

Learn to use the dbt platform professionally through the creation of an exhaustive, real-world, hands-on dbt - airbnb project covering both theory and practice
Set up the complete development environment on mac & windows, connect to snowflake and bi, configure dbt profile, extend the ide with dbt tools
Learn core dbt concepts such as models, materialization, sources, seeds, snapshots, packages, hooks, exposures, analyses, write complex sql queries
Understand the dbt project structure and learn about dbt tips & tricks, advanced techniques and best practices, extend dbt with your own / third-party macros
Implement singular and generic dbt tests, work with additional arguments and default config values, customize dbt built-in tests
Document your models and pipeline, customize the dbt docs page, explore and analyse dependencies between transformation steps
Understand how dbt fits into the modern data stack, learn about the stages of the data-maturity model, and well functioning data architectures
Master etl/elt procedures, data transformations, modern data stack, slowly changing dimensions, common table expressions and analytics engineering

Understand what is a data warehouse, data lake, or data lakehouse and when to use which, handle data collection, data wrangling and data integrations
See how advanced testing works using dbt-expectations, a great expectations inspired testing framework
Test your knowledge with certification preparation question
Listen to real-world use-cases from industry professionals
Learn dbt orchestration best practices hands on
Show more
Show less

Learn to use the dbt platform professionally through the creation of an exhaustive, real-world, hands-on dbt - airbnb project covering both theory and practice
Set up the complete development environment on mac & windows, connect to snowflake and bi, configure dbt profile, extend the ide with dbt tools
Learn core dbt concepts such as models, materialization, sources, seeds, snapshots, packages, hooks, exposures, analyses, write complex sql queries
Understand the dbt project structure and learn about dbt tips & tricks, advanced techniques and best practices, extend dbt with your own / third-party macros
Implement singular and generic dbt tests, work with additional arguments and default config values, customize dbt built-in tests
Document your models and pipeline, customize the dbt docs page, explore and analyse dependencies between transformation steps
Understand how dbt fits into the modern data stack, learn about the stages of the data-maturity model, and well functioning data architectures
Master etl/elt procedures, data transformations, modern data stack, slowly changing dimensions, common table expressions and analytics engineering
Understand what is a data warehouse, data lake, or data lakehouse and when to use which, handle data collection, data wrangling and data integrations
See how advanced testing works using dbt-expectations, a great expectations inspired testing framework
Test your knowledge with certification preparation question
Listen to real-world use-cases from industry professionals
Learn dbt orchestration best practices hands on
Show more
Show less

Syllabus

You will be familiar with the course's structure, our recommendation on how to take this course, and our instructors' professional background.

Welcome to dbt (Data Build Tool) Zero to Hero Bootcamp!

Top-down / Bottom-up course structure explanation

Understand the stages of the Data Maturity Model

dbt Mark and the dbt logo are trademarks of dbt Labs, Inc.

Feel free to skip this Lecture if you completed the Snowflake Fast track

dbt Mark and the dbt logo are trademarks of dbt Labs, Inc.

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Covers ETL/ELT procedures, data transformations, and the modern data stack, which are essential for data engineers and analysts

Explores data warehousing, data lakes, and data lakehouses, enabling learners to make informed decisions about data storage and management

Begins with setting up a development environment on Mac and Windows, which is helpful for learners with less experience

Includes dbt orchestration best practices, which are crucial for managing and automating data transformation workflows in production environments

Uses Snowflake, a popular cloud data platform, which is relevant for those working with modern data infrastructure

Requires learners to set up a development environment and connect to Snowflake, which may require additional effort and resources

Reviews summary

Comprehensive dbt bootcamp: zero to hero

According to learners, this course provides a largely positive and comprehensive journey into dbt, successfully living up to its Zero to Hero promise. Students highlight the real-world Airbnb project as particularly valuable for hands-on practice, helping to solidify understanding of core concepts and modern data stack integration. Many found the explanations clear and well-paced, suitable even for those new to dbt. A significant number of reviewers noted the course's effectiveness in preparing them for dbt certification and job interviews. The detailed setup guidance and the instructor's extensive industry experience were also appreciated. Reviews suggest the course is continuously updated, ensuring the content remains relevant.

Course content is regularly updated.

"The course is continuously updated;"

"whenever dbt publishes an update, we adjust the course accordingly."

"It's great that the course is updated with new dbt versions and features."

Detailed guidance for setting up environment.

"Set up the complete development environment on Mac & Windows."

"ESSENTIAL README: How to access course's resources and solution project"

"The step-by-step setup instructions were essential for getting started smoothly."

Effectively prepares for dbt certification.

"I managed to pass the dbt certification exam. I couldn't have done it without your help."

"The certification preparation questions were very helpful for testing my knowledge."

"This course is great prep for interviews where dbt knowledge is required."

Concepts explained clearly and effectively.

"Well-chosen examples perfectly illustrate the many features that are covered."

"The pacing is spot on and it is easy to replicate the examples."

"I love how you're explaining everything at just the right level."

"Complex topics are broken down into understandable parts."

Strong focus on practical, real-world use.

"solving a real-world problem step by step."

"construction of a complete, real-world project; Airbnb."

"Working through the Airbnb project gave me real practical skills."

"I could immediately apply what I learned in the hands-on sections."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero with these activities:

Review SQL Fundamentals

Show steps

Reinforce your SQL knowledge to better understand dbt model transformations.

Browse courses on SQL

Show steps

Review basic SQL syntax and commands.
Practice writing SQL queries on sample datasets.
Familiarize yourself with common SQL functions.

Read 'Fundamentals of Data Engineering'

Show steps

Broaden your understanding of the data engineering landscape and how dbt fits in.

View Fundamentals of Data Engineering: Plan and... on Amazon

Show steps

Read the chapters on data warehousing and data pipelines.
Study the examples of different data engineering architectures.
Relate the concepts to dbt project design.

Read 'The Data Warehouse Toolkit'

Show steps

Gain a deeper understanding of data warehousing principles and dimensional modeling techniques.

View The Data Warehouse Toolkit: The Definitive... on Amazon

Show steps

Read the chapters on dimensional modeling and star schemas.
Study the examples of different dimensional models.
Relate the concepts to dbt model design.

Four other activities

Expand to see all activities and additional details

Show all seven activities

Complete dbt Tutorial Challenges

Show steps

Reinforce your dbt skills by completing practical exercises.

Show steps

Find dbt tutorial challenges online.
Work through the challenges step-by-step.
Compare your solutions with the official solutions.

Build a dbt Project for a Sample Dataset

Show steps

Apply your dbt knowledge by building a complete project from scratch.

Show steps

Choose a publicly available dataset.
Define a set of business questions to answer.
Create dbt models to transform and load the data.
Implement tests to ensure data quality.
Document your dbt project.

Write a Blog Post on dbt Best Practices

Show steps

Solidify your understanding of dbt by sharing your knowledge with others.

Show steps

Research dbt best practices.
Choose a specific topic to focus on.
Write a clear and concise blog post.
Share your blog post on social media.

Contribute to a dbt Package

Show steps

Deepen your dbt expertise by contributing to an open-source project.

Show steps

Find an open-source dbt package on GitHub.
Identify an issue or feature to work on.
Submit a pull request with your changes.

Career center

Learners who complete The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero will develop knowledge and skills that may be useful to these careers:

Analytics Engineer

An Analytics Engineer focuses on building and maintaining data models that enable data analysis and reporting. This role is central to any organization that relies on data-driven decisionmaking. The course's emphasis on dbt fundamentals, models, materializations, and testing is directly applicable to the daily tasks of an Analytics Engineer. This position requires strong knowledge of data warehousing concepts, data transformation, and working with SQL, which are all well covered in this course. Moreover, the course's hands-on experience building a real-world project using dbt provides a significant advantage, as this allows the learner to immediately apply what they have learned. The course also helps an Analytics Engineer understand the dbt project structure and best practices.

See salaries and explore the career path for Analytics Engineer

Data Engineer

A Data Engineer designs, builds, and maintains the infrastructure that enables the collection, storage, and processing of data at scale. This role requires strong skills in database technology, data modeling, and data transformation, all of which are covered in this course. This course focuses on dbt, a core tool in a modern data engineer's toolkit. The course's hands-on approach, which includes implementing models, materializations, and tests, is valuable in this role. Furthermore, this course builds a foundation in the modern data stack and helps a data engineer understand how dbt fits in this ecosystem. The course also emphasizes setting up a development environment, which is a practical skill needed for data engineering roles.

See salaries and explore the career path for Data Engineer

Cloud Data Engineer

A Cloud Data Engineer specializes in building and managing data solutions on cloud platforms which also includes dbt. This course is directly pertinent to this role. The course focuses extensively on dbt and the modern data stack, which are central to cloud-based data management. The course helps a Cloud Data Engineer understand how dbt fits into cloud data environments and teaches them to use this tool. The development environment setup part of this course, which includes connections to Snowflake is especially relevant to Cloud Data Engineers.

See salaries and explore the career path for Cloud Data Engineer

Data Analyst

A Data Analyst interprets data and transforms it into insights to help organizations make better decisions. A Data Analyst benefits from the course's focus on data modeling because it enables them to more effectively analyze and represent data, as well as understand the transformations applied to it. The course's practical experience using dbt to work with data is directly applicable to the day-to-day of a Data Analyst, enabling them to directly work with data warehouses and data lakes. This course helps a Data Analyst understand how dbt fits into the modern data stack. By taking this course, a data analyst understands how data is shaped, cleaned, and transformed.

See salaries and explore the career path for Data Analyst

Business Intelligence Developer

A Business Intelligence Developer designs and develops the systems used to report and analyze business information. This role benefits from knowledge of data modeling, which is a focus of the course, as this helps with creating efficient and accurate reporting solutions. Proficiency in dbt, which is taught through the building of a real world project, is directly relevant to the work of a Business Intelligence Developer because it enables them to manage and transform data within the modern data stack. The course provides Business Intelligence Developers with hands-on experience and a thorough understanding of how dbt works. The course also enables them to understand which features to use at which stage of a given project.

See salaries and explore the career path for Business Intelligence Developer

Data Architect

A Data Architect designs and manages an organization's data infrastructure, ensuring it is efficient, scalable, and secure. A Data Architect will find that this course helps develop an understanding of data transformation best practices, which is critical to building well-functioning data architectures. The course's focus on the modern data stack and how dbt fits within it is also key to this role. The course covers a variety of dbt features, which can help a Data Architect make informed decisions about which tools to implement. This course may be useful for a Data Architect that wants to learn about dbt and analytics engineering.

See salaries and explore the career path for Data Architect

Data Operations Engineer

A Data Operations Engineer is responsible for ensuring the reliability and efficiency of data pipelines. This course may be useful for learning how to manage data pipelines with dbt. The course includes best practices, and advanced techniques that enable learners to scale and manage data pipelines. The course's practical focus will enable a Data Operations Engineer to learn how dbt works in the real world by working through building a real-world project. This course may be useful for a Data Operations Engineer that wants to improve their practical skills using a modern data tool.

See salaries and explore the career path for Data Operations Engineer

Data Quality Analyst

A Data Quality Analyst focuses on ensuring the accuracy, completeness, and consistency of data. This role benefits from the course's focus on testing, which is a core feature of dbt. This course teaches how to implement both generic and singular tests, as well as how to write custom tests. The focus on documenting data pipelines and lineage is also directly relevant to the responsibilities of a Data Quality Analyst. This course may be useful for a Data Quality Analyst, as it provides practical hands-on experience working with dbt to improve the quality of data pipelines.

See salaries and explore the career path for Data Quality Analyst

ETL Developer

An ETL Developer builds and maintains processes for extracting, transforming, and loading data. This role is closely related to the topics covered by this course, especially the 'ELT' method (Extract, Load, Transform). The course covers best practices for data transformations using dbt, which is central to the job of an ETL developer. This course may be useful for an ETL Developer to learn modern data transformation techniques. An ETL developer that wants to gain skills in a modern data tool can use this course to learn dbt end-to-end, which includes development environment setup.

See salaries and explore the career path for ETL Developer

Data Scientist

A Data Scientist uses statistical and machine learning techniques to analyze data and solve complex problems. This course may be useful for a Data Scientist because it helps them understand data modeling and transformation, which are essential components in data science workflows. The course's hands-on approach to using dbt is useful for creating structured and efficient data pipelines that data scientists need. The course provides a Data Scientist with valuable experience of the modern data stack. This understanding will help a Data Scientist understand how they can use dbt to manage their workflows.

See salaries and explore the career path for Data Scientist

Database Administrator

A Database Administrator manages and maintains database systems, ensuring their security, performance, and availability. This course may be useful for a Database Administrator, who will find that it helps them understand data models and data transformations, enabling them to better manage the data within databases. Although, this course does not focus on the daily tasks of a Database Administrator, it can help them better understand the modern data stack. The course's focus on practical problem solving using dbt will also help a Database Administrator understand how to manage pipelines that use this tool.

See salaries and explore the career path for Database Administrator

Database Developer

A Database Developer designs, develops, and implements databases. This course focuses on data modeling and transformations, which are important concepts to this role as well. The course specifically focuses on using dbt to build data pipelines, which gives a Database Developer insights into how data can be managed and transformed. While the course focuses on data use cases outside the scope of traditional database development, this course may be useful for a Database Developer to expand their knowledge to the broader modern data stack as well, and to learn practical skills. The course focuses on working with SQL and data warehouses, which are important skills for this role.

See salaries and explore the career path for Database Developer

Machine Learning Engineer

A Machine Learning Engineer builds and deploys machine learning models. While this course doesn't directly focus on model building, it may be useful to a Machine Learning Engineer because it provides a strong foundation in data wrangling and transformation, which are crucial steps in the machine learning pipeline. This course covers practical problem solving with dbt, which may be relevant to Machine Learning Engineers as they build data pipelines. The course also introduces the modern data stack. Understanding this ecosystem helps a Machine Learning Engineer build well-integrated solutions.

See salaries and explore the career path for Machine Learning Engineer

Business Analyst

A Business Analyst analyzes business processes and systems to find improvements, and this role requires an understanding of data modeling and data transformation, both of which are covered in this course. Although not the primary focus of this course, a Business Analyst will find that understanding these concepts will help them understand how data is used within an organization. The course's focus on data maturity models and data architecture is also useful in this role. This course may be useful for a Business Analyst who wishes to improve their technical skills and deepen their understanding of the modern data stack.

See salaries and explore the career path for Business Analyst

Reporting Analyst

A Reporting Analyst creates reports and dashboards that help businesses track performance and make decisions. This role benefits from an understanding of data modeling and transformation, which are covered in this course. The course focuses on using dbt to build data pipelines, which helps a Reporting Analyst understand how data flows through an organization. While it does not directly address best practices for reporting and dashboards, this course may be useful for a Reporting Analyst to gain knowledge on how data is prepared for reporting purposes and also gain practical skills to perform transformations.

See salaries and explore the career path for Reporting Analyst

The Complete dbt (Data Build Tool) Bootcamp

Zero to Hero

What's inside

Learning objectives

Syllabus

Traffic lights

Save this course

Reviews summary

Comprehensive dbt bootcamp: zero to hero

Activities

Career center

Reading list

Share

Similar courses