Oxford Applied Training

This course is preparation for the 70-463 Implementing a Data Warehouse with SQL Server 2012 exam. The course covers topics that are featured on the exam, such as how to implement a data warehouse platform to support a BI solution, how to create a data warehouse with Microsoft 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.

Course Content

Lesson 1: Introduction to Data Warehouses
Topic A: Overview of Data Warehouses
Topic B: Examine Data Warehousing Concepts
Topic C: Introduction to Data Analysis and Reporting Concepts

Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
Topic A: Create Dimensions
Topic B: Change Granularity

Lesson 3: Creating Fact Tables and Columnstore Indexes
Topic A: Create Fact Tables
Topic B: Create Columnstore Indexes
Lesson 4: Implementing Data Warehouses in SQL Server 2012
Topic A: Overview of Data Warehouse Components
Topic B: Install Integration Services

Lesson 5: Working with Integration Services
Topic A: Create an SSIS Project
Topic B: Add Packages to an SSIS Project

Lesson 6: Managing Control Flow
Topic A: Deploy a Control Flow
Topic B: Execute Packages from Different Control Flow

Lesson 7: Working with Dynamic Variables
Topic A: Create Expressions with Variables
Topic B: Create Package Templates

Lesson 8: Implementing Data Flow
Topic A: Add Data Flow Components to a Data Flow Task
Topic B: Perform Transformation Tasks
Topic C: Track Changed Data

Lesson 9: Managing Data Flow
Topic A: Add Script Tasks and Script Components to an SSIS Package
Topic B: Profile OLTP Data
Topic C: Cleanse Data Using DQS

Lesson 10: Managing SSIS Package Execution
Topic A: Execute SSIS Packages on the Server
Topic B: Configure the Package Execution Strategy

Lesson 11: Debugging and Troubleshooting Packages
Topic A: Debug Package Execution Components
Topic B: Troubleshoot Package Failures

Lesson 12: Deploying Packages
Topic A: Deploy SSIS Packages
Topic B: Examine MSI Packages

Lesson 13: Securing Packages and Databases
Topic A: Secure Packages
Topic B: Secure Databases

Lesson 14: Working with MDS and Windows Azure
Topic A: Configure MDS
Topic B: Work with MDS Databases
Topic C: Work with Windows Azure