Oracle Database 12c SQL Tuning for Developers

This course will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database. This course will help you understand the process of SQL as it is executed in an Oracle Database. You learn to write well tuned SQL statements and utilize tools, such as cost-based optimizer, to execute a more efficient SQL process within an Oracle Database.. 

On successful Completion of this course you will be able to:

• Introduction to SQL Tuning
• Using Application Tracing Tools
• Optimizer Fundamentals
• Generating and Displaying Execution Plans
• Interpreting Execution Plans and Enhancements
• Optimizer: Join Operators
• Other Optimizer Operators
• Introduction to Optimizer Statistics Concepts
• Using Bind Variables
• SQL Plan Management