Oracle SQL Performance Tuning for Developers

      This hands-on course provides students with the skills necessary to tune SQL statements.Attention is paid to understanding Oracle architecture, rules based and cost based optimization. The following tuning tools are covered in detail: explain plan, TKPROF and autotrace. A detailed discussion of indexes is provided so that the proper index type is chosen for a given scenario.

Topics Covered

  • Introduction to SQL Tuning
  • Architecture Overview
  • SQL Statement Processing
  • Tuning Tools
  • Optimization
  • Using Hints to influence the CBO
  • Indexes
  • SQL Performance Tips
  • Join and Subquery Execution Plans
  • PL/SQL Tuning
  • Tuning Views

Audience:

     Oracle application developers.

Prerequisites:

Benefits:

      Students will gain the ability to improve the performance of applications that depend heavily on access to an Oracle database by testing various SQL possibilities and choosing the most efficient option.

Furnished Materials:

  • Student Manual

Recommended Follow-On Course

Length:

  • 3 Days

Price:

  • $1,485

Training Dates:

Sign Up