The Complete dbt (Data Build Tool) Bootcamp: Zero to Hero
What you'll learn
- 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
- Basic SQL experience
- No previous programming language experience required
- Working computer (Mac/Windows/Linux)
- Network access whitelist to snowflake(.com) and GitHub if you work behind a firewall or VPN
- Git and Python (We are linking to the installation instructions of these tools in the course)
This is the only course you'll need to take to get started with dbt and Analytics Engineering!
Greetings to the MOST COMPLETE, CONTINUOUSLY UPDATED independent dbt™ (Data Build Tool) software course in the world - as of 2022! This course is both the TOP RATED and the BESTSELLER dbt course on Udemy!
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 is 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 learned about the pieces, we are going to 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.
Added Great Expectations and test debugging sections - Sep 2022
Radically simplified Windows installation instructions (no WSL needed anymore) - Sep 2022
The course is tested in dbt cloud - Aug 2022
Added Modern Data Stack overview - Jun 2022
Among several other topics, the theoretical section puts special emphasis on transferring knowledge in the following areas;
Well-functioning Data Architectures
Data Warehouses, Data Lakes, and Data Lakehouses
ETL and ELT procedures and Data Transformations
Fundamentals of dbt (Data Build Tool)
Modern Data Stack
Slowly Changing Dimensions
Once we understood the theoretical layer and how dbt fits into the picture, we are going to start building out a dbt project from scratch, just as you would do this in the real world.
The practical section will go through a real-world Airbnb project where you will master the ins and outs of dbt! 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
Once we are ready - among several other technical topics, the following features will be covered;
dbt Sources, Seeds, Snapshots
dbt Hooks and Operations
Jinja and Macros
Data Visualization (Preset)
Working with Great Expectations (dbt-expectations)
Debugging tests in dbt
Once the theory and the practical stages are finished, we are going to 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?
... and anyone who interacts with data lake/data warehouse/data lakehouse or uses SQL!
Course Level Explained (Zero > Hero)
The course doesn't have any 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 having completed 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 are going to be next to you along the journey and you have our absolute support!
When the Airbnb project is presented to you, you have to do it in its entirety, 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 about 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.
Who this course is for:
- Analytics Engineers
- Data Analysts
- BI Analysts
- Data Scientists
- Data Engineers
I help global companies build web-scale data analytics and AI systems. Backed by 20 years of experience in developing data-intensive applications, I spend most of my time helping companies kick-off and mature their data analytics and AI infrastructure, and give Cloud, Apache Spark, Databricks and MLOps courses regularly.
Earlier I built Prezi's big data analytics infrastructure, later led Prezi’s data engineering team, scaling it to serve 60 million users backed by a data volume over a petabyte. I also worked on kicking off the Spark integration component in RapidMiner, a global leader in predictive analytics.
Besides working with data analytics architectures, I enjoy teaching at Central European University, one of the best independent universities in Europe, and delivering courses and professional services engagements on behalf of Databricks, the company created by the original authors of Spark.
I work as an Expert Data Engineer and Solutions Architect. In parallel, I am a Real-time Data Processing, Big Data & Cloud Computing, Data Platform, and Use Case Seminar TA of Zoltan’s data courses at Central European University, one of the best independent universities in Europe. I used to work as a Senior Data Engineer and Technical Instructor at Databricks, and as a Data Engineering Consultant at Datapao - a Data and Cloud service company covering data and cloud transformation journeys from enablement through architecture to implementation. I have experience developing data-intensive applications, data infrastructures, data platforms, handling cloud migrations, and delivering technical courses on behalf of Datapao, and Databricks - the original creators of Apache Spark. I co-founded NordQuant with Zoltan C. Toth, a company under which we create top-notch dbt (Data Build Tool) and other technical courses.