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 :  London: £4,500, Dubai : $2,610 , India : $1,796


December
10-14 (London)
16-20 (Delhi)
16-20 (Dubai)
16-20 (London)
22-26 (Dubai)
23-27 (Bangalore)
23-27 (London)
30-03 (Chennai)
January
14-18 (London)
20-24 (Delhi)
20-24 (Dubai)
20-24 (London)
26-30 (Dubai)
27-31 (Bangalore)
27-31 (London)
February
24-28 (Bangalore)
Instructor-Led Online Training
Duration : 5 Days
Fee :  $2,330


December
10-14
16-20
22-26
23-27
30-03
January
14-18
20-24
26-30
27-31
February
24-28
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.