Implementing SQL Server 2012 Data Warehouse Course

Implementing a Data Warehouse on SQL Server 2012 Online


2KO Rwanda offers online SQL Data Warehouse courses in Rwanda. We also offer full time Data Warehouse courses in Kigali for groups of four or more delegates. 2KO Rwanda's Data Warehouse course is offered to our international and local students. 2KO is an IT consulting and training company, offering both business services and multi-platform training. 2KO Africa's wide range of computer courses are available as full time classes, or as online learning, to ensure students have access to the best SQL Data Warehouse certification training in Rwanda.


2KO Rwanda's online SQL course in Rwanda is intended 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. 2KO Rwanda also offers online courses to our international and local students. 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 consist of: 

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



Register for an Online Microsoft Technical Course Here


The 2KO Rwanda course on implementing a Data Warehouse with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-463.


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

Deploying SSIS solutions

Configuring SSIS security settings

Installing and maintaining Data Quality Services

Implementing master data management solutions

Creating a data quality project to clean data


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


Module 1 

Introduction to Data Warehousing


Data Warehouse

Data Warehouse Architecture

Creating a Data Warehouse

Presenting OLAP Data

OLTP and OLAP Comparison Demonstration

Exam Scenarios

Module Review


Module 2

Designing a Data Warehouse

Data Modelling

Data Warehouse Schemas

Time Dimensions

Data Modelling Considerations

Implementing a Data Model

Logical Model

Physical Model

Dimensions and Facts

Exam Scenarios

Module Review


Module 3


Introduction to SSIS

Upgrading SSIS Packages

SSIS Tools

Data Flow Tasks

Data Sources


Utilizing SQL Server Data Tools

Data Flow Task

Exam Scenarios

Module Review


Module 4

SSIS Control Flow

Control Flow Tasks

Integration Services Variables



Containers and Annotation



Control Flow Tasks and Precedence

Exam Scenarios

Module Review


Module 5

Troubleshooting Packages

Overview of Troubleshooting



Error Handling

SSIS Log Providers

Custom Logging

Troubleshooting and Logging

Exam Scenarios

Module Review


Module 6

Advanced Packages

Maintaining a Data Warehouse

Change Data Capture

Slowly Changing Dimensions

Script Components

Incremental Updates

Exam Scenarios

Module Review


Module 7

Data Quality Services

Introduction to Data Quality Services

Data Quality Services Components

Working with Data Quality Services

Exam Scenarios

Module Review


Module 8

Master Data Services

Introduction to Master Data Services


How MDS Works

Exam Scenarios

Module Review


Module 9

Deployment and Security

Deployment Options

Package Deployment

Securing Packages

Deploying SSIS Packages and Projects

Exam Scenarios

Module Review

Program Review