What You'll Learn
An intensive live training to master dbt and transform how you work with data
Installation & Setup
Learn to install and configure dbt with DuckDB
Data Modeling
Build efficient SQL models and understand materializations
Data Testing
Implement data tests and freshness checks
Macros & Reuse
Create and reuse code using macros and variables
Best Practices in dbt
Learn best practices for scalable dbt projects
Performance Optimization
Improve performance and reduce costs in your warehouse
dbt Scalability
Structure dbt projects to scale with the company
Course Tools
Learn to use the top tools in the modern data stack
dbt
Transform data with SQL
GitHub
Collaboration and version control
VS Code
Powerful dbt code editor
Snowflake
Cloud-based data storage and processing
Agenda
What you’ll learn
- ▸ Intro to dbt
Overview of dbt, its purpose and role in the modern data stack.
- ▸ Setup and Snowflake connection
How to start a dbt project and securely connect to Snowflake.
- ▸ Sources and seeds
Creating sources and using seed data.
- ▸ Models
How to crete and structure dbt models and apply modular best practices.
- ▸ Tests
Data tests and unit tests, and how to integrate them into your workflow.
- ▸ Macros
Automation and logic reuse with macros.
- ▸ Documentation
Generating automatic documentation and exploring dbt docs.
Prerequisites
To get the most from this course, make sure you have the following:
SQL
Basic SQL knowledge
Git
Familiarity with Git
Python
Python installed
Text Editor
VSCode or similar
What's Included
When you enroll in this course, you get access to exclusive benefits that enhance your learning experience.
Participation Certificate
Validate your skills with a personalized certificate from DataGym.io.
Lifetime Access to the Discord Community
Keep engaging with other students and stay updated even after the course ends.
30 Days of Exclusive Support
Ask questions directly to a dbt Labs award-winning expert in dedicated course channels.
Access to Course Materials
Recording and project available for 60 days after the course.
Discount on the Next Bootcamp
Receive exclusive coupons to keep growing with advanced training.
Always up-to-date
All course content is reviewed to reflect best practices and the latest dbt updates.
Your Instructor
Learn from someone with real-world experience
Bruno Souza de Lima
dbt Tech Lead & dbt Community Spotlight
The only representative from Latin America to receive the dbt Community Award in 2023 and 2024, one of the most prestigious global recognitions from dbt Labs, awarded annually to only 10 people worldwide for their active contribution, community impact, and technical leadership.
Works as a Lead Data Engineer and dbt Tech Lead at phData, a consulting firm recognized as dbt Partner of the Year for two consecutive years. Has implemented scalable data modeling solutions in large-scale projects, impacting companies across various industries.
Serves as a dbt instructor in Zach Wilson’s Data Engineering course, one of the most respected educational references in the field, and has taught dbt to hundreds of professionals around the world. Holds two official dbt Labs certifications: Analytics Engineering and Cloud Administrator.
Spoke at Coalesce, the flagship global event hosted by dbt Labs, and organizes in-person dbt meetups in Brazil, helping strengthen the community in São Paulo and Florianópolis. He is also recognized for his dbt content creation on LinkedIn, where he shares real-world experiences and best practices with the data community.
Invest in your career
Secure your spot in this exclusive course
[India] dbt Workshop
⏳ Limited seats available
No subscription
- 3 hours of live training
- Participation Certificate
- Lifetime Access to the Discord Community
- 30 Days of Exclusive Support
- Access to Course Materials
- Discount on the Next Bootcamp
- Always up-to-date
Frequently Asked Questions
Clear up your questions about the course
Still have questions? Contact us by email at info@datagym.io