SQL Server 2008 Integration Services (SSIS) Fundamentals

Course Code: SQSIS8
Duration: 4 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 and/or 2005. 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.
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.
View full outline in PDF formatDetailed Outline

print  |  top of page