DBT training:
basic intensive course

DBT training:
basic intensive course

Learn how to use DBT (Data Build Tool) for data transformations with this DBT training

With our expert-led DBT training program,
designed to equip you with cutting-edge skills in modern application deployment and management.
Benefit from our wealth of experience from countless customer projects:

In this DBT Course you will experience a balanced mix of theory, live demonstrations and practical exercises.

Learn the fundamentals and architecture of DBT, understanding the role of an Analytic Engineer, workflow management and setup.

Learn how to use Jinja templating in DBT, create and manage models, perform tests to ensure data quality, documentation and metadata management

Get to know how to integrate DBT with other tools like Airflow and Dagster, as well as refactor and optimize DBT projects.

DBT Training – Upcoming Dates

Coming Soon

In this DBT Training, you will learn …

… how to use DBT (Data Build Tool) for data transformations. This includes the fundamentals and architecture of DBT, understanding the role of an Analytic Engineer, workflow management and setup, using Jinja templating in DBT, creating and managing models, performing tests to ensure data quality, documentation and metadata management, using hooks and data observability, integrating DBT with other tools like Airflow and Dagster, as well as refactoring and optimizing DBT projects.

Practical Applications That We Will Cover in the DBT Training:

  • 1
    Setting up and configuring DBT projects.
  • 2
    Using Jinja for dynamic SQL generation.
  • 3
    Implementing and testing data models.
  • 4
    Creating documentation and managing metadata.
  • 5
    Performing data quality tests.
  • 6
    Using hooks for additional SQL commands.
  • 7
    Integrating DBT with Airflow for workflow management.
  • 8
    Refactoring DBT projects to optimize data pipelines.

After the Data Build Tool Training, You Will Be Able To:

  • 1
    Set up and configure DBT projects.
  • 2
    Create and transform data models.
  • 3
    Use SQL and Jinja for advanced data transformations.
  • 4
    Ensure data quality through testing and validation.
  • 5
    Create and maintain documentation for DBT projects.
  • 6
    Optimize and automate workflows.
  • 7
    Integrate DBT into existing ELT, MLOps, or analytics pipelines.
  • 8
    Apply practical applications and best practices for DBT.

This DBT course is perfect for you if…

  • You are a data analyst, data engineer, or BI developer.
  • You have SQL knowledge and want to perform data transformations.
  • You want to optimize and automate existing data pipelines.
  • You are interested in integration and improvement of data quality.
  • You want to learn about modern data warehousing and ETL concepts.

The DBT Training is NOT suitable for you if …

  • You have no knowledge of SQL or are unwilling to learn it.
  • You are not interested in data transformations or analyses.
  • You have no knowledge or interest in modern data warehousing and ETL

Agenda

  • DBT Concepts
    •  DBT Intro
    • DBT Architecture and Components
    • Recap: Data Architecture
    • Setup, Configuration and Structure
    • DBT Workflow
  • Deep Dive DBT Structure
    • DBT CLI Basics and Advanced Commands
    • Configuration Commands and Selectors
  • Jinja
    • Basics Jinja
    • Jinja for DBT
  • Modeling in DBT
    • Modeling Concepts and Types
    • Transformation Layers and Naming Conventions
    • Incremental Materialization Strategies
    • Performance Optimizations
  • Seeds, Snapshots & Packages
    • DBT Seeds
    • DBT Snapshots
    • DBT Packages
  • Testing in DBT
    • DBT Data Tests
      • Unit tests in DBT
  • Documentation
  • Hooks
    • Using Hooks in DBT
      • Best Practices and Order of Execution

Additional to Basic Training Agenda

  • Data Observability
    • Data Observability
    • DataOps and Model Contracts
  • Orchestration
    • Get to know Airflow
    • Deploy DBT with Airflow
  • Your Topics
    • Your ecosystem
    • Your best practises
    • further frameworks and hands-on according to your requirements

What other participants of the DBT course say

I am already an experienced Data Engineer, but the DBT course really took my skills to the next level. The practical exercises on setting up DBT projects and optimizing data models were particularly helpful. The combination of SQL and Jinja for complex data manipulations was exactly what I was looking for. I highly recommend it to anyone looking to deepen their knowledge in modern data warehousing techniques.

– Fabian Link

As a BI Developer, I was looking for a course that not only taught theoretical concepts but also provided practical applications. The DBT course exceeded my expectations. I found the integration of DBT with Airflow for workflow management and the opportunities for automating data pipelines particularly valuable. The course content was well-structured and the instructors highly competent. I was able to apply what I learned directly in my work environment. Highly recommended for anyone looking to expand their BI skills.
– Wiegand Baumgartner

Your investment

2299 €plus VAT
  • 20 hours of concentrated basic knowledge
  • Combination of theory and practice with live demos and exercises to actively develop skills.
  • Learn how to use DBT (Data Build Tool) for data transformations, including the fundamentals and architecture, workflow management and setup.
  • Learn how to use Jinja templating, create and manage models, use hooks and integrate DBT with other tools like Airflow and Dagster.
Book now

Get to know your DBT Training professionals

Marvin Taschenberger

Professional Software Architect, Ultra Tendency

Hudhaifa Ahmed

Senior Lead Big Data Developer & Berlin Territory Manager, Ultra Tendency

Matthias Baumann

Chief Technology Officer & Principal Big Data Solutions Architect Lead, Ultra Tendency