DB2 Data Warehousing: MDCs & MQTs Demystified
| Course Code: | DWHMDC |
| Duration: | 3 days |
| 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% |
 Detailed Outline |
Course Outlines
Detailed course outlines are available in PDF format.
Download Adobe's Acrobat Reader free from:
www.adobe.com
