SQL Server 2005/2008/2008 R2 Integration Services (SSIS) Fundamentals
| Course Code: | SQSSIS |
| Duration: | 3 days |
| Level: | Beginner-to-intermediate |
| Audience: | Business intelligence and data warehouse developers, ETL architects and DBAs. |
| Prerequisites: | At least six (6) months experience with SQL Server 2000 or later. Experience of Visual Studio useful but not necessary. |
| Summary: | After reviewing Business Intelligence (BI) terms and concepts,
including dimensional modelling, data warehousing (DW), data
marts, OLTP vs. OLAP, this hands-on course focuses on the
more useful and challenging features of SSIS as they relate to
BI/DW solutions in general and ETL solutions in particular. This presentation provides detailed treatment of the following SQL Server Integration Services (SSIS) topics:
|
| Objectives: | As about 80% of this presentation is ETL based, upon its completion, the delegate should be able to think clearly with regards the available SSIS options and implement these options to meet a variety of extract, transform and load solutions in BI and non-BI environments. |
| 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
