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

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.

Request a quote Review training schedules

Learn more about the course below.

TRAINING SCHEDULES

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.

The course curriculum

The curriculum for this Starting with Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 training incorporates all updates The following is a list of broad topics covered

  • Introduction to Data Warehousing
  • OLTP vs. OLAP
  • Data Warehouse
  • Data Warehouse Architecture
  • Creating a Data Warehouse
  • Presenting OLAP Data
  • OLTP & OLAP Comparison Demonstration
  • Exam Scenarios
  • Module Review
  • Designing a Data Warehouse
  • Data Modeling
  • Data Warehouse Schemas
  • Time Dimensions
  • Data Modeling Considerations
  • Implementing a Data Model
  • Logical Model
  • Physical Model
  • Dimensions and Facts
  • Exam Scenarios
  • 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
  • Exam Scenarios
  • Module Review
  • SSIS Control Flow
  • Control Flow Tasks
  • Integration Services Variables
  • Expressions
  • Precedence
  • Containers and Annotation
  • Transactions
  • Checkpoints
  • Control Flow Tasks & Precedence
  • Exam Scenarios
  • Module Review
  • Troubleshooting Packages
  • Overview of Troubleshooting
  • Debugging
  • Breakpoints
  • Error Handling
  • SSIS Log Providers
  • Custom Logging
  • Troubleshooting and Logging
  • Exam Scenarios
  • Module Review
  • Advanced Packages
  • Maintaining a Data Warehouse
  • Change Data Capture
  • Slowly Changing Dimensions
  • Script Components
  • Incremental Updates
  • Exam Scenarios
  • Module Review
  • Data Quality Services
  • Introduction to Data Quality Services
  • Data Quality Services Components
  • Working with Data Quality Services
  • 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
  • Exam Scenarios
  • Module Review
  • Program Review