Microsoft SQL Server - Data Vault Modellierung - Schulung in Wien

In the training you will learn the Data Vault design principles and design your own initial modeling for your agile data warehouse.

Description

You already have basic knowledge of database development and will now learn how to optimally and future-proof your data warehouse.

Target group

Analysts, developers, system builders

Duration

1 day

Content in Detail

Microsoft SQL Server - Basics

• SQL Server Architecture
• SQL Server Management Studio
• Important SQL commands for using Data Vault

Introduction to Data Vault

• Data Vault Basics: Advantages and Application Scenarios
• Data Vault Design principles in the agile data warehouse
• Advantages of Data Vault 2.0 compared to Data Vault 1.0

Data Vault Architecture

• Data Vault Paradigms: Hubs, Links and Satellites
• Structure and Relationships
• Provision of the Data

Business Keys and Hubs

• Definition and identification of business keys
• Structure and use of hubs

Links and satellites

• Purpose and structure of links
• Definition and implementation of satellites

Data integration and loading

• ETL processes in data Vault
• Task and benefits of staging

ATVISIO consulting practice: “Best practice” and avoidable errors

New: Book online training now

On the mutually agreed training day, your trainer will contact you and first mirror his screen onto your computer - and vice versa if necessary. Ideally, you should have a second PC or laptop ready for your own exercises. Then the training can begin.

With online training you save time and travel costs and can use the hours gained productively for your daily business.

For further information, call us.

Further information

For companies, this training can also be carried out as in-house training. Please contact Rebecca Kunz about this - by email kunz@atvisio.de or by phone 0631/4140140