Master Class: Building a Data Warehouse in SQL 2022 (BDWSQL22MC)
- Tijdsduur
Master Class: Building a Data Warehouse in SQL 2022 (BDWSQL22MC)
Opleiderscore:
Startdata en plaatsen
Fast Lane biedt haar producten standaard aan in de volgende regio's: Utrecht
Beschrijving
In this 5-day practical workshop, participants will learn how to set up a data warehouse solution with Microsoft SQL Server 2022 components.
After an architectural overview and modeling approaches...
Overview of a data warehouse architecture
- Understanding the Layer Stage, Core Datawarehouse and DataMart
Basics of a data warehouse database
- Special features of a data warehouse database
- Familiarization with data models Starschema, Snowflag Schema, full historization and Data Vault models
- Modeling of dimension and facts
- Optimization concepts for large databases (partitioning, compression, indexing)
Setting up a data warehouse load with Microsoft Integration Services
- Introducti…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
In this 5-day practical workshop, participants will learn how to
set up a data warehouse solution with Microsoft SQL Server 2022
components.
After an architectural overview and modeling approaches...
Overview of a data warehouse architecture
- Understanding the Layer Stage, Core Datawarehouse and
DataMart
Basics of a data warehouse database
- Special features of a data warehouse database
- Familiarization with data models Starschema, Snowflag Schema,
full historization and Data Vault models
- Modeling of dimension and facts
- Optimization concepts for large databases (partitioning,
compression, indexing)
Setting up a data warehouse load with Microsoft Integration
Services
- Introduction to Integration Services
- Getting to know the SSIS transformation tasks
- Parameterization and configuration of Integration Services
packages
- Deployment and operation of integration services
Implementation of a quality assurance layer
- Introduction of Data Quality Services
- Implementation of customized quality assurance with integration
services
Creating DataMarts with Microsoft Analysis Services
(Multidimensional and Tabular)
- Creating cubes
- Deployment von Cubes
- Updating cubes
Overview of reporting tools
- Introduction to Power BI and Paginated Reports (SSRS)
The target group are developers and architects who are planning
to set up a data warehouse system.
You will gain an overview of the layers of a DWH system and finally
learn how the various components interact.
Fast Lane werkt met Nederlandse trainers die didactische vaardigheden combineren met veel practische ervaring.
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.