Implementing SQL Server 2012 Data Warehouse Course

Implementing a Data Warehouse on SQL Server 2012 Online

 

2KO South Africa offers online SQL Data Warehouse courses in South Africa. We also offer full time Data Warehouse courses in Cape Town for groups of four or more delegates. 2KO South Africa's Data Warehouse course is offered to our international and local students. 2KO International supplies computer training all over Africa, starting from beginner level to advanced certification, and is also a top supplier of internationally recognised online computer courses, to ensure the best SQL Data Warehouse certification training in South Africa.
 

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

OLTP vs. OLAP

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

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

 

Module 4

SSIS Control Flow

Control Flow Tasks

Integration Services Variables

Expressions

Precedence

Containers and Annotation

Transactions

Checkpoints

Control Flow Tasks and Precedence

Exam Scenarios

Module Review

 

Module 5

Troubleshooting Packages

Overview of Troubleshooting

Debugging

Breakpoints

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

MDS vs. DQS

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