Oracle 11g SQL Performance Tuning for Data Warehouses
Duration: 4 Days
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.
Topics Covered In 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
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
Optimizer Plan Stability
Data Warehouse Considerations
What You Can Expect
At the end of this course, delegates will be able to:
Who Should Take This Course
This course is designed for Application developers and database administrators. Analysts with strong Oracle SQL skills will also benefit from this course.
A good understanding of Oracle SQL, Data Warehouse Overview, and Dimensional modeling will be needed.
Instructor led with 50% lecture and 50% lab.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]