Implementing a Data Warehouse with Microsoft SQL Server Global Knowledge Egypt
Price: TBA
  • Duration: 5 Days

Course details

Overview:

This course describes how to implement a data warehouse platform to support a BI solution. Students 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.

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.
Updated on 08 November, 2015

About Global Knowledge Egypt

Global Knowledge is the worldwide leader in IT and business skills training. They deliver via training centers, private facilities, and the Internet, enabling their customers to choose when, where, and how they want to receive training programs and learning services.

See all Global Knowledge Egypt courses
Are you from Global Knowledge Egypt ? Claim your course!
Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or