Oracle Database 11g: SQL Tuning Workshop

•   Identify poorly performing SQL
•   Trace an application through its different levels of the application architecture
•   Understand how the Query Optimizer makes decisions about how to access data
•   Define how optimizer statistics affect the performance of SQL
•   List the possible methods of accessing data, including different join methods
•   Modify a SQL statement to perform at its best

Oracle Database 11g: Administer a Data Warehouse

•   Use parallel operations to reduce response time for data-intensive operations
•   Extract, Transform, and Load data in the data warehouse
•   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
•   Use the features of compression and resumable sessions
•   Review the basic Oracle data warehousing concepts
•  

Parallel Processing in Oracle Database 11g Seminar

•   Use Database Resource Manager to complement the control of parallel processing usage
•   Define why and when to use parallel processing
•   List the SQL statements and data loading utilities that can benefit from parallel processing
•   Explain the basic concepts and theory associated with parallel execution
•   Use a variety of parallel execution features with different SQL statements
•   Read and evaluate execution plans for parallelized statements
•   Use new Oracle 11g, Release 2 parallel processing features including Auto DOP, statement-queuing,
•   and in-memory parallel execution
•   Examine specific configurations such as RAC database to and Database Machine with parallel execution
•   Troubleshoot parallel processing issues such as no parallel execution, unexpected DOP, or performance decrease
•   Trace parallel execution to provide information to Oracle customer support