MOC 20767 Implementing a SQL Data Warehouse
E-mokymai | Trukmė: 5 dienos | Kaina:
1 950 € (+ PVM 21%)
|
Apie mokymus:
This five day instructor led course provides students with knowledge and skills to provision a Microsoft SQL Server2016 database. The course covers SQL Server 2016 provision both on- premise and in Azure, and covers installing from new and imigrating from an existing install.
The primary audience for this course are database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.
Daugiau:
Mokymų temos:
1: Introduction to Data Warehousing
2: Planning Data Warehouse Infrastructure
3: Designing and Implementing a Data Warehouse
4: Columnstore Indexes
5: Implementing an Azure SQL Data Warehouse
6: Creating an ETL Solution
7: Implementing Control Flow in an SSIS Package
8: Debugging and Troubleshooting SSIS Packages
9: Implementing a Data Extraction Solution
10: Enforcing Data Quality
11: Using Master Data Services
12: Extending SQL Server Integration Services (SSIS)
13: Deploying and Configuring SSIS Packages
14: Consuming Data in a Data Warehouse