MS SQL Server Training - MS SQL Server 2005: Implementing and Maintaining Integration Services (2792E)

 1,313 total views,  2 views today

MS SQL Server Training - MS SQL Server 2005: Implementing and Maintaining Integration Services (2792E) in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.

ID : 471

Goal : The training discusses how to develop, deploy, and manage Integration Services packages.

Audience : For information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using MS SQL Server 2005 Integration Services.

Prerequisites : Exposure to enterprise data import and export scenarios, experience navigating the MS Windows Server environment, experience with MS SQL Server including SQL Server Agent, SQL Server query language, SQL Server System tables, SQL Server accounts.

Goals :
  • Introduction
  • About MS SQL Server 2005 Integration Services
  • Overview of Integration Services Solutions
  • Integration Services Tools
  • Developing Integration Services Solutions
  • Creating an Integration Services Solution
  • Using Variables
  • Building and Running a Solution
  • Implementing Control Flow
  • Control Flow Tasks
  • Control Flow Precedence Constraints,Control Flow Containers
  • Implementing Data Flow
  • Data Flow Sources and Destinations
  • Data Flow Transformations
  • Data Flow Paths
  • Implementing Logging
  • Overview of Integration Services Logging
  • Implementing Logging
  • Debugging and Error Handling
  • Debugging a Package

Pedagogical method : Diplôme signé par un formateur certifié MS MCT

Suggested duration (days) : 3

Daily price : 2050 CHF
Price per day per trainee without course material, without certificate, without evaluation, without training room or computer

Tags : sql server 2005, coaching sql server, sql server training, training sql server 2005, integration services.