MS-10777 - 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012 "Denali"
Course
MS-10777
Price:
$2,795.00
Software Assurance Value:
5
Duration:
5 Days
Course 10777A, TS: Implementing a Data Warehouse with Microsoft SQL Server 2012
Overview
This 5-day instructor-led course describes how to
implement a BI platform to support information worker analytics. Students will
learn how to create a data warehouse with SQL Server 2012, implement ETL
with SQL Server Integration Services, and validate and cleanse data with SQL
Server Data Quality Services and SQL Server Master Data Services.
Microsoft Certified Professional Exams
This will prepare the student for exam 70-463.
Course
Pre-requisites
In addition to their professional experience, students
who attend this training should have technical knowledge equivalent to the
following course:
-
10774A: Writing Queries with Microsoft SQL Server
Transact-SQL
Audience
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.
Primary responsibilities will include:
- Implementing as data warehouse
- Developing SSIS packages for data extraction and
loading/transfer/transformation
- Enforcing data integrity using Master Data Services
- Cleansing data using Data Quality Services
Module
Outline
Module 1: Introduction to Data Warehouse
Concepts
Module Goal: Describe data
warehouse concepts and architecture considerations
Module 2: Data Warehouse Hardware
Considerations
Module Goal: Select an appropriate
hardware platform for a data warehouse
Module 3: Designing and Implementing a Data
Warehouse
Module Goal:
Design and implement a schema for a data warehouse
Module 4: Creating an ETL Solution with SSIS
Module Goal: Implement Data Flow in an
SSIS Package.
Module 5: Implementing Control Flow in an
SSIS Package
Module Goal: Implement Control Flow in
an SSIS Package.
Module 6: Debugging and Troubleshooting SSIS
Packages
Module Goal:
Debug and Troubleshoot SSIS packages
Module 7: Implementing an Incremental ETL
Process
Module Goal:
Implement an
SSIS solution that supports incremental DW loads and changing data
Module 8: Incorporating Data from the Cloud
in a Data Warehouse
Module Goal:
Integrate cloud data into a data warehouse ecosystem
Module 9: Enforcing Data Quality
Module Goal: Implement data cleansing by using Microsoft Data Quality
Services
Module 10: Using Master Data Services
Module Goal:
Implement Master Data Services to enforce data integrity at source.
Module 11: Extending SSIS
Module Goal: Extend SSIS with custom
scripts and components.
Module 12: Deploying and Configuring SSIS
Packages
Module Goal:
Deploy and Configure SSIS packages.
Module 13: Consuming Data in a Data Warehouse
Module Goal: Describe how information workers can consume data from
the data warehouse
