comScoreTag

Oracle 11g SQL Performance Tuning

Oracle 11g SQL Performance Tuning
Organizer: The Knowledge Academy
5 Sep 2019 - 6 Sep 2019
09:00 - 17:00
28 Jun 2019 - 5 Sep 2019
62/F & 66/F The Center 99 Queens Road Central Hong Kong
36285(HK$36285)

Oracle 11g SQL Performance Tuning Course Overview

Oracle SQL delivers a simple and easy architecture for defining, accessing and maintaining data. The Oracle 11g SQL Performance Tuning course introduces the delegate to the main concepts of Oracle SQL performance tuning.

After successfully completing this course, delegates will be able to gain skills in tuning database applications for optimal performance, managing statistics, structuring SQL statements for performance, using Hints to influence execution plans and many other vital techniques.

 

Oracle 11g SQL Performance Tuning Course Outline

The following topics are taught during this Oracle SQL course:

  • Course Introduction
  • Session 1: Introduction to Oracle performance tuning
  • Session 2: Tools for evaluating SQL statements
  • Session 3: The optimizer
  • Session 4: Sorts
  • Session 5: Indexes
  • Session 6: Advanced indexes
  • Session 7: Joins
  • Session 8: Sequences and views
  • Session 9: Using Hints
  • Session 10: Miscellaneous

 

For more details and registration, please click here.