In this course, students learn about Oracle SQL tuning and how to apply tuning techniques to their SQL code. This course assists database developers, DBAs, and SQL developers to identify and tune inefficient SQL. It 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, and how to determine if those are the most efficient ways is a particular database. Student will learn how to ensure that the best method is used.
Learning Objectives:
- Modifying a SQL statement to perform at its best
- Identifying poorly performing SQL
- Tracing an application through its different levels of the application architecture
- Understanding how the Query Optimizer makes decisions about how to access data
- Defining how optimizer statistics affect the performance of SQL
- Listing the possible methods of accessing data, including different join methods
Prerequisites
Required:
- Familiarity with database architecture
- Knowledge of SQL and PL/SQL
- Oracle Database: Introduction to SQL Ed 2
Who Should Go For This Training?
Course Outline:
- 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 Join Operations
- Other Optimizer Operators
- Introduction to Optimizer Statistics Concepts
- Using Bind Variables
- SQL Plan Management
- Workshops
Learn more about Oracle Database 12c: Tuning For Developers at NetCom Learning.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.