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

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 able to use a variety of SSIS control and data flow facilities to design, develop and maintain simple-to-complex ETL solutions. Suitable for: SQL Server 2005/2008 developers in particular and DBAs in general.

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

As SSIS is mainly an Extract, Transform and Load (ETL) tool and since ETL has been accepted as being between 70-80% of the data warehouse maintenance challenge, this course is accordingly dedicated. After discussing advanced features of the SSIS control and data flow engines, delegates will be taught how to design, develop and implement an SSIS-based ETL system, accounting for some of the more common and complex requirements, including:

  • Source-to-destination mapping
  • Extraction (e.g., incremental)
  • Staging tables
  • Slowly Changing Dimensions
  • Late arriving (inferred) dimensions
  • Late arriving facts
  • Fact aggregation
  • Data profiling
  • Audit
  • Etc.

See related categories

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

£ 1,195 + VAT

The best SQL Server courses

See all

See all