dbt Learn Voeg toe aan favorieten

About Xebia Academy
We are Xebia Academy! A Leading Global Training Company in Agile, Cloud, Data and AI, DevOps, Leadership, Intelligent Automation, Microsoft, Product Management, Scrum, Security and Software Development. Learn from the best trainers and let us help you take your digital transformation to the next level.

What will you learn?

After the training, you will be able to:

• Write select statements in SQL to build robust models for your data
• Design configurations to change the materialisations of each model
• Combine Jinja and SQL to create scalable and advanced models
• Take part in the dbt community through sharing knowledge

Studiewijze
Program

By the end of this program, participants will have acquired a robust skill set in analytics engineering using dbt, enabling them to tackle real-world data challenges confidently.

Resultaat
Earn the dbt fundamentals badge Learn with hands-on real life examples – learn today apply tomorrow! Become confident in the hottest data modeling tool
Programma
Session 1

dbt Fundamentals

• The role of an analytics engineer
• Fundamentals of a dbt project including best practices
• Models to shape data from raw data to transformed data
• Write, generate, and view documentation while you develop

Session 2

dbt Project Design

• Learn how to test your transformations and source data
• Write, generate, and view documentation while you develop
• Using dbt Cloud and other options to deploy your dbt projects
• Best practices in dbt project design

Session 3

dbt Applications

• Combining Jinja and SQL within dbt
• The use of packages and projects
• The four dbt materializations
• What incremental Models are and where we can use them
• Techniques of the trade: Top 10 advanced tips to continue learning

Doelgroep
This training is for you if:

• You or your team is using or about to start using dbt
• You want to learn the hottest tool for modeling data
• You want ownership when it comes to working with your data
• You want to automatically be added to gain the dbt Fundamentals badge

This training is not for you if:

• You want to learn how to use Python to explore data (see Python for Data Analysis)
• You have no experience working with SQL (see SQL for Data Analysis)
• You do not work with data in a SQL data warehouse
• You will not be working with dbt after the training

The dbt Fundamentals badge

After the training you will be invited to complete the dbt Fundamentals quiz, after which you will receive the dbt Fundamentals certification and badge!

What else should I know?

After registering for this training, you will receive a confirmation email with practical information. A week before the training, the trainer will get in touch to ask you about any requirements you may have and any pre-course tasks you will need to do.

See you soon!