Course Name

Oracle Database 19c: SQL Tuning Workshop

  • Code: D80343GC21
  • Duration: 3 Day(s)
  • Date: 21 Oct, 2024
  • Price: R22, 500.00 (excl. VAT)
Call me back
Get Overview
Book now!

Course Introduction

This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for: 

  • Developers
  • Support Staff
  • Database Administrators
  • Data Warehouse Administrators

Course Prerequisites

  • 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: Oracle Database Introduction to SQL

Course Objectives

Upon completion of this course, students will be able to:

  • Interpret execution plans and the different ways in which data can be accessed.
  • Decipher, decide and then apply tuning to SQL code.
  • Use various tuning techniques.
  • Take advantage of bind variables, trace files and use the different types of indexes.
  • Use different access paths for better optimization.

Course Content

  • Module 1: Course Introduction
  • Module 2: Introduction to SQL Tuning
  • Module 3: Using Application Tracing Tools
  • Module 4: Optimizer Fundamentals
  • Module 5: Generating and Displaying Execution Plans
  • Module 6: Interpreting Execution Plans and Enhancements
  • Module 7: Optimizer: Table and Index Access Paths
  • Module 8: Using Bind Variables
  • Module 9: Optimizer: Join Operators
  • Module 10: Other Optimizer Operators
  • Module 11: Introduction to Optimizer Statistics Concepts
  • Module 12: Using Bind Variables
  • Module 13: SQL Plan Management
  • Module 14: Workshops
L❤ ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Please call me

Get in touch

Contact the Impactful team if you need any assistance.
Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

Course Introduction

This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for: 

  • Developers
  • Support Staff
  • Database Administrators
  • Data Warehouse Administrators

Course Prerequisites

  • 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: Oracle Database Introduction to SQL

Course Objectives

Upon completion of this course, students will be able to:

  • Interpret execution plans and the different ways in which data can be accessed.
  • Decipher, decide and then apply tuning to SQL code.
  • Use various tuning techniques.
  • Take advantage of bind variables, trace files and use the different types of indexes.
  • Use different access paths for better optimization.

Course Content

  • Module 1: Course Introduction
  • Module 2: Introduction to SQL Tuning
  • Module 3: Using Application Tracing Tools
  • Module 4: Optimizer Fundamentals
  • Module 5: Generating and Displaying Execution Plans
  • Module 6: Interpreting Execution Plans and Enhancements
  • Module 7: Optimizer: Table and Index Access Paths
  • Module 8: Using Bind Variables
  • Module 9: Optimizer: Join Operators
  • Module 10: Other Optimizer Operators
  • Module 11: Introduction to Optimizer Statistics Concepts
  • Module 12: Using Bind Variables
  • Module 13: SQL Plan Management
  • Module 14: Workshops

Are you ready to start?

Sign Up
Download Overview

Certified global best practices in the new technologies…

Amazon Web Services Impactful Partner
PeopleCert Logo
Impactful is an Accredited Oracle University Partner
Impactful Partner Microsoft logo

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

About LRMG

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

CONTACT US