Implementing a Data Warehouse with Microsoft SQL Server 2014

Overview

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 course prepares you for Exam 70-463. Download Course Contents
Schedule & Prices
Course Details Schedule
Classroom Training*
Duration : 5 Days
Fee : Online : $2,300  (1-on-1), London : £2,500, Dubai : $2,600 , India : $1,800

February
23-27 (Dubai)
24-28 (london)
March
16-20 (Birmingham)
16-20 (london)
16-20 (Manchester)
22-26 (Dubai)
23-27 (london)
April
20-24 (Birmingham)
20-24 (London)
20-24 (Manchester)
May
18-22 (Birmingham)
18-22 (London)
18-22 (Manchester)
June
15-19 (Birmingham)
15-19 (London)
15-19 (Manchester)
July
20-24 (london)
26-30 (Dubai)
27-31 (london)
Instructor-Led Online Training
Duration : 5 Days
Fee :  $2,300


February
23-27
24-28
March
16-20
22-26
23-27
April
20-24
May
18-22
June
15-19
July
20-24
26-30
27-31
Fly-Me-a-Trainer
Duration : 5 Days
Fee : On Request
Client's Location
As per mutual convenience

Enquire Now




Input symbols

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.

)