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

4k learners

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around implementing a Data Warehouse with Microsoft SQL Server 2012.

  • 100% money-back guarantee

  • Course completion certificate

  • 1-year e-learning access

Group Training

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

Course Overview

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 Training program course overview

This course is designed for ETL and Data Warehouse Developers who most likely focus on hands-on work creating business intelligence (BI) solutions, including data cleansing, Extract Transform Load (ETL), and Data Warehouse implementation. Primary responsibilities may include: Mastering data using Master Data Services Cleansing data using Data Quality Services ETL Package development for data loading/transfer/transformation Data Synchronization One-time data or application migration Ad-hoc data manipulations, transformations Scheduling ETL jobs Managing, configuring and deploying SQL Server Integration Services (SSIS) packages This training course on implementing a Data Warehouse with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-463.

Overview

Skills

This course will provide all the skills and knowledge for the following areas:

  • Designing and implementing dimensions
  • Designing and implementing fact tables
  • Defining connection managers
  • Designing and implementing data flow
  • Managing SSIS package execution
  • Implementing script tasks in SSIS
  • Designing and implementing control flow
  • Implementing package logic using SSIS variables and parameters
  • Implementing data load options
  • Implementing script components in SSIS
  • Troubleshooting data integration issues
  • Installing and maintaining SSIS components
  • Implementing auditing, logging, and event handling

The registration process

Once you have completed our simplified enrolment process, you’ll receive an email confirmation with your payment receipt in your registered email ID. You can then access the entire content of the online student portal immediately by logging in to your account on our site. Should you require any assistance please reach out to us via email (support@greycampus.com) or via our online chat system.

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