Home » Other » Training & Certification » Oracle Datawarehousing Certification path (Oracle 11g)
Oracle Datawarehousing Certification path [message #616723] Fri, 20 June 2014 00:45 Go to next message
Messages: 84
Registered: February 2014
Location: INDIA
Hello Experts,

I am working as Oracle core DBA also completed my OCP 9i, 10g, and 11g certification DBA track.
Now planning for Oracle datawarehousing certification, so can you please guide me with the certification path, exam details / numbers.

Many Thanks in advance.

Re: Oracle Datawarehousing Certification path [message #618658 is a reply to message #616723] Mon, 14 July 2014 12:10 Go to previous messageGo to next message
Messages: 213
Registered: September 2013
Location: Baden-W├╝rttemberg
Senior Member
I googled "Oracle datawarehouse exam" and found


Oracle Database 11g Data Warehousing Essentials
Exam Number: 1Z0-515
Associated Certifications: Oracle Data Warehousing 11g Certified Implementation Specialist , OPN Certified Specialist

exam objectives:


Overview of Data Warehousing

Describe the benefits of a data warehouse
Describe the technical characteristics of a data warehouse
Describe the Oracle Database structures used primarily by a data warehouse
Explain the use of materialized views
Implement Database Resource Manager to control resource usage
Identify and explain the benefits provided by standard Oracle Database 11g enhancements for a data warehouse


Explain how the Oracle optimizer determines the degree of parallelism
Configure parallelism
Explain how parallelism and partitioning work together


Describe types of partitioning
Describe the benefits of partitioning
Implement partition-wise joins

Result Cache

Describe how the SQL Result Cache operates
Identify the scenarios which benefit the most from Result Set Caching


Explain how Oracle OLAP delivers high performance
Describe how applications can access data stored in Oracle OLAP cubes

Advanced Compression

Explain the benefits provided by Advanced Compression
Explain how Advanced Compression operates
Describe how Advanced Compression interacts with other Oracle options and utilities

Data integration

Explain Oracle's overall approach to data integration
Describe the benefits provided by ODI
Differentiate the components of ODI
Create integration data flows with ODI
Ensure data quality with OWB
Explain the concept and use of real-time data integration
Describe the architecture of Oracle's data integration solutions

Data mining and analysis

Describe the components of Oracle's Data Mining option
Describe the analytical functions provided by Oracle Data Mining
Identify use cases that can benefit from Oracle Data Mining
Identify which Oracle products use Oracle Data Mining


Properly size all resources to be used in a data warehouse configuration


Describe the architecture of the Sun Oracle Database Machine
Describe configuration options for an Exadata Storage Server
Explain the advantages provided by the Exadata Storage Server

Best practices for performance

Employ best practices to load incremental data into a data warehouse
Employ best practices for using Oracle features to implement high performance data warehouses

Re: Oracle Datawarehousing Certification path [message #620219 is a reply to message #618658] Wed, 30 July 2014 04:17 Go to previous message
Messages: 84
Registered: February 2014
Location: INDIA
Many Thanks for the details
Previous Topic: The best RAC and Grid course ever
Next Topic: OCA Newb Studying for 12c 1Z0-061
Goto Forum:

Current Time: Wed Dec 01 05:33:29 CST 2021