Db2 Warehousing




Distance-learning Center

Submit IT Questions

DURATION: 3 days

FEE: $1,795


  • Programmer
  • Database Administrator
  • System Programmer
  • IT Professional


  • Data warehouse versus data mart
  • OLAP versus OLTP
  • ETL: Extract, Transform, Load
  • Clustering - benefits
  • Record based clustering
  • MDC: Block Based Clustering
  • Identifying dimension candidates
  • Estimating storage requirements
  • Estimating the number of cells
  • Design the block index for performance
  • MDC maintenance and implementation
  • Performance considerations
  • MQT: Materialized Query Tables

Contact Me
Send Outline
Private Course - Tailored
Cost Analysis

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

The course material and training aids utilized in SYS-ED courses are from multiple sources: courseware generated by staff members, licensed materials, public sources from the Internet, textbooks, and source vendor's documentation.

Not all courses are available for delivery in a distance-learning medium.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software companies, healthcare providers, and mid-sized businesses.

Individuals attending a SYS-ED course will be required to execute a statement that the employer has a licensed version of the software.