Implementing and Maintaining Microsoft SQL Server 2005 Integration Services - Course 2792

Course Description
Course Outline

Course Overview

This three-day instructor-led course teaches students how to implement an Integration Services solution in their organizations. The course discusses how to develop, deploy, and manage Integration Services packages.

Audience

This course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server 2005 Integration Services.

We offer a range of SQL Server training courses

Skills Gained
Describe SQL Server Integration Services and its tools. Create an Integration Services package. Implement control flow in an Integration Services package. Implement data flow in an Integration Services package. Implement logging in an Integration Services package. Debug and implement error handling in an Integration Services package. Implement checkpoints and transactions in an Integration Services package. Deploy an Integration Services package. Manage and secure an Integration Services package.
Prererquisites
Before attending this course, students must have: Exposure to enterprise data import and export scenarios Experience navigating the Microsoft Windows Server environment Experience with Microsoft SQL Server, including: SQL Server Agent SQL Server query language (SELECT, UPDATE, INSERT, and DELETE) SQL Server System tables SQL Server accounts (users and permissions)
Course Outline
Module 1: Introduction to SQL Server 2005 Integration Services Module 2: Developing Integration Services Solutions Module 3: Implementing Control Flow Module 4: Implementing Data Flow Module 5: Implementing Logging Module 6: Debugging and Error Handling Module 7: Implementing Checkpoints and Transactions Module 8: Deploying Packages Module 9: Managing and Securing Packages

Publisher:	Microsoft
Version:	2005
Length:	3 Days
Course-ID:	MS2792

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Delightful atmosphere, very pleasant. 1:1 training is a real luxury and I found the whole day extremely beneficial. Trainer answered all my questions very well. I'm sure I will be able to use my new skills regularly

- Boxclever