Please note that Oracle courses running at London training centres are subject to a 10% surcharge.
Please note: In order to provision you with your courseware and lab access for this course QA must share several items of basic personal information with our partner (usually your full name and email address). For more information on this please visit our QA Partner data sharing page. If you have any questions or concerns please contact your QA account manager.
In this application development-centric course, delegates learn about Oracle SQL statement tuning and how to write well-tuned SQL statements appropriate for the Oracle database. Delegates learn to interpret execution plans and the different ways in which data can be accessed.
Delegates are shown how to decipher, decide and then apply tuning to their SQL code. Various tuning techniques are demonstrated. For example, taking advantage of bind variables, trace files, and using the different types of indexes are utilized.
- Data Warehouse Developer
- Database Designers
- PL/SQL Developer