'Y'

Data warehouse – modeling and design

This is an introductory course that covers the basics of data warehouse.
Description
Code: EAS-006
Duration: 8 hours

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.

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

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


Schedule in
Prices
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Bucharest €220
Krakow €220
Wroclaw €220

Invoices for the course will be issued in local currency. All fees above can change according to training location and delivery mode and are subject to change while scheduling. Price does not include VAT.

Courses you may be interested in:
DB-021
Oracle: PL/SQL Language for Developers
24 hours
Sign Up
SCRIPT-002
Python® Basics
20 hours
Sign Up
SDP-004_ENG
Basics of Agile Methodology for Software Development
16 hours
Sign Up

Recommended Reading:

Practical or theoretical knowledge of integration projects

Sign up

First Name*
Last Name*
Company
Email*
Preferred Location
Phone
Your Comment
Still have questions?
Connect with us
Thank you.
Your request has been received.

IMPORTANT: this page uses cookies, profiling and automated data processing. We use all of it to make your browsing experience more personal and convenient. You may delete and block all cookies from this site as described here, however remember in some cases, they are essential to making the site work properly. To learn more about cookies, privacy and use of this website please read our Online Privacy Notice and Terms of Use.