Data Warehousing Oracle Database 10g Implement and Administer a Data Warehouse

4 days


Students learn about Oracle's Database partitioning architecture and identify the benefits of partitioning. Students also use parallel operations to reduce response time for data-intensive operations. Participants extract, transform, and load data into an Oracle database warehouse. Students also use materialized views to improve the data warehouse performance. Students also learn how query rewrite can improve a query's performance. Students use the SQL Access Advisor to optimize the entire workload. Finally, students learn how to tune materialized views for fast refresh and query rewrite and how to use the compression and resumable sessions features


  • Data Warehouse Administrator
  • Data Warehouse Developer
  • Application Developers
  • Support Engineer
  • Database Administrators
  • Technical Consultant

Skills Gained

  • Implement partitioning
  • Use parallel operations to reduce response time
  • Extract, Transform, and Load data
  • Create, use, and refresh materialized views to improve the data warehouse performance
  • Use Query rewrite to quickly answer business queries using materialized views
  • Use SQL Access Advisor and PL/SQL procedures to tune materialized views for fast refresh and query rewrite


Required Prerequisites

  • Good working knowledge of data warehouse design
  • Ability to read and understand execution plans
  • Good working knowledge of SQL and in data warehouse design and implementation
  • Good working knowledge of SQL
  • Oracle Database 11g: Administration Workshop I

Suggested Prerequisites

  • Oracle 10g: Data Warehousing Fundamentals
  • Oracle Database 11g: Performance Tuning

Course Outline

Oracle Database 11g Release 2 Data Guard Training Course

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Onsite4 3200 $3200 2019-06-19
Onsite4 3200 $3200 2019-06-19