Oracle9i Data Warehouse Administration

This 5-day course considers how to build, implement, tune and utilize data warehouses with Oracle technology. Logical data warehouse concepts are considered such as dimension tables, fact tables and star schemas. Implementing such logical concepts using the Oracle database is then presented including defining dimensions, hierarchies, measures and other objects. Physical implementation techniques are considered such as bitmap indexes, partitioned tables, materialized views, and others.

Emphasis is placed on the parallel execution features of the database and how these can yield significant performance advantages

Major subject areas for the course are:

  • Understanding star schemas and other data warehouse objects
  • Understanding and encouraging optimization of star queries
  • Creating and maintaining materialized views to enhance ad-hoc query performance
  • Creating and maintaining dimensions to enhance ad-hoc query performance
  • Performing dimensional analysis of data warehouse information
  • Using the Summary Advisor tool for data warehouse design recommendations

 
key facts buy online

• code: d008eng
• 5 days
• Download outline
• Print licence available

Student edition
• A4 format
• A5 format
Instructor edition
• A4 format
• A5 format

Target audience

This course has been developed for all database administrators, data warehouse administrators and application developers who will be responsible for implementing and using data warehouse technology. Students should have previously attended the following courses or have equivalent knowledge and experience:

  • Introduction To Oracle9i SQL
  • Introduction To Oracle9i PL/SQL Language
  • Introduction To Oracle9i Advanced SQL
  • Oracle Architecture For Developers or Oracle9i Database Administration - DBA I (recommended)
  • Oracle SQL Tuning (recommended)
  • Oracle9i New & Advanced Features for DBAs (recommended)
Course content

Why partition?

Create a partitioned table

More about partitions

Managing table partitions

Partitioned indexes

About equi-partitioning

About query performance

Data dictionary information

Hash and composite partitions

List partitions

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today

A gtslearning business division :: gtslearning CompTIA learning solutions ::Contact us :: Site map
© gtslearning, 2008. All rights reserved. Ownership of all trademarks and service marks is observed and respected.