Harness the power of Microsoft

Train with a Gold Learning Partner

20463: Implementing a Data Warehouse with Microsoft SQL Server

Duration: 5 days Price: $2795.00

Unitek Training Implementing a Data Warehouse with Microsoft SQL Server 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.

Upcoming Classes

Jun 19 – Jun 23 Fremont — San Francisco Bay Area, CA ENROLL >
Aug 07 – Aug 11 Fremont — San Francisco Bay Area, CA ENROLL >
Sept 25 – Sept 29 Fremont — San Francisco Bay Area, CA ENROLL >
Dec 04 – Dec 08 Fremont — San Francisco Bay Area, CA ENROLL >

Course Timings: 9 a.m. – 5 p.m. M–F

This course requires that you meet the following prerequisites:

At least 2 year’s experience of working with relational databases, including:

Designing a normalized database.

Creating tables and relationships.

Querying with Transact-SQL.

Some exposure to basic programming constructs (such as looping and branching).

An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Course Outline

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

This course is part of the following Boot Camps:

[Boot Camp Name]. SEE DETAILS >
[Boot Camp Name]. SEE DETAILS >
[Boot Camp Name]. SEE DETAILS >
[Boot Camp Name]. SEE DETAILS >
[Boot Camp Name]. SEE DETAILS >
[Boot Camp Name]. SEE DETAILS >