Preview

20463: Implementing a Data Warehouse with Microsoft SQL Server 2014

 
  • Home
  • Database
  • 20463: Implementing a Data Warehouse with Microsoft SQL Server 2014

20463: Implementing a Data Warehouse with Microsoft SQL Server 2014

Key Features

  • Learn from anywhere in the world. Connect with an Instructor in real time.
  • Attend Live Class from a PC or Mobile.
  • Ask questions from an Instructor in real time over voice & chat.
  • Includes Certificate of Completion.
  • Official Exam & Certification Assitance.
  • Get 30 Days free after class support.

Join a next available Live Class:

This course training is available on request only. Send us your request with preferred date & Time & our training advisor will get back to you within 24 business hours.


Request for a Live Class

as per your availability

Enquire for more information

Course Description

About the Course

This course describes how to implement a data warehouse platform to support a BI solution. Aspirants will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

 

This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

 

This course is based on the objectives of the course version 20463D.

Course Curriculum

Course # : 20463
Exam : Implementing a Data Warehouse with Microsoft SQL Server 2014

20463: Implementing a Data Warehouse with Microsoft SQL Server 2014

Objectives

  • Describe data warehouse concepts and architecture considerations
  • Select an appropriate hardware platform for a data warehouse
  • Design and implement a data warehouse
  • Implement Data Flow in an SSIS Package
  • Implement Control Flow in an SSIS Package
  • Debug and Troubleshoot SSIS packages
  • Implement an ETL solution that supports incremental data extraction
  • Implement an ETL solution that supports incremental data loading
  • Implement data cleansing by using Microsoft Data Quality Services
  • Implement Master Data Services to enforce data integrity
  • Extend SSIS with custom scripts and components
  • Deploy and Configure SSIS packages
  • Describe how BI solutions can consume data from the data warehouse

Target Audience

  • This course is intended for database professionals who need to fullfil a Business Intelligence Developer role.

Prerequisites

  • Required: 20461: Querying Microsoft SQL Server 2014
  • Required: 20462: Administering Microsoft SQL Server 2014 Databases
  • Required: An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
  • Required: At least 2 years' experience of working with relational databases
  • Required: Some exposure to basic programming constructs (such as looping and branching)
  • Recommended: Knowledge of basic relational database concepts.
  • Recommended: Knowledge of writing T-SQL queries.
Be Amazed with Online Learning Experience
Future is fast forwarding towards online learning & now it’s becoming easy for everyone to take a world class training from anywhere in the world. Listen from Learnfly Live recent alumni’s studying around the globe.

Get an e-Certificate of Completion

Get a e-Certificate of Course Completion after successfully completing your live class with Learnfly. Share & showcase your proud achievement with your friends & colleagues. Join a live class today & start learning online from anywhere: