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
Course Content
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
Impleme…
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.
Course Content
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)
Prerequisites
Basic knowledge in the following areas is desirable:
- Relational databases
- Language TSQL
Who Should Attend
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é à cours? 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.