Implementing SQL Server 2012 Data Warehouse Course

Implementing a Data Warehouse on SQL Server 2012 Online


2KO Namibia offers online SQL Data Warehouse courses in Namibia. We also offer full time Data Warehouse courses in Windhoek for groups of four or more delegates. 2KO Namibia's Data Warehouse course is offered to our international and local students. 2KO Africa conducts hands-on computer courses on most of the major IT Platforms, and has a sizeable range of online IT courses which are available internationally over the Internet, to ensure the best SQL Data Warehouse certification training in Namibia.



2KO Namibia's online SQL course in Namibia 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 Namibia 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


The 2KO Namibia 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