Course description

Discover how to implement a data warehouse platform with SQL Server 2012 or 2014.

In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and validate and cleanse data with SQL Server Data Quality Services (DQS) and SQL Server Master Data Services.

This course is designed for customers interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features of SQL Server 2014 as well as the important capabilities across the SQL Server data platform.

This course incorporates material from the Official Microsoft Learning Product 20463: Implementing a Data Warehouse with Microsoft SQL Server 2014. It covers the skills and knowledge measured by Exam 70-463 and along with on-the-job experience, helps you prepare for the exam.

Each individual Microsoft Official Course On-Demand includes 3 months (or 12 months with purchase of Microsoft Total Access Collection) of 24x7 access to the following:

What You'll Learn in Class:

Who Needs to Attend:

Prerequisites:

Follow-On Courses:

Certification:

This course is part of the following programs or tracks:

Note: To reflect the inclusion of SQL Server 2014 content in exams 461, 462, and 463, Microsoft Learning has rebranded the MCSA certification to MCSA: SQL Server 2012/2014. As changes to each individual exam are modest in size and SQL Server 2012 skills remain relevant, all current MCSA: SQL Server 2012 certification holders will have their transcripts updated accordingly to reflect the new credential name. Please see https://www.microsoft.com/en-us/learning/mcsa-sql-certification.aspx for certification details.

Course Outline:

  1. Data Warehousing

  1. Data Warehouse Infrastructure

  1. Design and Implement a Data Warehouse

  1. Create an ETL Solution with SSIS

  1. Implement Control Flow in an SSIS Package

  1. Debug and Troubleshoot SSIS Packages

  1. Implement an Incremental ETL Process

  1. Enforce Data Quality

  1. Master Data Services

  1. Extend SQL Server Integration Services (SSIS)

  1. Deploy and Configure SSIS Packages

  1. Consume Data in a Data Warehouse

Labs:

Lab 1: Explore a Data Warehouse Solution

Lab 2: Data Warehouse Infrastructure Planning

Lab 3: Data Warehouse Implementation

Lab 4: Implement Data Flow in a SSIS Package

Lab 5A: Implement Control Flow in a SSIS Package

Lab 5B: Transactions and Checkpoints Usage

Lab 6: Debug and Troubleshoot a SSIS Package

Lab 7A: Load Incremental Changes

Lab 7B: Extract Modified Data

Lab 8A: Data Cleansing

Lab 8B: De-duplicating Data

Lab 9: Implement Master Data Services

Lab 10: Custom Components and Scripts