What is the price of the Training dbt - Master SQL Data Pipelines training?

The price of the Training dbt - Master SQL Data Pipelines training is 3150 € HT. This includes access to all modules, training materials and personalized support. Funding solutions are available through OPCO.

Is the training Qualiopi certified?

Yes, Learni is a Qualiopi-certified training organization. This certification guarantees the quality of our courses and enables funding through OPCO and other mechanisms.

What is the duration of the Training dbt - Master SQL Data Pipelines training?

The Training dbt - Master SQL Data Pipelines training takes place over 21 hours. The program is structured in progressive modules for optimal skill development.

How can I fund my training?

Our courses are eligible for OPCO funding. Learni supports you through the funding process. A personalized quote is available upon request.

What are the prerequisites for this training?

The prerequisites for the Training dbt - Master SQL Data Pipelines training are: Basic knowledge of SQL, familiarity with a data warehouse like BigQuery or Snowflake.. A preliminary interview validates your eligibility.

Is the training available in person?

Yes, the Training dbt - Master SQL Data Pipelines training is available in in-person. The format can be adapted to your needs (inter, intra, custom).

Training dbt - Master SQL Data Pipelines | Learni

The story of Learni

Founded by passionate advocates of learning and innovation, Learni set out to make professional training accessible to everyone, everywhere in the world. Our team works in the largest cities such as Paris, Lyon, Marseille, and internationally, to support talents and organizations in their skills development.

Configure your training

Response within 24hNo commitment100% free

9 spots remaining for the next session

FormatParticipantsDateDetails

Which format do you prefer?

Methods, approaches, and teaching resources

The Training dbt - Master SQL Data Pipelines training is delivered in-person or remotely (blended-learning, e-learning, virtual classroom, remote in-person). At Learni, a Qualiopi-certified training organization, each program is designed to maximize skills acquisition, regardless of the training mode chosen.

The trainer alternates between demonstrative, interrogative, and active methods (through practical exercises and/or real-world scenarios). This pedagogical approach ensures concrete and directly applicable learning in the workplace.

Teaching resources provided

To ensure the quality of the Training dbt - Master SQL Data Pipelines training, Learni provides the following teaching resources:

Mac or PC computers, high-speed fiber internet, whiteboard or flipchart, video projector or interactive touchscreen (for remote sessions)
Training environments installed on workstations or accessible online
Course materials, practical exercises, and supplementary resources
Post-training access to materials and teaching resources

For in-house training at a location external to Learni, the client ensures and commits to having all necessary teaching materials (IT equipment, internet connection...) for the proper conduct of the training action in accordance with the prerequisites indicated in the communicated training program.

* contact us for remote feasibility** ratio varies depending on the training followed

Assessment methods

The assessment of skills acquired during the Training dbt - Master SQL Data Pipelines training is carried out through:

During training: case studies, practical exercises, and professional scenarios
At the end of training: self-assessment questionnaire and skills evaluation by the trainer
After training: training completion certificate detailing acquired skills

Training accessibility

Learni is committed to the accessibility of its professional training programs. All our training programs are accessible to people with disabilities. Our teams are available to adapt teaching methods to your specific needs. Do not hesitate to contact us for any accommodation request.

Training access terms and deadlines

Training objectives

Discover the fundamental concepts of dbt and its modular architecture.

Install and configure a dbt project with CLI and profiles.

Create reusable SQL models and apply automated tests.

Master macros, seeds, and snapshots for robust pipelines.

Implement references and exposures for clear documentation.

Deploy and debug a complete dbt project in a team.

Training program

Module 1Introduction to dbt: installation and first models (CLI, YAML, SQL)

Dive into dbt from the morning by installing the tool via pip, configure your first project with a BigQuery profile, write your first simple SQL models, test them live with dbt run and dbt test, explore the YAML schema structure, complete a concrete exercise on an e-commerce dataset to transform raw tables into ready-to-use analytical views, while enjoying immediate productivity gains.

Module 2Advanced models and tests: macros, seeds, snapshots (dbt core features)

Take it to the next level by creating custom macros to reuse complex SQL code, import CSV seeds for reference data, configure snapshots to track historical changes, apply generic and singular tests on your models, work on a real customer analysis case with dbt compile and dbt run, produce a visual dependency DAG with dbt docs generate, and experience the power of an automated workflow that boosts your daily efficiency.

Module 3Complete pipelines: references, exposures, and deployment (dbt strategies)

Finalize your mastery by implementing {{ ref() }} references to dynamically link models, define exposures to document BI usage, integrate community packages like dbt-utils, deploy via dbt Cloud or Git, debug common errors with dbt debug, build a final project on a complete marketing dataset with full run and HTML docs generation, and leave with a concrete portfolio ready to impress your colleagues.