0
  • No products in the cart.
Cart Total:$0.00

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

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.

$29.99

SKU: IT-warehouse-365 Categories: , , , , ,
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.

About the current exam objectives

This Microsoft 70-463: Implementing a Data Warehouse with SQL Server exam is designed to assess the knowledge and skills of ETL and data warehouse developers who are responsible for developing Business Intelligence (BI) solutions, such as performing data cleansing tasks and implementing Extract Transform Load processes in a data warehouse.

This course is preparation for the 70-463 Implementing a Data Warehouse with SQL Server 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, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Skills measured in exam questions

  • 10–15% – Create and execute a data warehouse that exemplifies efficiency, performance, and scalability.
  • 20–25% – Streamline your data by leveraging Extract and Transform capabilities. Quickly extract the most relevant information from multiple sources for advanced analytics, enabling you to make informed decisions about how best to utilize your resources.
  • 25–30% – Upload data for processing and analysis.
  • 20–25% Quickly and efficiently deploy SSIS solutions in order to get the most out of your business.
  • 15–20% – Construct robust data integrity solutions that ensure accuracy, reduce errors and maximize efficiency.

Course Outline

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

Download Course Outline

Introduction

Introduction To Data Warehouse-Part1

Introduction To Data Warehouse-Part2

Introduction To Data Warehouse-Part3

Introduction To Data Warehouse-Part4

Introduction To Data Warehouse-Part5

Introduction To Data Warehouse-Part6

Creating Dimensions And Changing Granularity Of Dimensions-Part1

Creating Dimensions And Changing Granularity Of Dimensions-Part2

Creating Dimensions And Changing Granularity Of Dimensions-Part3

Creating Dimensions And Changing Granularity Of Dimensions-Part4

Creating Dimensions And Changing Granularity Of Dimensions-Part5

Creating Dimensions And Changing Granularity Of Dimensions-Part6

Creating Fact Tables And Column Store Indexes-Part1

Creating Fact Tables And Column Store Indexes-Part2

Creating Fact Tables And Column Store Indexes-Part3

Creating Fact Tables And Column Store Indexes-Part4

Creating Fact Tables And Column Store Indexes-Part5

Implementing Data Warehouse-Part1

Implementing Data Warehouse-Part2

Implementing Data Warehouse-Part3

Implementing Data Warehouse-Part4

Working With Integration Services-Part1

Working With Integration Services-Part2

Working With Integration Services-Part3

Working With Integration Services-Part4

Working With Integration Services-Part5

Working With Integration Services-Part6

Managing Control Flow-Part1

Managing Control Flow-Part2

Managing Control Flow-Part3

Managing Control Flow-Part4

Managing Control Flow-Part5

Working With Dynamic Variables-Part1

Working With Dynamic Variables-Part2

Working With Dynamic Variables-Part3

Working With Dynamic Variables-Part4

Working With Dynamic Variables-Part5

Working With Dynamic Variables-Part6

Working With Dynamic Variables-Part7

Working With Dynamic Variables-Part8

Implementing DataFlow-Part1

Implementing DataFlow-Part2

Implementing DataFlow-Part3

Implementing DataFlow-Part4

Implementing DataFlow-Part5

Implementing DataFlow-Part6

Implementing DataFlow-Part7

Implementing DataFlow-Part8

Managing DataFlow-Part1

Managing DataFlow-Part2

Managing DataFlow-Part3

Managing DataFlow-Part4

Managing SSIS Package Execution-Part1

Managing SSIS Package Execution-Part2

Managing SSIS Package Execution-Part3

Managing SSIS Package Execution-Part4

Managing SSIS Package Execution-Part5

Managing SSIS Package Execution-Part6

Debugging And Troubleshooting-Part1

Debugging And Troubleshooting-Part2

Debugging And Troubleshooting-Part3

Debugging And Troubleshooting-Part4

Deploying Packages-Part1

Deploying Packages-Part2

Deploying Packages-Part3

Securing Packages And Databases-Part1

Securing Packages And Databases-Part2

Working With MDS And Windows Azure

Your Training Instructor

Rafiq Wayani
Project Management Instructor

Related Products

$29.99

Course features:

6 Hrs 55 Min

69 Videos

1 Year Access

Available on Web