SQL Server 2008 Integration Services (SSIS) Training in Sacramento

Enroll in or hire us to teach our SQL Server 2008 Integration Services (SSIS) class in Sacramento, California by calling us @303.377.6176. Like all HSG classes, SQL Server 2008 Integration Services (SSIS) may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, SQL Server 2008 Integration Services (SSIS) may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.

Course Description

 
This course assumes no prior knowledge of SQL Server Integration Services. This course does assume prior knowledge of SQL Server 2008 and the use of SQL Server Management Studio for development and administrative tasks. You should be able to create CRUD (create, retrieve, update, and delete) queries using T-SQL, understand basic relational databases design, run script files and diagnose problems that occur, and have experience building applications that access data stored in SQL Server. You must also know how to connect to an instance of SQL Server 2008 using the various connection dialog boxes in Management Studio and development tools.
Course Length: 3 Days
Course Tuition: $1665 (US)

Prerequisites

This course assumes no prior knowledge of SQL Server Integration Services. This course does assume prior knowledge of SQL Server 2008 and the use of SQL Server Management Studio for development and administrative tasks. You should be able to create CRUD (create, retrieve, update, and delete) queries using T-SQL, understand basic relational databases design, run script files and diagnose problems that occur, and have experience building applications that access data stored in SQL Server. You must also know how to connect to an instance of SQL Server 2008 using the various connection dialog boxes in Management Studio and development tools.

Course Outline

 
A Guided Tour of SSIS
  • Understanding Integration Services 
  • Exploring and Executing an SSIS Package in BIDS
  • Exploring and Executing a Package outside of  BIDS
Introduction to Control Flow
  • Overview of Control Flow in Integration Services 
  • Working with Workflow Tasks
  • Precedence Constraints
 Data Flows
  • The Data Flow Task
  • Data Viewers
  • Data Flow Transformations
Variables and Configurations
  • Understanding Variables
  • Using Variables in Control Flow
  • Using Variables in Data Flow
  • Configurations
  • Using Variables and Configurations between Packages
Advanced Control Flow
  • Advanced Control Flow Overview
  • Using Containers
  • Transactions Support in Integration Services 
Error Logging and Handling
  • When Things Go Wrong
  • Checkpoints
  • Handling Errors and Debugging
  • Packaging Logging
  • Event Handling
Advanced Data Flow
  • Synchronous and Asynchronous Transformations
  • Using Advanced Transformations
  • Handling Slowly Changing Dimensions
Package Deployment
  • Deploying Packages
  • Create a Package Deployment Utility
  • Installing a Package
  • Redeploying Updated Packages
Package Management
  • Overview of Package Management
  • Managing Integration Services Packages
  • Executing Packages
  • Integration Services Security
Scripting and Custom Components
  • Extending SSIS Capabilities Through Code
  • Scripting in Control Flows with the Script Task
  • Scripting in Data Flows with the Script Component
  • Custom SSIS Components
Best Practices
  • Best Practices for Using Integration Services 
  • Best Practices for Package Development and Design 
  • Data Flow Best Practices
  • Deployment and Management Best Practices
Going Beyond ETL
  • Using SSIS Beyond ETL
  • Migrating and Maintaining SQL Servers with SSIS
  • Working with Analysis Services
  • Working with Windows Management Instrumentation

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.