Advanced SQL Server 2005/2008 Integration Services (SSIS) for Developers
| Course Code: | SQSAIS |
| Duration: | 3 days |
| Level: | Advanced |
| Audience: | SQL Server 2005/2008 developers in particular and DBAs in general. |
| Prerequisites: | Completion of our course SQL Server 2005/2008 Integration Services Fundamentals or equivalent knowledge. |
| Summary: | As SSIS is mainly an Extract, Transform and Load (ETL) tool
and since ETL has been accepted as being between 70-80% of
the data warehouse maintenance challenge, this course is
accordingly dedicated. After discussing advanced features of
the SSIS control and data flow engines, delegates will be taught
how to design, develop and implement an SSIS-based ETL
system, accounting for some of the more common and complex
requirements, including:
|
| Objectives: | Upon completion of this course, the delegate should be able to use a variety of SSIS control and data flow facilities to design, develop and maintain simple-to-complex ETL solutions. |
| Format: | Lecture and hands-on. |
 Detailed Outline |
|
Course Outlines
Detailed course outlines are available in PDF format.
Download Adobe's Acrobat Reader free from:
www.adobe.com
