Implementing a Data Warehouse with Microsoft SQL Server 2014

Download Course Contents

Implementing a Data Warehouse with Microsoft SQL Server 2014 Course Overview

New version Implementing a SQL 2016 Data Warehouse (SSIS) is now available.

This module will teach students how to execute a data warehouse platform to support a BI solution. Candidates will learn how to create a data warehouse with MS SQL Server, execute ETL with SQL Server Integration Services, validate data with SQL Server Data Quality Services and SQL Server Master Data Services.

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Introduction to Data Warehousing
  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution
  • Lab: Exploring a Data Warehousing Solution
  • Considerations for Data Warehouse Infrastructure
  • Planning Data Warehouse Hardware
  • Lab: Planning Data Warehouse Infrastructure
  • Data Warehouse Design Overview
  • Designing Dimension Tables
  • Designing Fact Tables
  • Physical Design for a Data Warehouse
  • Lab: Implementing a Data Warehouse
  • Introduction to ETL with SSIS
  • Exploring Source Data
  • Implementing Data Flow
  • Lab: Implementing Data Flow in an SSIS Package
  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers
  • Lab A: Implementing Control Flow in an SSIS Package
  • Lab B: Using Transactions and Checkpoints
  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package
  • Lab: Debugging and Troubleshooting an SSIS Package
  • Planning Data Extraction
  • Extracting Modified Data
  • Lab: Extracting Modified Data
  • Planning Data Loads
  • Using SSIS for Incremental Loads
  • Using Transact SQL Loading Techniques
  • Lab: Loading a Data Warehouse
  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Lab A: Cleansing Data
  • Lab B: Deduplicating Data
  • Introduction to Master Data Services
  • Implementing a Master Data Services Model
  • Managing Master Data
  • Creating a Master Data Hub
  • Lab: Implementing Master Data Services
  • Using Scripts in SSIS
  • Using Custom Components in SSIS
  • Lab: Using Custom Scripts
  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution
  • Lab: Deploying and Configuring SSIS Packages
  • Introduction to Business Intelligence
  • Enterprise Business Intelligence
  • Self-service BI and Big Data
  • Lab: Using a Data Warehouse
Live Online Training (Duration : 40 Hours) Fee On Request
Group Training Date On Request
1-on-1 Training
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 40 hours. We can offer you an Ultra-Fast Track for 20 hours

Course Prerequisites

At least 2 years of experience of working with relational databases

Upon Completion of this Course, you will accomplish following:-

  • Plan Data Warehouse Hardware
  • Implement a Snowflake Schema
  • Transfer Data by Using a Data Flow Task
  • Implement control flow with tasks and precedence constraints
  • Use SSIS for Incremental Loads
  • Implement a Master Data Services model
  • Use Master Data Services tools to manage master data
  • Create an SSIS Catalog
  • Describe how a data warehouse can be used in enterprise BI scenarios

Give an edge to your career with Microsoft certification training courses. Students can join the classes for Implementing a Data Warehouse with Microsoft SQL Server 2014 Training & Certification Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Request More Information

Add Name and Email Address of participant (If different from you)


No, the published fee includes all applicable taxes.
The Fee includes:
  • Official courseware
Yes, Koenig Solutions is a Microsoft Learning Partner