Formation en IA & Data: DBT (Data Build Tool) – Transforming Your Data with Versioned SQL - Ascent Formation
Back to trainings
IA & Data

DBT (Data Build Tool) – Transforming Your Data with Versioned SQL

2 jour(s)14h

Description

Master DBT to design, test, and document robust, versioned, and industrializable data transformation pipelines in a modern ELT environment.

Learning Objectives

  • Understand the philosophy of DBT and the Analytics Engineering approach
  • Install and configure a DBT project (Core / Cloud)
  • Create and organize SQL models (models, sources, seeds, snapshots)
  • Implement tests and automated documentation
  • Use Jinja and macros to industrialize transformations
  • Integrate DBT into a CI/CD pipeline
  • Build a complete DBT project on a data warehouse

Target Audience

Data Engineers
Data Analysts
Analytics Engineers

Prerequisites

Strong SQL skills
Knowledge of data warehouse fundamentals (Snowflake, BigQuery, Redshift, etc.)
Basic understanding of Git is recommended

Program Outline

Informations

Duration

2 jour(s)

14h

Tarif

Sur demande

    DBT (Data Build Tool) – Transforming Your Data with Versioned SQL | Ascent Formation | Ascent Formation