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

Wise

Course

In Gatwick

£ 1,195 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Level

    Advanced

  • Location

    Gatwick

  • Duration

    3 Days

Upon completion of this course, the delegate should be competent to develop, deploy, tune and source a diverse mix of complex SSIS package solutions. Suitable for: SQL Server 2005/2008 DBAs (and SSIS developers).

Facilities

Location

Start date

Gatwick (London)
Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, RH6 0NT

Start date

On request

About this course

Completion of our course SQL Server 2005/2008 Integration Services Fundamentals or equivalent knowledge.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Level:AdvancedAudience:SQL Server 2005 DBAs (and SSIS developers).Prerequisites:Completion of our courseSummary:Designed mainly for SQL Server 2005 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.

See related categories

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

£ 1,195 + VAT

The best SQL Server courses

See all

See all