OD20463

Implementing a Data Warehouse with Microsoft SQL Server On Demand 20463

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.

Nutzen

In dieser MOC on Demand Version ist eine original MOC Unterlage in digitaler Form enthalten.
After completing this course, students will be able to:

  • 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.


Zielgruppe

This course is intended for database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Primary responsibilities include:

  • Implementing a data warehouse.
  • Developing SSIS packages for data extraction, transformation, and loading.
  • Enforcing data integrity by using Master Data Services.
  • Cleansing data by using Data Quality Services.This course is intended for database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Primary responsibilities include:


Voraussetzungen

This course requires that you meet the following prerequisites:

  • At least 2 years experience of working with relational databases, including:
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some exposure to basic programming constructs (such as looping and branching).


Informationen auf einen Blick

TÜV Rheinland Seminare E-Learning

TÜV Rheinland Seminare 40 Unterrichtseinheiten

TÜV Rheinland Seminare Teilnahmebescheinigung

TÜV Rheinland Seminare Garantietermine vorhanden

Als PDF herunterladen

Seminarnummer: 29425

01.01.2017 TÜV Rheinland Seminare
Online

01.01.2018
Online

Preis
ab 990,00 € zzgl. MwSt.
ab 1.178,10 € inkl. MwSt.
TÜV Rheinland Akademie Inhouse

Sie haben Interesse an einer firmeninternen Durchführung dieser Veranstaltung?
Dann kontaktieren Sie uns:

TÜV Rheinland Kontakt
0800 135 355 76

TÜV Rheinland Kontakt
Kein passender Termin?

Rufen Sie uns an oder mailen Sie uns.

TÜV Rheinland Kontakt
0800 135 355 77

TÜV Rheinland Kontakt
DB-Partnerprogramm
Tüv Partnerprogramm

Profitieren Sie von unserem exklusiven Kooperations-Angebot mit der Deutschen Bahn.

Info

Hotel-Partnerprogramm
Tüv Partnerprogramm

Finden Sie ein kostengünstiges Hotel in der Nähe Ihrer Veranstaltung.

Info