Microsoft 20463 – Implementing a Data Warehouse with Microsoft SQL Server

In this course you will learn how to implmenet a data warehouse platform in order to support  a business intelligence solution. You will also discuss how to create a data warehouse, implement extract, transform and load with SQL Server Integraion Services and validate and cleanse data with SQL Serve Data Quality Services and SQL Server Master Data Services.

Cui i se adresează?

This course is aimed at database professionals that need to fill in the role of a business intelligence developer role responsible for creating business intelligence solutions, data warehouse implementation, ETL and data cleansing and database professionals responsible for implementing a data warehouse, developing SSIS packages for data extractions, loading, transferring, transforming and enforcing data integrity using MDS and cleansing data using DQS.

Ce veți învăța?

Upon completion you will know how to:

  • Data warehouse concepts and architecture considerations
  • Select an appropriate hardware platform for a data warehouse
  • Design and implement a data warehouse
  • Implement data flow and control flow in a SSIS package
  • Debug and troubleshoot SSIS packages
  • Implement a SSIS solution that supports incremental data warehouse loads and extracting data
  • Implement data cleansing using Microsoft DQS
  • Implement Master Data Services (MDS) to enforce data integrity
  • Extend SSIS with custom scripts and components
  • Deploy and configure SSIS packages
  • How Business Intelligence solutions consume data in a data warehouse
Cerințe preliminare:

Students need to have:

  • Minimum two years experience working with relational databases, including designing a normalized database, creating tables and relationships
  • Basic programming constructs, including looping and branching
  • Focus on key business priorities, such as revenue, profitability, and financial account
Agenda cursului:

Materialele de curs sunt în limba Engleză. Predarea se face în limba Română.

Este recomandat să continui cu:

Nu există cursuri recomandate după finalizarea acestui curs.

Programe de certificare

MCSA: SQL Server 2012

Detalii curs

Durată
5
zile

Preț
800 EUR
Modalități de livrare
Predare în clasă, Clasă hibridă, Clasă virtuală
Nivel de specializare
3. Advanced
Într-o economie bazată pe cunoaștere, educarea și instruirea angajaților reprezintă o investiție în vederea obținerii unei performanțe îmbunătățite pe termen scurt, precum și a succesului pe termen lung al organizației.
DORESC SĂ MĂ ÎNSCRIU LA CURS

Vă rog să mă contactați:

Meniu