Advanced SQL Server 2005/2008 Integration Services (SSIS) for DBAs

Course Code: SQSDIS
Duration: 3 days
Level: Advanced
Audience: SQL Server 2005/2008 DBAs (and SSIS developers).
Prerequisites: Completion of our course SQL Server 2005/2008 Integration Services Fundamentals or equivalent knowledge.
Summary: Designed mainly for SQL Server DBAs (and SSIS developers whose job description spans both SSIS developer and DBA tasks), this scenario-oriented presentation concentrates on the more esoteric features of SSIS:
  • Deployment internals
  • Runtime engine
  • Data Flow engine
  • Execution trees
  • Parallelism
  • Source and destination adapters
  • Advanced transformations (synchronous vs. asynchronous)
  • Performance and tuning
  • Performance measurement
  • Partitioned tables (in data warehouses)
  • Partition maintenance
  • ETL planning and development
Objectives: Upon completion of this course, the delegate should be competent to develop, deploy, tune and source a diverse mix of complex SSIS package solutions.
Format: Lecture and hands-on.
View full outline in PDF formatDetailed Outline Bookmark and Share

Course Schedule

  • 24-26 August
  • 28-30 September
  • 26-28 October
  • 30 November-2 December
  • 21-23 December

Price: £1,195+VAT
Venue: London Gatwick

Book Course

Course Outlines

Detailed course outlines are available in PDF format. Download Adobe's Acrobat Reader free from: www.adobe.com
Get Acrobat Reader

Training Topics

GENERAL

print  |  top of page