This event has been ended!
Next edition: Microsoft SQL Server - Data Vault Modellierung - Schulung in Wien ·
Microsoft SQL Server - Data Vault Modellierung - Schulung in Wien
Microsoft SQL Server - Data Vault Modeling - Training in Vienna
Event by: ATVISIO Consult GmbH
Location: Austria Trend Hotel Europa Wien, Neuer Markt 3, Wien - Innere Stadt
Online event
Tickets: 1200 EUR · Get tickets
About event
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 dealing with Data Vault
Introduction to Data Vault
- Data Vault Basics: Advantages and Application Scenarios
- Data Vault Design principles in agile data warehouse
- Advantages of Data Vault 2.0 compared to Data Vault 1.0
Data Vault Architecture< /strong>
- Data Vault Paradigms: Hubs, Links and Satellites
- Structure and Relationships
- Providing the Data
Business Keys and Hubs
- Definition and identification of business keys
- Construction 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< /p>
New: Book online training now
Contacted on the mutually agreed training day Be your trainer 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 day-to-day business.
For further information, call us.< /p>
Further information
For companies, this training can also be carried out as in-house training. Please contact Rebecca Schlesser - by email [email protected] or by phone +49 631/4140140.