Oracle 11g SQL Performance Tuning for Data Warehouses

This course will provide the student with the skills necessary to create scalable, high performance SQL-based Oracle applications. They will also learn how to identify existing high-load, poor performing SQL statements and tune them. The focus is on making the best use of Oracle architecture, bench-marking various SQL formulations and identifying the best schema object for a given situation. Oracle11g introduces "automatic tuning" features such as the Automatic Workload Repository, Automatic Database Diagnostic Monitor and SQL Tuning Advisor. These features will be included in the course. It will also include tuning PL/SQL programs using bulk processing and profiling to identify high-load statements. ETL consideration and physical modeling considerations are included.
A good understanding of Oracle SQL, Data Warehouse Overview, and Dimensional modeling will be needed.
4 Days/Lecture & Lab
This course is designed for Application developers and database administrators. Analysts with strong Oracle SQL skills will also benefit from this course.
Introduction to Oracle SQL Tuning::SQL Statement Processing::Viewing The Execution Plan::Using SQL Trace and TKPROF::The Importance of Bind Variables::Getting to Know Cost Based Optimization::Learning the Access Paths::Using Hints::Schema (Data Storage) Options::Indexes, Part I - All About B-Tree Indexes::Indexes, Part II - Introduction to Other Index Types::Using Oracle11g Advisors to Tune SQL::Impact of Reformulating SQL Statements::Join and Subquery Access Paths::Concurrency Control::Parallel Query::Optimizer Plan Stability::Tuning Views::PL/SQL Tuning::Data Warehouse Considerations

Related Scheduled Courses