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


This course will provide all the skills and knowledge for the following areas:Designing and implementing dimensionsDesigning and implementing fact tablesDefining connection managersDesigning and implementing data flowManaging SSIS package executionImplementing script tasks in SSISDesigning and implementing control flowImplementing package logic using SSIS variables and parametersImplementing data load optionsImplementing script components in SSISTroubleshooting data integration issuesInstalling and maintaining SSIS componentsImplementing auditing, logging, and event handlingDeploying SSIS solutionsConfiguring SSIS security settingsInstalling and maintaining Data Quality ServicesImplementing master data management solutionsCreating a data quality project to clean data 


Thiscourse 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.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.


Need a Government Grant?

Jumpstart your training with the help of Global Innovative Campus (GIC-Canada) & the Canada Job Grant.

Seminars and Workshops offered within your organization anywhere in the world.

Get notified of our upcoming early bird discounts.

Course Inquiry

Submit this form for no-obligation course inquiries. One of our agents will contact you at the email or phone you enter below.


Stay on top of your profession development with useful articles and industry updates Subscribe