Microsoft SQL Server 2008 Integration Services
Course: SQLSIS
Duration: 4 Days
Level: I
On our website at:
http://www.verhoef-training.com/courses/SQLSIS.html
Course Summary
This course will help students become comfortable and productive with the SSIS tools and technologies. Students will learn about the Business Intelligence Development Studio (BIDS) and work with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. They will also become familiar with SSIS package management and package deployment including debugging, error handling, and logging techniques.
Topics Covered In This Course
Overview of Integration Services
- SQL Server SSIS, SSAS, and SSRS
- Integration Services Package in BIDS
- Packages Outside of BIDS
Control Flow
- Overview
- Workflow Tasks
- Precedence Constraints
Data Flows
- Task overview
- Data Viewers
- Transformations
Variables and Configurations
- Overview
- Variables in Control Flow
- Variables in Data Flow
- Configurations
- Variables and Configurations between Packages
Advanced Control Flow
- Overview
- Containers
- Transaction Support in Integration Services
Error Handling and Logging
- Troubleshooting
- 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
- Overview
- Create a Package Deployment Utility
- Installing a Package
- Redeploying Updated Packages
Package Management
- Overview
- Managing Integration Services Packages
- Executing Packages
- Integration Services Security
Scripting and Custom Components
- Extending Integration Services Capabilities through Code
- Control Flows with the Script Task
- Data Flows with the Script Component
- Custom Integration Services Components
Best Practices
- Using Integration Services
- Package Development and Design
- Data Flow
- Deployment and Management
Beyond ETL
- Migrating and Maintaining SQL Servers
- Analysis Services and MDX
- Windows Management Instrumentation
What You Can Expect
At the end of this course, students will be able to:
- Use BIDS to create well-designed packages
- Understand Control Flows; how to build them using many of the built-in tasks, including the various containers
- Use the Data Flow task to perform primary ETL operations
- Understand variables and configurations in order to make their packages dynamic and resilient to changes in environments
- Understand the features in BIDS and Integration Services that help with troubleshooting a package
- Deploy and manage packages effectively
- Write script so that they can go beyond the built-in tasks, data sources and destinations, and transformations, as well as build and use custom components
- Understand best practices that will make it easier to develop and maintain a package over its entire life cycle
- Use Integration Services for tasks other than traditional ETL operations
Who Should Take This Course
This course is designed for individuals who are IT professionals and developers.
Recommended 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.
Training Style
Instructor led with 50% lecture and 50% lab
Related Courses
Code |
Course Title |
Duration |
Level |
|
DWHTCA |
Data Warehousing Terms, Concepts and Architecture |
1 Day |
I |
Details |
DWHASP |
Data Warehousing (DW) – Advanced SQL Queries & Performance |
2 Days |
I |
Details |
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.