This two-day instructor-led course is intended for those that are new to SQL Server Integration Services or are interested in learning the features available. This course uses an instructor-led topic explanation, instructor performing detailed demonstrations, then the student performing exercises to duplicate what the instructor demonstrated. This style of training is a combination of traditional classroom training and mentored learning. Additionally, videos of the demonstrations performed by the course author are included with the course as a take-away. The course completes with additional scenario-based labs to reinforce the course content.
Audience
This course is intended for IT Professionals.
Topics
Course Overview
SQL Server Integration Services Architecture
SQL Server Integration Services Tools
SQL Server Integration Services Tasks
Data Flow
Variables, Parameters and Expressions
Containers
Performing Joins
Tuning SQL Server Integration Services Packages
Debugging SQL Server Integration Services Packages
Common SQL Server Integration Services Design Patterns
Installing, Upgrading, and Migrating to Windows 7