DB2 Data Warehousing: MDCs MQTs Demystified

Wise

Course

In Gatwick

£ 1,100 + VAT

The best Other Database courses

See all

See all

Description

  • Type

    Course

  • Location

    Gatwick

  • Duration

    3 Days

Upon completion of this course, the participant should be competent to use MDC and MQT disciplines to design data warehouses in particular and large performance-sensitive databases in general. Additionally, the course participant should be qualified to select and tune queries to exploit the MDC and MQT implementations.

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 DB2 Data Warehouse 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

Audience: IT developers, database administrators or anyone responsible for a data warehouse or related discipline.

Prerequisites: Completion of our course DB2 Data Warehouse Fundamentals or equivalent knowledge.

Summary: This course focuses on the use of IBM's Multidimensional Clustering (MDC) and the summary tables (e.g., Materialized Query Tables (MQT)) to design and implement data warehouse and other massive database applications.
Performance issues are central to all discussions.

Objectives: Upon completion of this course, the participant should be competent to use MDC and MQT disciplines to design data warehouses in particular and large performance-sensitive databases in general.
Additionally, the course participant should be qualified to select and tune queries to exploit the MDC and MQT implementations.

Hands-on: About 60%

See related categories

DB2 Data Warehousing: MDCs MQTs Demystified

£ 1,100 + VAT

The best Other Database courses

See all

See all