Microsoft SQL Server 2008 Integration Services
Duration: 4 Days
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
Variables and Configurations
Advanced Control Flow
Error Handling and Logging
Advanced Data Flow
Scripting and Custom Components
What You Can Expect
At the end of this course, students will be able to:
Who Should Take This Course
This course is designed for individuals who are IT professionals and developers.
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.
Instructor led with 50% lecture and 50% lab
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.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]