Oracle Database 11g: SQL Tuning Workshop COMAT Training Services Pte Ltd
Price: SGD 3,158
  • Duration: 3 Days

Course details

The SQL Tuning Workshop class covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Students learn the different ways in which data can be accessed, which ones are most efficient under specific circumstances, and how to ensure that the best method is used. Topics on taking advantage of hints, bind variables, and different types of indexes are also covered.

This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.

COURSE OUTLINE

  • Exploring the Oracle Database Architecture
  • Introduction to SQL Tuning
  • Introduction to the Optimizer
  • Optimizer Operators
  • Interpreting Execution Plans
  • Case Study: Star Transformation
  • Optimizer Statistics
  • Using Bind Variables
  • Using Optimizer Hints
  • Application Tracing
  • Automating SQL Tuning
Updated on 08 November, 2015

About COMAT Training Services Pte Ltd

To be or not to be; this is the question which resides in us. All man of clay, our innate differences are subtle and few. The void spanning greatness hinges on existence of mean and will. COMAT holds an intrinsic belief that every inpidual has a potential to be realised. Betterment of society through advancement of its basic unit, empowerment through continuous learning – Upon these axioms were we founded, and today proudly uphold.

Love for the people around us, a desire for a better world, our passion is our profession. COMAT believes learning is a lifelong process and key to a meaningful existence. Spearheaded by a renowned team of highly experienced and motivated trainers, COMAT offers an extensive array of IT, safety and leadership & professional development courses, providing inpiduals with the means to excel.

While adhering to globally accepted quality standards, our intention goes beyond training and certification - COMAT provides a holistic experience, focusing on generation of inductive environments for stimulating philosophical thoughts. True learning lies in instillation of a sense of self-realisation, a will to become who they can be.

We pride ourselves on our innovations, our desire for continuous improvement, and the ability to perceive the needs and wants of each inpidual. Customized approaches for varying needs, we conjure solutions tailored to fit.

See all COMAT Training Services Pte Ltd courses
Courses you can instantly connect with... Do an online course on Oracle starting now. See all courses

Is this the right course for you?

Didn't find what you were looking for ?

or