Susisiekite su mumis:
+370 5 2105044
info@protraining.lt

MOC 20767 Implementing a SQL Data Warehouse

MOC 20767

Trukmė: 5 dienos
Kaina:
1 500 € (+ 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. 

Dėstytojas: Gintaras Graževičius


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