20463: Implementing a Data Warehouse with Microsoft SQL Server (MOC20463)

Placeholder

20463: Implementing a Data Warehouse with Microsoft SQL Server (MOC20463)

 2.345,00

20463: Implementing a Data Warehouse with Microsoft SQL Server (MOC20463)

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Doel

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Doelgroep

This course is intended for database professionals who need to create and support a data warehousing solution.

Voorkennis

This course requires that you meet the following prerequisites: ? At least 2 years? experience of working with relational databases, including: Designing a normalized database, Creating tables and relationships, Querying with Transact-SQL, Some exposure

Vorm

Klassikaal en Maatwerk

Inhoud

In deze training worden de volgende onderwerpen behandeld:

Module 1: Introduction to Data Warehousing
Module 2: Planning Data Warehouse Infrastructure
Module 3: Designing and Implementing a Data Warehouse
Module 4: Creating an ETL Solution with SSIS
Module 5: Implementing Control Flow in an SSIS Package
Module 6: Debugging and Troubleshooting SSIS Packages
Module 7: Implementing a Data Extraction Solution
Module 8: Loading Data into a Data Warehouse
Module 9: Enforcing Data Quality
Module 10: Master Data Services
Module 11: Extending SQL Server Integration Services
Module 12: Deploying and Configuring SSIS Packages
Module 13: Consuming Data in a Data Warehouse

Vervolgopleidingen

Bijzonderheden

Geen

5 dagen

€ 2.345

Cursusdata

Data op aanvraag

Andere data?

Locaties

Breda, Tilburg, Amsterdam, Rotterdam, Utrecht, Eindhoven, Antwerpen, Zwolle

Andere locatie?

SKU: MOC20463 Categorieën: , , Tag:
Meer weten over een training of advies? Bel met onze opleidingsadviseurs 085 02 01 070 of gebruik het contactformulier.