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.
2050.-/d
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
- ...
Pedagogical method : Training based on MS slides and exercises
Suggested duration for presentiel training (days) : 3
Suggested duration for on-line training (days) : 3.6
Daily price in face-to-face : 2050 CHF
Daily price in remote : 984 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 10250 CHF
Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).
Tags : sql server 2005, coaching sql server, sql server training, training sql server 2005, integration services.