Opleiding: Public dbt Learn
Own the workflow!
This three-day training program is packed with all the ins and outs to learn and improve your dbt (data building tool) skills. With this open-source piece of magic, you will be able to transform data in warehouses with simple statements. Modeling strategies, automated testing, and performance optimization will be in your toolkit afterward. A verified dbt Learn Certificate is included!
This training is for you if...
- You or your team use dbt or are in the process of using it.
- You want to learn the hottest tool for modeling data.
- You want ownership of your data work.
- You want to be added to automatically receive the dbt Fundamentals badge.
This training is not for you if...
- You want to learn how to use Python to explore data (check out the Python for Data Analysis training instead)
- You have no intention of ever working with dbt.
- You have no experience with SQL.
What you'll learn
- Build models to shape your data from raw data to transformed data.
- Configure and run tests on your data to meet your expectations.
- Write, generate, and view documentation while you develop.
- Deploy your dbt Project to run on a schedule with dbt Cloud.
- Leverage Jinja and Macros to write DRY code.
- Learn about how dbt interacts with Data Warehouse and BI Tools.
Program
Day One & Two: Foundations
- Learn about the role of an analytics engineer.
- Distributed dbt Learn norms.
- Fundamentals of dbt and Project Design.
- Learn how to test your transformations and source data.
- Document your transformations to improve collaboration.
- Deploy your dbt projects.
Day Three: Applications
- Polishing your dbt project.
- Using Jinja within dbt.
- How to use packages and projects.
- When and where to use dbt Materializations.
- What incremental Models are and where we can use them.
- An overview of the different data warehouses.
- Techniques of the trade.
After the training you will be able to:
- Use SQL select statements to build robust models for your data.
- Use jinja to create scalable and advanced SQL statements.
- Take part in the dbt community by sharing knowledge.
- You will be invited to complete the dbt Fundamentals quiz, after which you will receive a dbt Fundamentals certification and badge!
Data Engineering Trainers
This Data Engineering training is brought to you by our training partner, Xebia Data. Xebia Data works with experts in their field who are always on the lookout for the most innovative ways to get the most out of data. Your trainer is a data guru who enjoys sharing his or her experiences to help you work with the latest tools. Xebia Data is part of Xebia, just like Xebia Academy.
Yes, I want to know more about dbt!
After registering for this training, you will receive a confirmation email with practical information. A week before the training we share literature if there's anything you need to prepare. See you soon and happy learning!
