Data warehouse – modeling and design
Czas trwania
8
hours
Lokalizacja
Online
Język
English
Kod
EAS-006
Szkolenie dla #uczestników# lub większej liczby osób?
Dostosuj treningi
dla Twoich konkretnych potrzeb
Opis
This is an introductory course that covers the basics of data warehouse. Participants will have the opportunity to get acquainted with the core components of architectural solutions. They will learn how to work with architecture patterns such as 3NF, star, and snowflake schemas, as well as with entities like Dimensions & Facts.Considerable attention is given to describing Data Vault architecture, its components and comparative analysis.
Po ukończeniu kursu na formularzu Luxoft Training
wydawany jest certyfikat
wydawany jest certyfikat
Cele
- To familiarize participants with THE general concepts of data warehouses
- To analyze existing architectures
- To give an overview of THE advantages and disadvantages of current practices
Grupa docelowa
- Developers / database architects
- ETL developers
- DWH architects
Plan działania
- What is a data warehouse (DW)
- What can be a DW
- What cannot be a DW
- DW architecture
- Dimensions and Facts: definitions
- DW design patterns
- Types of dimensions
- Types of facts
- Data Vault architecture