Master Oracle SQL Tuning to get the most of out MySQL Cloud Service.
Oracle Database 19c is the latest release of Oracle’s flagship relational database management system. It introduces a number of new features and enhancements, including support for multitenant databases, automatic indexing, and enhanced performance and security. Multitenant databases allow multiple independent databases to be hosted on a single instance of Oracle Database, while automatic indexing automates the creation and maintenance of indexes.
These new features make Oracle Database 19c an attractive option for enterprise customers looking to consolidate their database infrastructure. In addition, the enhanced performance and security make it an ideal choice for mission-critical applications.
Overview
Learn to write well-tuned SQL statements for the Oracle database.
This Oracle Database course teaches you how to write well-tuned SQL statements appropriate for the Oracle database. This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning.
MySQL Cloud Service provides numerous benefits over an on-premise database. It is easy to create a cloud instance, with flexible options for computing power, memory, and storage. GUI tools are available for backup and restore as well as patching and rolling back. After completing this course, you can take advantage of those benefits to use MySQL Cloud Service to its best advantage.
Skills Covered
- 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
Prerequisites
- Oracle Database: Introduction to SQL
Target Audience
This course intended for database developers, DBAs, and SQL developers.
Course Contents
Lesson 01: Introduction to SQL Tuning
- Introduction to SQL Tuning
- Quick Solution Strategy
Lesson 02: Using Application Tracing Tools
- Using Application Tracing Tools
- trcsess Utility
Lesson 03: Optimizer Fundamentals
- Optimizer Fundamentals
- Query Estimator: Selectivity and Cardinality
- Plan Generator
Lesson 04: Generating and Displaying Execution Plans
- Generating and Displaying Execution Plans
- AUTOTRACE
- Automatic Workload Repository
Lesson 05: Interpreting Execution Plans and Enhancements
Lesson 06: Optimizer: Table and Index Access Paths
- Optimizer: Table and Index Access Paths
- Indexes: Overview
- Bitmap Indexes
- Common Observations
Lesson 07: Optimizer: Join Operators
Lesson 08: Other Optimizer Operators
Lesson 09: Introduction to Optimizer Statistics Concepts
- Introduction to Optimizer Statistics Concepts
- Column Statistics: Histograms
Lesson 10: Using Bind Variables
- Using Bind Variables
- Cursor Sharing Enhancements
Lesson 11: SQL Plan Management
- SQL Plan Management
- Configuring SQL Plan Management
- Possible SQL Plan Manageability Scenarios
Dates & Locations
August 3, 2026 - August 6, 2026
August 3, 2026 - August 6, 2026
October 5, 2026 - October 8, 2026
October 5, 2026 - October 8, 2026
December 1, 2026 - December 4, 2026
December 1, 2026 - December 4, 2026
Exam & Certification
This course is not associated with any Certification.
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
