Description
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.
Module 1: Introduction to Data Warehouses
1.1 Overview of Data Warehouses
1.2 Examine Data Warehousing Concepts
1.3 Introduction to Data Analysis and Reporting Concepts
1.1 Overview of Data Warehouses
1.2 Examine Data Warehousing Concepts
1.3 Introduction to Data Analysis and Reporting Concepts
Module 2: Creating Dimensions and Changing Granularity of Dimensions
2.1 Create Dimensions
2.2 Change Granularity
2.1 Create Dimensions
2.2 Change Granularity
Module 3: Creating Fact Tables and Columnstore Indexes
3.1 Create Fact Tables
3.2 Create Columnstore Indexes
3.1 Create Fact Tables
3.2 Create Columnstore Indexes
Module 4: Implementing Data Warehouses in SQL Server 2012
4.1 Overview of Data Warehouse Components
4.2 Install Integration Services
4.1 Overview of Data Warehouse Components
4.2 Install Integration Services
Module 5: Working with Integration Services
5.1 Create an SSIS Project
5.2 Add Packages to an SSIS Project
5.1 Create an SSIS Project
5.2 Add Packages to an SSIS Project
Module 6: Managing Control Flow
6.1 Deploy a Control Flow
6.2 Execute Packages from Different Control Flow
6.1 Deploy a Control Flow
6.2 Execute Packages from Different Control Flow
Module 7: Working with Dynamic Variables
7.1 Create Expressions with Variables
7.2 Create Package Templates
7.1 Create Expressions with Variables
7.2 Create Package Templates
Module 8: Implementing Data Flow
8.1 Add Data Flow Components to a Data Flow Task
8.2 Perform Transformation Tasks
8.3 Track Changed Data
8.1 Add Data Flow Components to a Data Flow Task
8.2 Perform Transformation Tasks
8.3 Track Changed Data
Module 9: Managing Data Flow
9.1 Add Script Tasks and Script Components to an SSIS Package
9.2 Profile OLTP Data
9.3 Cleanse Data Using DQS
9.1 Add Script Tasks and Script Components to an SSIS Package
9.2 Profile OLTP Data
9.3 Cleanse Data Using DQS
Module 10: Managing SSIS Package Execution
10.1 Execute SSIS Packages on the Server
10.2 Configure the Package Execution Strategy
10.1 Execute SSIS Packages on the Server
10.2 Configure the Package Execution Strategy
Module 11: Debugging and Troubleshooting Packages
11.1 Debug Package Execution Components
11.2 Troubleshoot Package Failures
11.1 Debug Package Execution Components
11.2 Troubleshoot Package Failures
Module 12: Deploying Packages
12.1 Deploy SSIS Packages
12.2 Examine MSI Packages
12.1 Deploy SSIS Packages
12.2 Examine MSI Packages
Module 13: Securing Packages and Databases
13.1 Secure Packages
13.2 Secure Databases
13.1 Secure Packages
13.2 Secure Databases
Module 14: Working with MDS and Windows Azure
14.1 Configure MDS
14.2 Work with MDS Databases
14.3 Work with Windows Azure
14.1 Configure MDS
14.2 Work with MDS Databases
14.3 Work with Windows Azure
Reviews
There are no reviews yet.