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

299 USD 200.33 USD 33%
Test scorm

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around implementing a Data Warehouse with Microsoft SQL Server 2012. 

This course is designed for ETL and Data Warehouse Developers who most likely focus on hands-on work creating business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. Primary responsibilities may include:

  • Mastering data using Master Data Services
  • Cleansing data using Data Quality Services
  • ETL Package development for data loading/transfer/transformation
  • Data Synchronization
  • One-time data or application migration
  • Ad-hoc data manipulations, transformations
  • Scheduling ETL jobs
  • Managing, configuring and deploying SQL Server Integration Services (SSIS) packages

This training course on implementing a Data Warehouse with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-463.

This course will provide all the skills and knowledge for the following areas:

read more

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

Module 2: Creating Dimensions and Changing Granularity of Dimensions

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

Module 4: Implementing Data Warehouses in SQL Server 2012

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

Module 6: Managing 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

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

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

Module 10: Managing SSIS Package Execution

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

Module 12: Deploying 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

Module 14: Working with MDS and Windows Azure

14.1 Configure MDS

14.2 Work with MDS Databases

14.3 Work with Windows Azure

  • pdcamogn (not verified)
    user_default
    1
    1
  • pdcamogn (not verified)
    user_default
    1
    1
  • pdcamogn (not verified)
    user_default
    1
    1
  • pdcamogn (not verified)
    user_default
    1
    1

Add New Discussion

How do you rate this product?

Select currency