SQL - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services 6235

Course Type

Scheduled:

Date	Location	Duration	Cost
18 May 2012 (Fri)	Sunderland	3	£ 995
All prices exclude VAT

Private:

This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice.

Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.

You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.

We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.

Please contact us to discuss this further on 0191 377 8377.

Course Overview

This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages. Target 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 2008 Integration Services.

Prerequisites

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).

Objectives Title

Delegates will be able to:

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.

Related Courses

Course Content

Introduction to SQL Server 2008 Integration Services

Developing Integration Services Solutions

Implementing Control Flow

Implementing Data Flow

Implementing Logging

Debugging and Error Handling

Implementing Checkpoints and Transactions

Configuring and Deploying Packages

Managing and Securing Packages

Training Options

Scheduled public courses at one of our training venues
Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
For further information please contact us on 0191 377 8377

What's Included

1 delegate per computer
Relaxed refreshment area at our training venues
Lunch and refreshments when training is delivered at our training venue
Comprehensive course manual and exercises

SQL Training Courses- Implementing and Maintaining Microsoft SQL Server 2008 Integration Services 6235. Training Courses for SQL in Newcastle, Darlington, Sunderland, Gateshead, Durham and throughout the North East of England

"Trainer was excellent and very approachable"
L.C. CLRN - VBA Using Excel

"Excellent as always"
S.W. National Grid - PhotoShop Level 1

"The trainer was excellent, he listened to what we wanted to gain from the course and didn’t waste time trying to teach us things we would never use, he explained in simple terms..."
P.C. Northumbria Police - Excel Level 2

"Great, exactly what I wanted at a level I could understand"
P.A. Straughans - Access Level 1

"Having one-on-one training was unexpected but was a tremendous bonus. Could not fault the day"
D.R. UK Asset Resolution - PowerPoint Level 2

"This is my second course and I have enjoyed both and have another booked for February so I wouldn't change anything"
T.S. Bell Truck and Van - Excel 2007 / 2010 Level 2

"This is my third course and I have enjoyed them all"
T.S. Bell Truck and Van - PowerPoint Level 2

"Knowledge and professionalism of the trainer was excellent, questions encouraged and answered knowledgeably"
J.M. The Cyrenians - VBA using Excel

"I enjoyed the course and was pleased with the speed it progressed"
G.J. NCFE - HTML Level 1

"Very good way to teach. Nice mix of theory and practice"
K.F. Durham University - Access Level 2

View More | Hide