Get started

By signing up, you agree to our Terms of Use and Privacy Policy.
Reset your password
Enter your email and we'll send you instructions on how to reset your password.

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

4k learners

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.

  • Access to GreyCampus platform

  • GreyCampus Course completion certificate

Subscribe to this course + 29 courses
USD 50

Group Training

Looking for a personalized training for a group (3 or more participants) at your preferred location?
Contact us

Course 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.
  • 1-year access to audio-video lectures
  • GreyCampus course completion certificate

Course Outline

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

Download full course agenda/brochure

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got any queries?
By submitting, you agree to our Terms of Use and Privacy Policy.

Acknowledgements

Our Accreditations

Call us

USA +1 518 302 6767
UK +44 20 8144 4436
IND +91 741 666 4433
HKG +852 8192 9294