Course

Data Warehouse Basics

Concepts and components of a data warehouse

Basic 21:00 hrs. German
quofox quality seal

1.612,40 €

incl. VAT

1.390,00 € (net)

You are already on the waiting list The appointment is fully booked

Description

In this seminar you will become familiar with the basic concepts and components of a data warehouse. Starting with the connection of source systems via the filling of the data warehouse with ETL tools to the creation of data marts, all components are presented. You will also get to know the various architectural approaches and concepts (e.g. data models, historization of data, etc.) within a data warehouse. Several live demos deepen and illustrate what you have learned. Topics: - Fundamentals of Data Warehouse: Introduction and Definition of Terms
- Architecture of a data warehouse (staging area, core data warehouse, data mart, etc.)
- Data models (Star Schema, Snowflake Schema, Galaxy and Data Vault)
- Connection of source systems
- ETL overview and filling of the data warehouse
- Historization of data
- Overview Reporting
- Sample database optimizations for a data warehouse
- Overview and classification Big Data
- Live demos and exercises

Aim

- You know the basic concepts and components of a data warehouse and can transfer them to your company.

Participant requirements

IT basic knowledge, basic knowledge of relational databases

Participants

Project managers, project assistants, team leaders, data warehouse architects, database administrators


You might also be interested in

Report problem


Thanks

for your interest in this product.

We will get in touch with the provider immediately and will offer new dates shortly.
We will inform you about the new dates in 14 days at the latest.

Until then you will find the product in your wish list.