Home >
SQL Server >
SQL Server 2008 Integration Services (SSIS) Fundamentals
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.
|
Detailed Outline |
|