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


SKU: LPL-133 Category:

The 70-463 Practice Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2012 Data Warehouse concepts. By completing the lab tasks you will improve your practical skills in implementing Microsoft SQL Server data warehouse, managing connection managers, data flows, deploy SSIS solutions, control flows, data loads, data quality services, data management solutions and managing data quality.

These same tasks will help you understand the objectives and competencies required by the Implementing a Data Warehouse with Microsoft SQL Server 2012 certification exam.

About Practice Labs

In today’s world of complex computer systems and technologies it’s essential that both those new to IT and seasoned professionals alike gain hands on experience. Our state-of-the-art platform brings training theory to life giving the user greater depth of technology ensuring their ability to demonstrate how to use and understand vendor products and software.

Get the hands on learning you need without spending significant amounts of money on your own equipment. We deliver real equipment with the ease and convenience of your web browser, allowing you to develop real world IT skills.


  • Risk free platform to develop practical IT skills in all the latest technologies
  • Real world and exam related practical tasks
  • Real equipment NOT simulations
  • Simply accessed from a web browser, anytime, anywhere – 24/7

Learning Objectives

Design and Implement a Data Warehouse
Define Connection Managers
Implementing Data Flow
Managing SSIS Package Execution
Implementing Script Tasks
Implement Control Flow
Implement Data Load Options
Troubleshoot Data Integration Issues
Install and Maitain SSIS Components
Implement Auditing Logging and Event Handling
Deploy SSIS Solutions
Install and maintain Data Quality Services
Implement Master Data Management Solutions
Manage Master Data Management Solutions
Create a Data Quality Project to Clean Data
Manage Data Quality Project to Clean Data