DBT training:
basic course

DBT training:
basic intensive course

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
Choose customized

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

09. – 13.12.2024

DBT Basics in one week

in 4-hour units over 5 days

Mon – Fri (09:00 – 13:00)

13. – 17.01.2025

DBT Basics in one week

in 4-hour units over 5 days

Mon – Fri (09:00 – 13:00)

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

Training

For small companies and teams that are new to the topic.

  • DBT Intro
  • DBT Architecture and Components
  • Recap: Data Architecture
  • Setup, Configuration and Structure
  • DBT Workflow

  • DBT CLI Basics and Advanced Commands
  • Configuration Commands and Selectors

  • Basics Jinja
  • Jinja for DBT

  • Modeling Concepts and Types
  • Transformation Layers and Naming Conventions
  • Incremental Materialization Strategies
  • Performance Optimizations

  • DBT Seeds
  • DBT Snapshots
  • DBT Packages

  • DBT Data Tests
  • Unit tests in DBT

  • Using Hooks in DBT
  • Best Practices and Order of Execution

Customized

For large companies and teams that want to master special challenges.

  • Data Observability
  • DataOps and Model Contracts

  • Get to know Airflow
  • Deploy DBT with Airflow

  • Your ecosystem
  • Your best practices
  • further frameworks and hands-on according to your requirements

  • DBT Intro
  • DBT Architecture and Components
  • Recap: Data Architecture
  • Setup, Configuration and Structure
  • DBT Workflow

  • DBT CLI Basics and Advanced Commands
  • Configuration Commands and Selectors

  • Basics Jinja
  • Jinja for DBT

  • Modeling Concepts and Types
  • Transformation Layers and Naming Conventions
  • Incremental Materialization Strategies
  • Performance Optimizations

  • DBT Seeds
  • DBT Snapshots
  • DBT Packages

  • DBT Data Tests
  • Unit tests in DBT

  • Using Hooks in DBT
  • Best Practices and Order of Execution

Hear from our satisfied training attendees

A1 Telekom Austria AG

Reinhard Burgmann
Head of Data Ecosystem

„UTA coached my team along the development process of the migration plan of our on premises data lake to the public cloud.

The outstanding level of expertise, both on a technical and organizational level, ensured a well-structured and realistic migration plan including timeline, milestones, and efforts.

The enablement of my team was at the center of a very smooth collaboration. Through UTA, we achieved our goal faster and reduced risks of the migration project significantly.

I highly recommend UTA’s services!“

Vattenfall

Bernard Benning
BA Heat

„I recently attended Vattenfall IT’s online Kafka training day hosted by Ultra Tendency, and it was an enriching experience.

The trainer, Ahmed, did a fantastic job explaining the theory behind Kafka, and the emphasis on practical application was great. The hands-on programming exercises were particularly helpful, and I’ve never experienced training with so many interactive examples!

Overall, I highly recommend this training to anyone who wants to improve their Kafka knowledge interactively and gain valuable skills.“

VP Bank

Eisele Peer
Lead Architect & Head of IT Integration & Development

“The MLOps training exceeded our expectations!

It offered a perfect blend of an overview, hands-on coding examples, and real-world use cases. The trainer answered all questions competently and adapted the content to fit our company’s infrastructure.

This training not only provided us with knowledge but also practical skills that we can apply immediately.“

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

Required hardware & infrastructure for your DBT Training

  • You will need a PC or Mac with a web browser and MS Teams.
  • During the training, we will provide you with a virtual machine with the required local dependencies, services and root access.
  • This VM has a running Kubernetes cluster on which you can test and execute the training instructions.
  • You can access the machine via a browser or SSH if you wish and the network restrictions allow it.