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

This course serves professionals interested in creating business intelligence solutions, data warehousing and ETL. It prepares participants to measure their knowledge and skills in rendering effective decisions on implementing Data warehouse in Microsoft SQL Server 2012.

Key Features

• 1-year e-learning access

Overview

The Microsoft 70-463 exam is meant for people working in SQL Server Database administrators, System engineers and experienced Data Warehouse developers. This exam tests their skills and knowledge of writing queries. Here we bring you the best in a class course that prepares you for taking up the Microsoft 70-463 exam.

Outline

• Implementing a Data Warehouse with Microsoft SQL Server 2012
  1. Course Introduction
  2. Course Modules
• Module 1
  1. Introduction to Data Warehousing
  2. OLTP vs. OLAP Part1
  3. OLTP vs. OLAP Part2
  4. Data Warehouse
  5. Data Warehouse Architecture
  6. Creating a Data Warehouse Part1
  7. Creating a Data Warehouse Part2
  8. Presenting OLAP Data
  9. OLTP & OLAP Comparison Demonstration Part2
  10. OLTP & OLAP Comparison Demonstration Part1
  11. Exam Scenarios
  12. Module Review
• Module 2
  1. Designing a Data Warehouse
  2. Data Modeling
  3. Data Warehouse Schemas
  4. Time Dimensions
  5. Data Modeling Considerations Part1
  6. Data Modeling Considerations Part2
  7. Implementing a Data Model
  8. Logical Model
  9. Physical Model
  10. Dimensions and Facts Part1
  11. Dimensions and Facts Part2
  12. Exam Scenarios Part1
  13. Exam Scenarios Part2
  14. Module Review
• Module 3
  1. ETL with SSIS
  2. Introduction to SSIS
  3. Upgrading SSIS Packages
  4. SSIS Tools
  5. Data Flow Tasks
  6. Data Sources
  7. Transformations
  8. Utilizing SQL Server Data Tools
  9. Data Flow Task Part1
  10. Data Flow Task Part2
  11. Exam Scenarios
  12. Module Review
• Module 4
  1. SSIS Control Flow
  2. Control Flow Tasks
  3. Integration Services Variables
  4. Expressions
  5. Precedence
  6. Containers and Annotation
  7. Transactions
  8. Checkpoints
  9. Control Flow Tasks & Precedence Part3
  10. Control Flow Tasks & Precedence Part4
  11. Control Flow Tasks & Precedence Part1
  12. Control Flow Tasks & Precedence Part2
  13. Exam Scenarios
  14. Module Review
• Module 5
  1. Troubleshooting Packages
  2. Overview of Troubleshooting
  3. Debugging Part1
  4. Debugging Part2
  5. Breakpoints
  6. Error Handling
  7. SSIS Log Providers
  8. Custom Logging
  9. Troubleshooting and Logging Part1
  10. Troubleshooting and Logging Part2
  11. Troubleshooting and Logging Part3
  12. Exam Scenarios
  13. Module Review
• Module 6
  1. Advanced Packages
  2. Maintaining a Data Warehouse
  3. Change Data Capture
  4. Slowly Changing Dimensions
  5. Script Components
  6. Incremental Updates Part2
  7. Incremental Updates Part1
  8. Exam Scenarios Part1
  9. Exam Scenarios Part2
  10. Module Review
• Module 7
  1. Data Quality Services
  2. Introduction to Data Quality Services
  3. Data Quality Services Components
  4. Working with Data Quality Services Part1
  5. Working with Data Quality Services Part2
  6. Working with Data Quality Services Part3
  7. Exam Scenarios
  8. Module Review
• Module 8
  1. Master Data Services
  2. Introduction to Master Data Services
  3. MDS vs. DQS
  4. How MDS Works
  5. Exam Scenarios
  6. Module Review
• Module 9
  1. Deployment and Security
  2. Deployment Options
  3. Package Deployment
  4. Securing Packages
  5. Deploying SSIS Packages & Projects Part1
  6. Deploying SSIS Packages & Projects Part2
  7. Exam Scenarios
  8. Module Review
  9. Program Review