Präsenzveranstaltungen finden ab 02.06.2020 wieder statt! - Erfahren Sie mehr.
Kostenfreie Umbuchungen vom 09.04.2020 - 31.08.2020 möglich

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 Teilnahmebescheinigung

Als PDF herunterladen

Seminarnummer: 29425

Kostenfrei Umbuchen

Seminare, die im Zeitraum vom 09.04.2020 bis 31.08.2020 gebucht werden, können kostenfrei umgebucht werden. Erfahren Sie hier mehr dazu!

Inhouse-Seminare / Veranstaltungen
  • Maßgeschneidert für Sie
  • Vor Ort für mehrere Mitarbeiter
  • Zeit & Reisekosten sparen
ANFRAGEN
Kein passender Termin?

Schreiben Sie uns an oder rufen Sie an.

0800 135 355 77
servicecenter@de.tuv.com
DB-Partnerprogramm
TÜV Rheinland Partnerprogramm

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

Hotel-Partnerprogramm
Tüv Partnerprogramm

Finden Sie das passende Hotel zu Ihrer Weiterbildung und nutzen Sie die Sonderkonditionen unserer Partnerhotels. Weitere Infos erhalten Sie bei Einladung.