Affordable Online Education
Cart 0
Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

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

$ 479.00

Course Description

This course is preparation for the 70-463 exam and 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 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 Outline

Mod 1 Introduction to Data Warehouse
Mod 2 Creating Dimensions and Changing Granularity of Dimensions
Mod 3 Creating Fact Tables and ColumnStore Indexes
Mod 4 Implementing Data Warehouse in SQL Server 2012
Mod 5 Working with Integration Services
Mod 6 Managing Control Flow
Mod 7 Working with Dynamic Variables
Mod 8 Implementing Data Flow
Mod 9 Managing Data Flow
Mod 10 Managing SSIS Package Execution
Mod 11 Debugging and Troubleshooting
Mod 12 Deploying Packages
Mod 13 Securing Packages and Databases
Mod 14 Working with MDS and Windows