SQL Server 2005: Business Intelligence: Integration Services (SSIS): Enterprise Extraction, Transformation and Loading

Course Overview

During this 4-day course, you will learn the ins and outs of SSIS and how to apply its enterprise functionality to data warehouse ETL systems and general data integration requirements. At the completion this course, you will understand how to design, develop, deploy, and operate SSIS solutions from source systems extractions, to data integration and transformation, to business intelligence system loading including how to process. SQL Server Analysis Services (SSAS) cubes. This course will demonstrate a fully working ETL solution, including extensive demos and sample projects, which will not only teach how to use the new technology, but also illustrate business intelligence ETL and data warehouse best practices.

Skills Gained

• Learning SSIS Features and Functionality: The initial seminar modules will dive deep into the core feature set of SSIS to lay the foundation for leveraging the tool for data processing requirements.
• Transferring DTS 2000 Skills to Integration Services: Preparation, migration, and redesign of DTS packages to SSIS will enable DTS users the ability to translate skills from SQL Server 2000 to SQL Server 2005 and provide keys to up-scaling SQL Server 2000 DTS based-solutions to SSIS. A prior knowledge of DTS is not essential for this section as the focus will be on SSIS architecture principles.
• Understanding and Applying ETL Concepts in SSIS: Building on the SSIS knowledge, the focus will turn to understanding relational data warehousing principles- applying efficient SSIS processing techniques for dimensions and fact table ETL. Additionally, the seminar will consider processing architectures for loading SSAS dimension and cubes.
• Deploying and Administering SSIS in Production: The final modules cover getting ETL solutions over the goal line and maintaining sanity once there-focusing on deployment and ongoing administration

Prerequisites

• This course is intended for IT Professionals that are responsible for designing, developing, deploying, and operating business intelligence solutions.
• The target audience for this course is database warehouse, decision support, and business intelligence solution architects, IT professionals, and business intelligence developers who want to learn the details of how to use the new capabilities provided by SSIS to build ETL or other data integration type solution. While this course is targeted at database professionals with some experience with data warehouse solutions, this workshop requires no prior experience with SQL Server 2000 DTS.

SQL Server 2005: Business Intelligence: Integration Services (SSIS): Enterprise Extraction, Transformation and Loading / SQLSSIS05