AI-powered learning
Save this course
Learn Data Build Tools ( DBT )
Gain insights into setting up dbt, managing models, and leveraging features like data testing. Delve into efficient data pipelines and improve data workflows in this data build tools course.
4.5
64 Lessons
10h
Join 2.9 million developers at
Join 2.9 million developers at
LEARNING OBJECTIVES
- Working knowledge of dbt fundamentals and project structure
- Hands-on experience building effective dbt project architectures
- An understanding of advanced dbt features for data quality and automation
- Familiarity with external data sources and loading data to dbt projects
- Hands-on experience creating and using dbt packages for reusability and collaboration
Learning Roadmap
1.
Introduction to dbt and Its Setup
Introduction to dbt and Its Setup
Get familiar with dbt's role in data transformation, connecting with BigQuery, and project setup.
2.
Overview of the Project Architecture
Overview of the Project Architecture
Look at configuring profiles, folder paths, model settings, and accessing compiled code in dbt projects.
3.
Models
Models
9 Lessons
9 Lessons
Go hands-on with creating, referencing, and organizing SQL models, configurations, schemas, and Python models in dbt.
4.
Sources
Sources
5 Lessons
5 Lessons
Grasp the fundamentals of setting up and referencing sources, using seeds, and querying datasets.
5.
Materializations
Materializations
8 Lessons
8 Lessons
Map out the steps for materializing views, tables, incremental models, and ephemeral models in dbt.
6.
Dynamic Models with Jinja
Dynamic Models with Jinja
11 Lessons
11 Lessons
Focus on leveraging Jinja in dbt for dynamic models with variables, loops, and macros.
7.
Packages
Packages
7 Lessons
7 Lessons
Build on the use and creation of dbt packages to streamline and enhance projects.
8.
Advanced dbt Concepts
Advanced dbt Concepts
12 Lessons
12 Lessons
Sharpen your skills in advanced dbt concepts for data validation, environment management, and documentation.
Certificate of Completion
Showcase your accomplishment by sharing your certificate of completion.
Complete more lessons to unlock your certificate
Developed by MAANG Engineers
ABOUT THIS COURSE
This course offers a comprehensive introduction to data build tools (dbt), a powerful data transformation tool that streamlines the development and management of data pipelines. You will learn to set up and configure dbt projects, create and manage models, work with data sources, and leverage advanced features like data testing, targets, and snapshots.
The course covers various topics, from the basics of dbt to more advanced concepts. You will gain hands-on experience through coding challenges and quizzes, reinforcing your understanding of the material. By the end of the course, you will be well-equipped to build efficient and maintainable data pipelines using dbt.
Whether you are a data engineer, analyst, or data scientist, this course will equip you with the skills and knowledge to leverage dbt to its full potential. You will learn to improve data quality, automate data workflows, and collaborate effectively within your team.
ABOUT THE AUTHOR
Marie Truong
Analytics Engineer @ Scopely | Loves sharing knowledge through blog articles and courses
Trusted by 2.9 million developers working at companies
A
Anthony Walker
@_webarchitect_
E
Evan Dunbar
ML Engineer
S
Software Developer
Carlos Matias La Borde
S
Souvik Kundu
Front-end Developer
V
Vinay Krishnaiah
Software Developer
Built for 10x Developers
No Passive Learning
Learn by building with project-based lessons and in-browser code editor
Personalized Roadmaps
The platform adapts to your strengths & skills gaps as you go
Future-proof Your Career
Get hands-on with in-demand skills
AI Code Mentor
Write better code with AI feedback, smart debugging, and "Ask AI"
MAANG+ Interview Prep
AI Mock Interviews simulate every technical loop at top companies
Free Resources
