Data Warehousing: Table Partitioning for SQL Server 2005/2008

Wise

Course

In Gatwick

£ 995 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Location

    Gatwick

  • Duration

    2 Days

Upon completion of this presentation, the delegate should be able to: Partition a relational data warehouse Appreciate the variables that influence table/index partitioning Design sliding window scenarios Optimise query performance. Suitable for: Database architects, developers and administrators of OLTP and/or data warehouse solutions.

Facilities

Location

Start date

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

Start date

On request

About this course

At least one year's experience with SQL Server 2005/2008.

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

Audience:Database administrators, system administrators,business intelligence and data warehousing architects.Prerequisites:Completion of our courseSummary:This presentation uses business cases to illustrate how to design, implement and maintain very large partitioned tables and indexes, in a SQL Server 2005/2008 environment.Objectives:Upon completion of this presentation, the delegate should be competent to:

  • Design and implement partitioned tables and indexes
  • Maintain partitioned tables and indexes
  • Understand good practices as these relate to alternatives for partitioning keys, filegroups, schemas, functions, etc.

Format:
Lecture and hands-on.

See related categories

Data Warehousing: Table Partitioning for SQL Server 2005/2008

£ 995 + VAT

The best SQL Server courses

See all

See all