6235A - Implementing and Maintaining Microsoft SQL Server

AUD$ 2,400
*
*
Academy IT strive to provide you with the training you need when you need it most. If you require a course and can’t attend on the dates provided or if they are not suitable to your staffing or project timelines – please call PH: (08) 7324 9800 to negotiate an alternative booking time.

About this course

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

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

Course Outcomes

After completing this course students 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

Pre-requisites

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

To view the course outline please ensure you have Adobe Reader installed.

Get Adobe Reader

Download 6235A - Implementing and Maintaining Microsoft SQL Server (PDF)

Location:

Related Courses
Course Name
Price
< 
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
> 
2778A - Writing Queries using Microsoft SQL Server 2008 Transact-SQL
AUD$ 2,400
 
 
25 -27
 
11 -13
 
14 -16
 
11 -13
 
6 -8
 
 
6231B - Maintaining a Microsoft SQL Server 2008 R2 Database
AUD$ 4,000
 
 
16 -20
 
11 -15
 
5 -9
 
9 -13
 
18 -22
 
 
6232B - Implementing a Microsoft SQL Server 2008 R2 Database
AUD$ 4,000
 
 
 
13 -17
 
15 -19
 
19 -23
 
7 -11
 
 
 
6234A - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
AUD$ 2,400
 
 
 
6 -8
 
29 -31
 
26 -28
 
14 -16
 
 
 
6236A - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
AUD$ 2,400
 
 
 
30
 
22 -24
 
19 -21
 
28 -30
 
 
 
| Powered by nopCommerce