Oracle Database 11g: SQL Tuning Workshop

Type

Virtual

Classroom ILT

Skill Level

Oracle: Oracle Certified Professional (OCP)

Available dates

Learning Path

Analytics and Data Management

Virtual

Duration

3 Days

1 Day

TYPE

Virtual

Classroom ILT

LEARNING PATH

Analytics and Data Management

SKILL LEVEL

Oracle: Oracle Certified Professional (OCP)

DURATION

3 Days

AVAILABLE DATES

Available on request.

For more information click on button below

Introduction:

This 3 day instructor led course assists database developers, DBAs, and SQL developers to identify and tune inefficient SQL statement. It covers investigative methods to reveal varying levels of detail about how the Oracle database executes the SQL statement. This allows the student to determine the root causes of the inefficient SQL statements. Students learn to interpret execution plans, and the different ways in which data can be accessed. They will learn how the optimizer chooses the path and how to influence the optimizer to ensure that the best method is used. This course covers Automatic SQL Tuning tools, and resources available in the Automatic Workload Repository, in addition to taking advantage of bind variables, trace files, and different types of indexes.

 

Audience profile:

Developers, Support Staff, Database Administrators and Data Warehouse Administrators

 

Pre-requisites:

Before attending this course, students must have:

  • A thorough knowledge of the SQL language
  • Working experience with SQL *Plus
  • Working experience with SQL Developer or similar development environments Oracle requires and recommends that delegates have attended the following course prior to attending this course.
  • Required Course: D64252GC10 Oracle Database Introduction to SQL

Oracle Overview

Torque IT considers authorized Oracle training to be an integral part of any Oracle Solaris, Oracle Enterprise Linux, Oracle Applications, Java development, or Oracle Database implementation.      Oracle authorized training, and associated certification, ensures that you get the most from your technology investment and that you are able to operate above the technology curve.

Our instructor led training provides customers with a hands-on experience to match job role requirements and prepares delegates for Oracle Certification exams. From in-class demonstrations to hands-on-labs, Torque IT’s authorized Oracle instructor led training provides our customers with a comprehensive and dynamic learning experience.

Oracle certifications are universally recognized as demonstrating a high level of expertise and credibility for individuals and the organizations that employ them. Authorized Oracle training and certification is the industry standard for any solution that includes designing, selling, implementing, upgrading, developing and managing Solaris, Java, and Oracle Database solutions.

Torque IT is recognized by Oracle as an Oracle University Training Centre which means that we offer our clients internationally recognized and globally accredited Oracle training and certification.     These achievements reflect our commitment to providing our customers with quality skills development, enablement, training, and certification solutions that demonstrate exceptional depth, breadth, and expertise.

Torque is recognized by Oracle, and the industry, as having met rigorous standards for educational competency, service, customer satisfaction and investment in technology that will prepare the next generation of IT industry professionals to exploit Oracle Solutions.