Main Office: | 800.631.0410 | |
---|---|---|
Sales Office: | 800.533.3893 |
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.
At the end of this course, delegates will be able to:
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.
Code | Course Title | Duration | Level | |
---|---|---|---|---|
ORTUNE |
Oracle Database 10g: Performance Tuning |
4 Days |
II |
Details |
OROPT |
Oracle 10g/11g SQL Statement Tuning |
3 Days |
II |
Details |
OWHPSQ |
Advanced PL/SQL (and SQL) for Data Warehousing ETL |
4 Days |
III |
Details |
OR11DWB |
Oracle Database 11g: Data Warehousing and Oracle Warehouse Builder |
5 Days |
III |
Details |
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.