Data Warehouse Development for SQL Server 2005/2008

Course

In Gatwick

£ 1,195 + VAT

Description

  • Type

    Course

  • Location

    Gatwick

  • Duration

    3 Days

Upon completion of this course, the delegate should understand how to deal with BI/DW design issues as they relate to SQL Server 2005/2008. Suitable for: Data warehouse analysts, ETL specialists, data warehouse administrators.

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 Data Warehousing Terms, Concepts & Architecture and and 6 months experience of Microsoft SQL Server 2005 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

Designed to emphasise SQL Server 2005's features specific to business intelligence (BI) and data warehousing (DW), this scenario and hands-on presentation details the following:

  • Data mart design and load
  • Business Intelligence Development Studio (BIDS)
  • SQL Server Management Studio
  • Building dimension tables
  • Building fact tables
  • Developing dimensions
  • Hierarchies
  • ETL via SQL Server 2005 Integration Services (SSIS)
  • Security
  • SQL Server 2005 Analysis Services (SSAS)
  • Performance and good practices

Data Warehouse Development for SQL Server 2005/2008

£ 1,195 + VAT