Data Warehousing and Data Modeling 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:

• Design a data warehouse that is tailored to business requirements.
• Tackle common performance issues in modern data warehouses to ensure optimal functionality and efficiency.
• Evaluate mainstream data modeling techniques to choose the best approach for effective data representation.
• Discuss different modeling approaches such as Kimball and Inmon and explain the benefits and considerations of each.

Studiewijze
Program

This training consists of a two-day program.

Resultaat
Why should I follow this training?

• Take your SQL skills to the next level
• Hands-on training with real life examples – learn today apply tomorrow!
• Learn the most modern data modeling techniques

Programma
Day 1

Data Warehouse Architecture

• Fundamentals in data warehousing and dimensional modelling
• History of data modeling and modern day approaches
• The data modeling process
• Star/snowflake schemas, tables, attributes and keys
• Fact and dimension tables – the core concepts of dimensional modeling

Day 2

Dimensional modeling

• Data lifecycle in data warehouseing
• Data constrints and consistency
• Implementing slowly changing dimensions
• Create your first cloud data warehouse in a mainstream data warehouse
• Learn performance tuning techniques with real-world challenges

Doelgroep
This training is for you if:

• You want to understand all key concepts in data warehousing once and for all.
• You care about performance and scalability of your data solutions.
• You like to get your hands dirty to solve real-world problems faced by modern data warehouse practitioner.

This training is not for you if:

• You have no experience in SQL at all (no worries, our SQL for Data Analysis course is enough to get you started).
• You are a data consumer and focus more on delivery business values from data (Our Data Storytelling training is a better fit for you).
• You only want to learn dbt (check out our dbt Learn training).

Requirements

• You want to understand all key concepts in data warehousing once and for all.
• You care about performance and scalability of your data solutions.
• You like to get your hands dirty to solve real-world problems faced by modern data warehouse practitioner.

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!