Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services (2795)

OBJETIVOS
The purpose of this course is to teach Business Intelligence (BI) professionals working in enterprise environments to design an extract, transform, and load (ETL) solution that supports their BI solution. Students will learn how to plan an ETL solution, and specifically how to design and implement a SQL Server Integration Services (SSIS) based ETL solution. They will also learn how to monitor, optimize, and deploy an SSIS solution.

PARTICIPANTES
This course is intended for experienced Business Intelligence (BI) professionals. The target students for this course already have an understanding of how to use the SQL Server 2005 tools to implement ETL functionality, but need to develop their understanding of design principles and best practices when planning, implementing, and deploying an ETL solution.

EQUIPOS Y DURACIÓN
Se dispone de un ordenador por alumno. El curso tiene una duración de 10 horas (consultar los horarios disponibles en el calendario de New Horizons). El nº de plazas es limitado.

 

[Temario]

Planning for ETL
Identifying Data Sources and Destinations
Evaluating Source Data
Identifying Staging Requirements

Planning an SSIS Solution
Planning Packages
Planning Package Development
Designing Package Control Flow

Designing Data Flow
Understanding Data Flow
Designing Data Flow Operations
Handling Data Changes

Logging, Error Handling, and Reliability
Logging ETL Operations
Handling Errors in SSIS
Implementing Reliable ETL Processes with SSIS

Optimizing an SSIS Solution
Monitoring SSIS Performance
Optimizing SSIS Packages
Scaling Out SSIS Packages

Deploying and Operating an SSIS Solution
Deploying SSIS Packages
Operating an SSIS Solution