Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

Curriculum

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 SSISPackage
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