Data warehouse – modeling and design

This is an introductory course that covers the basics of data warehouse.
  • duration 8 hours
  • Language English
  • format Online
duration
8 hours
location
Online
Language
English
Code
EAS-006
price
€ 220 *

Available sessions

To be determined



Training for 7-8 or more people?
Customize trainings for your specific needs

Description

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.
After completing the course, a certificate is issued on the Luxoft Training form

Objectives

  • 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

Target Audience

  • Developers / database architects
  • ETL developers
  • DWH architects

Roadmap

  • 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

Discover more about professional growth and skills development

contact us