Master Class: Building a Data Warehouse in SQL 2022 (BDWSQL22MC)
- Durée totale
Master Class: Building a Data Warehouse in SQL 2022 (BDWSQL22MC)
Note du fournisseur:
Dates et lieux de début
Description
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…
Foire aux questions (FAQ)
Il n'y a pour le moment aucune question fréquente sur ce produit. Si vous avez besoin d'aide ou une question, contactez notre équipe support.
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.
Rester à jour sur les nouveaux avi
Partagez vos avis
Avez-vous participé à séminaire? Partagez votre expérience et aider d'autres personnes à faire le bon choix. Pour vous remercier, nous donnerons 1,00 € à la fondation Stichting Edukans.Il n'y a pour le moment aucune question fréquente sur ce produit. Si vous avez besoin d'aide ou une question, contactez notre équipe support.