D79995 | Oracle Database 12c: SQL Tuning for Developers Ed 1 | Training Course | Oracle. Skip to main Content

Oracle Database 12c: SQL Tuning for Developers Ed 1

  • Course Code D79995
  • Duration 3 days

Course Delivery

Additional Payment Options

  • GTC 30 inc. VAT

    GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details

Public Classroom Price

eur2.045,00

excl. VAT

Request Group Training Add to Cart

Jump to:

Course Delivery

This course is available in the following formats:

  • Public Classroom

    Traditional Classroom Learning

Request this course in a different delivery format.

Download Course Details

Course Overview

Top

In the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

 

Course Schedule

Top

Contact us for dates

Request Group Training Dates in Other Countries

Target Audience

Top
  • PL/SQL Developer
  • Application Developers
  • Data Warehouse Developer
  • Support Engineer
  • Developer

 

Show me more

Course Objectives

Top
  • Use Oracle tools to identify inefficient SQL statements.
  • Use Automatic SQL Tuning.
  • Use Real Time SQL monitoring.
  • Write more efficient SQL statements.
  • Monitor and trace high load SQL statements.
  • Manage optimizer statistics on database objects.
  • Understand the optimizer process steps and operators.
  • Interpret execution plans.
  • Perform application tracing.
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service.

 

Show me more

Course Content

Top
  • Introduction
  • Introduction to SQL Tuning
  • Using Application Tracing Tools
  • Understanding Basic Tuning Techniques
  • Optimizer Fundamentals
  • Generating and Displaying Execution Plans
  • Interpreting Execution Plans and Enhancements
  • Optimizer: Table and Index Access Paths
  • Optimizer Join Operations
  • Other Optimizer Operators
  • Introduction to Optimizer Statistics Concepts
  • Using Bind Variables
  • SQL Plan Management
  • Workshops
  • Oracle Cloud Overview


Show me more

Course Prerequisites

Top
  • Familiarity with database architecture
  • Knowledge of SQL and PL/SQL
  • Oracle Database: Introduction to SQL Ed 2

 

Show me more

We Care About Your Privacy

We are using cookies to give you the best experience on our site. Cookies are files stored in your browser and are used by most websites to help personalise your web experience. By continuing to use our website without changing the settings, you are agreeing to our use of cookies.

Please only use paragraphs and links in this rich text field. A link to page with cookie info

About your Privacy

We process your data for purposes such as delivering content or advertisements and measuring the delivery of such content or advertisements to extract insights about our website. We may share this information with our partners. Cookies set by Global Knowledge are labelled “first party”; you may exercise your preferences in relation to first party cookies by toggling the switch for each first party cookie category below. The remaining cookies are third party cookies; you may exercise your preferences in relation to each purpose by toggling the relevant switch below or by vendor by clicking “List of IAB Vendors.” These choices will be signaled globally to other websites participating in the Transparency and Consent Framework.
Privacy Statement

Necessary Cookies

These are cookies that are required for the Global Knowledge website to function and cannot be switched off in our systems. They include, for example, cookies that enable you to use a shopping cart or log into the booking area of our website.

Analytics Cookies

Analytics cookies are an optional but important part of our website's functionality. They help us to understand how you interact with our site by collecting and reporting information anonymously. The data collected by analytics cookies is used to improve the website's performance and enhance the user experience. It is important to note that these cookies do not collect any personal information that can be used to identify you.

Preferences Cookies

These are optional and you can turn them off and on. Please only use 2 to 3 lines of text here and if needed link to a page with more cookie info in Intro.

Performance Cookies

These cookies allow us to recognise and count the number of visitors to our website, traffic sources and to see how website visitors move around the website when they are using it. This helps us to improve the way the website works and improve your website experience. All information these cookies collect is aggregated and therefore anonymous.

Cookie Control toggle icon