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.

  • 1-year e-learning access

  • Course completion certificate

  • 100% money-back guarantee

Online Self Learning USD 99 (USD 129) Enroll Now
Live Online Training -- Get Quote
Traditional Classroom -- Get Quote

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.

Course Outline

Course Introduction
Course Modules
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
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
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
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
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
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
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
Master Data Services
Introduction to Master Data Services
MDS vs. DQS
How MDS Works
Exam Scenarios
Module Review
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

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got queries?

Acknowledgements