Oracle 11g Data Warehousing (Certified Implementation Specialist)
The Oracle Database 11g Data Warehousing Implementation Specialist Certification identifies professionals that are skilled in implementing solutions based using the Oracle Database as a data warehouse. The certification covers skills such as: data warehouse fundamentals, parallelism, partitioning, the Result Set Cache, Advanced Compression, using Oracle Data Mining, data integration with ODI and OWB, the Exadata Storage Server and the Oracle Exadata Database Machine and best practices for implementing data warehouses. The exam targets the intermediate-level implementation team member. Up-to-date training and field experience are recommended.
Course Objectives
Oracle Database 11g Oracle Database 11g: Data Warehousing Fundamentals
- Define the terminology and explain the basic concepts of data warehousing
- Define the terminology and explain the basic concepts of data warehousing
- Describe methods and tools for extracting, transforming, and loading data
- Identify some of the tools for accessing and analyzing warehouse data
- Identify the technology and some of the tools from Oracle to implement a successful data warehouse
- Define the decision support purpose and end goal of a data warehouse
- Describe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehouse
- Explain the implementation and organizational issues surrounding a data warehouse project
- Use materialized views and query rewrite to improve the data warehouse performance
- Develop familiarity with some of the technologies required to implement a data warehouse
Course Content Exam(s)
Currntly not available
Prerequisite
Complete this prior Trainings.
Candidate must have one of the following Trainings.