Home >> IT Training >> Microsoft Classes

Implementing and Maintaining Microsoft SQL Server 2005 Integration Services

Our Implementing and Maintaining Microsoft SQL Server 2005 Integration Services training class is different from the rest of the courses on the web because we hire only full-time IT professionals with years of experience and a talent for teaching. Our IT training classes are taught in real-time by IT professionals so that you can get your real-world questions answered right away and put the answers to work immediately. Our classes are taught over three days so that you can concentrate on the study subject and leave confident in your abilities.

Our course is taught over nine detailed labs that break the information down into manageable sections. We start by teaching about SQL Server Integration Services while you learn to implement control and data flows. You will learn to implement error handling and how to adequately debug a package. We end the course by teaching you to manage and secure packages. This course is designed for IT professionals who have had experience with the Microsoft Windows Server environment.

If your company has more than six employees who need this training, our onsite Implementing and Maintaining Microsoft SQL Server 2005 Integration Services training class might be your best option. By bringing the classroom to your facility, we will save your employees valuable commute time and can save you 30% off the cost of a course taught in a traditional offsite classroom. All you need to do is set aside a training room at your location and we'll bring the rest to you.

If you are ready to take the next step in your IT career, enroll in our Implementing and Maintaining Microsoft SQL Server 2005 Integration Services training class today. Click on the blue button to stay one step ahead of the competition.

Enrollment Fee: $2,095.00 USD
Number of Class Days: 3

 

Training Class Outline:

1. Introduction to SQL Server 2005 Integration Services

* Overview of Integration Services Solutions
* Integration Services Tools

2. Developing Integration Services Solutions

* Creating an Integration Services Solution
* Using Variables
* Building and Running a Solution

3. Implementing Control Flow

* Control Flow Tasks
* Control Flow Precedence Constraints
* Control Flow Containers

4. Implementing Data Flow

* Data Flow Sources and Destinations
* Data Flow Transformations
* Data Flow Paths

5. Implementing Logging

* Overview of Integration Services Logging
* Implementing Logging

6. Debugging and Error Handling

* Debugging a Package
* Implementing Error Handling

7. Implementing Checkpoints and Transactions

* Implementing Checkpoints
* Implementing Transactions

8. Deploying Packages

* Package Configurations
* Deploying Packages

9. Managing and Securing Packages

* Managing Packages
* Securing Packages