Register for dbt Data Transformation Course
Master data transformation with our 30-hour expert-led course. Limited spots available!
Sign Up Now
Complete the form below to reserve your place. An invoice will be sent to your email from registration.confirmation@braintechblueprint.co.uk with payment details.
By registering, you agree to our Terms & Conditions and Privacy Policy. An invoice will be emailed to you shortly.
Why Join the dbt Data Transformation Course?
This 30-hour training program is designed for data analysts and engineers aiming to build scalable data pipelines using dbt. With hands-on labs and real-world projects, you’ll gain practical skills to excel in analytics engineering.
- Duration: 30 hours of expert-led training
- Level: Intermediate to Advanced
- Format: Online, self-paced with live Q&A sessions and instructor support
- Tools: dbt Core, dbt Cloud, SQL, Snowflake/BigQuery/Redshift
- Certification: Earn a Certificate of Completion recognized by top employers
- Support: Access to a private community and 1:1 mentorship options
Investment: £750
An invoice will be sent to your email from registration.confirmation@braintechblueprint.co.uk with payment instructions.
What You’ll Master
Introduction to dbt
- Overview of dbt and its role in analytics engineering
- Key concepts: Models, Materializations, and Jinja
- Comparing dbt Core vs. dbt Cloud
- Hands-on exercise: Setting up a dbt project locally
- Understanding the dbt workflow: Build, Test, Document
- Real-world use case: Transforming raw sales data
Data Modeling with dbt
- Building modular and reusable SQL models
- Using materializations: Table, View, Incremental, Ephemeral
- Hands-on lab: Creating a staging model from raw data
- Leveraging Jinja for dynamic SQL generation
- Best practices for naming conventions and file structure
Testing and Documentation
- Writing data tests: Unique, Not Null, Relationships
- Hands-on lab: Adding tests to a dbt project
- Creating custom tests with macros
- Generating and hosting dbt documentation
- Ensuring data quality and reliability
Advanced dbt Features
- Using snapshots for tracking data changes over time
- Hands-on lab: Implementing a snapshot for audit tracking
- Advanced Jinja: Loops, conditionals, and macros
- Managing dbt packages for reusable code
- Optimizing performance with incremental models
Integrating dbt with Data Warehouses
- Connecting dbt to Snowflake, BigQuery, or Redshift
- Hands-on lab: Setting up dbt with a cloud data warehouse
- Integrating dbt with orchestration tools like Airflow
- Managing credentials and profiles in dbt
- Deploying dbt in production environments
Why Choose This Course?
- Led by dbt experts with 10+ years of analytics experience
- Hands-on labs with real-world datasets (e.g., sales, financial)
- Flexible online format tailored to your schedule
- Build a portfolio with 3+ practical projects
- Prepares you for dbt certification and career advancement
- Lifetime access to course updates
Ready to Master dbt?
Spots are limited due to our personalized support model. Register now to receive your invoice!
Register Now