20767: Implementing a SQL Data Warehouse (MOC20767)
20767: Implementing a SQL Data Warehouse (MOC20767)
€ 2.395,00
This five day course defines how to implement a data warehouse platform to support a BI solution. During this course the students will learn how to create a data warehouse with Microsoft SQL Server 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
Doel
After following this course, the students will be able to:
Doelgroep
The 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.
Voorkennis
To participate in this course, the students need at least 2 years' experience of working with relational databases.
Vorm
Classical and Tailor iT made training
Inhoud
During this course the following topics will be covered:
Module 1: Introduction to Data Warehousing
Module 2: Planning Data Warehouse Infrastructure
Module 3: Designing and Implementing a Data Warehouse
Module 4: Columnstore Indexes
Module 5: Implementing an Azure SQL Data Warehouse
Module 6: Creating an ETL Solution
Module 7: Implementing Control Flow in an SSIS Package
Module 8: Debugging and Troubleshooting SSIS Packages
Module 9: Implementing an Incremental ETL Process
Module 10: Enforcing Data Quality
Module 11: Using Master Data Services
Module 12: Extending SQL Server Integration Services (SSIS)
Module 13: Deploying and Configuring SSIS Packages
Module 14: Consuming Data in a Data Warehouse
Vervolgopleidingen
Bijzonderheden
5 days
€ 2.395
Cursusdata
11, 12, 13, 14 en 15 september 2017
23, 24, 25, 26 en 27 oktober 2017
20, 21, 22, 23 en 24 november 2017
Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.