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

Current Status
Not Enrolled
Price
£11.99
Get Started
or

Table of Contents

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

stay informed!

Subscribe to receive exclusive content and notifications

small_c_popup.png

Share this course

[geturl]
Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Keep in touch

Fill in your details and we’ll get back to you in no time.