dbt
Learn
11 March, 2024 – Virtual
Welcome to our dbt Learn course! With this open-source piece of magic, you can transform data in warehouses simply with the power of SQL select statements. You will learn about modeling strategies, automated testing, and performance optimization.
Looking to upskill your team(s) or organization?
Nico will gladly help you further with custom training solutions.
Nico de Jonge
Data and AI Training Advisor
Duration
3 days
Time
13:00 – 17:00
Language
English
Lunch
Excluded
Certification
Yes
Level
Professional
What will you learn?
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.
Key takeaways
dbt Foundations
- 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.
dbt Applications
- Leverage Jinja and Macros to write DRY code.
- Creator and implement existing packages to create robust, scalable projects.
- Deploy your dbt Project to run on a schedule with dbt Cloud.
Program
The initial two days focus on establishing a solid foundation in analytics engineering. Participants will learn about the pivotal role of an analytics engineer, and delve into distributed dbt norms. They will grasp the fundamentals of dbt and gain proficiency in project design. Additionally, attendees will be taught how to rigorously test transformations and source data, a crucial aspect of data reliability.
The third day of the program concentrates on practical applications of dbt. Attendees will refine their dbt projects, gaining expertise in using Jinja within dbt for more complex transformations. They will also learn how to leverage packages and tasks effectively. The curriculum covers the strategic utilization of dbt Materializations, a key concept in data modeling. Participants will understand the concept of incremental models and discern the scenarios where they offer the most benefit. Moreover, an overview of various data warehouses will be provided, ensuring participants are well-versed in different environments. The day culminates with an exploration of advanced techniques in the field of analytics engineering.
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.
- 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
- Polishing your dbt project
- Using Jinja within dbt
- How to use packages and projects
- When and where to use dbt Materializations
- Incremental Models and where to use them
- Techniques of the trade: Top 10 advanced tips to continue learning
Who is it for?
This training is perfect for anyone wanting to become proficient in data engineering and leverage the power of dbt, especially analytics engineers, data engineers, and BI professionals. The training program will equip you with the knowledge needed to excel in the field of data engineering.
Requirements
Basic knowledge of data engineering concepts and experience with SQL will be necessary.
Why should I follow this training?
Build robust data models
Write advanced SQL statements
Leverage Jinja and Macros for efficient code
Deploy dbt Projects on a schedule
Exam and Certification
After the training you will be invited to complete the dbt Fundamentals quiz, after which you will receive a 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, we will ask you about any dietary requirements and share literature if you need to prepare.
See you soon!
Course information
All literature and course materials are included in the price.
All literature and course materials are included in the price.
After registering for this course, you will receive a confirmation email with practical information.
Meet the trainer
Lucy Sheppard
Meet Lucy Sheppard, trainer at Xebia Academy. Lucy is a data science trainer and teaches many Python courses as well as dbt Learn.
Also interesting for you
View all training coursesTransform into a certified Data Scientist in just 12 weeks. This boot camp will kick-start your Data Science career with Python.
Increased your PowerBI knowledge with DAX & Data Modeling. Get started now!
