Oracle SQL : Mastering Oracle SQL Performance Tuning

Oracle SQL Query Tuning and Architecture | Solve critical Oracle SQL query performance issues | Advanced SQL Tuning

Created by: Prathap G
Technical Enterprise Architect

What Will I Learn?

• Step by Step approach on troubleshooting badly performing SQL queries.
• Identify how internal Oracle components affects the performance of the SQL query.
• Identify potential performance bottlenecks by reading the Explain plan of the queries.
• Tips and Tricks to make the Oracle SQL query run faster.
• Compare BAD vs GOOD Queries with Examples.
• Understand how STATISTICS and CARDINALITY affects the performance of the SQL Query.
• Implications of JOINS and ACCESS Methods on the performance of the Query.
• Oracle Performance Tuning on both Oracle11g and Oracle12c Environment.
• Advanced SQL Query Tuning Steps.

Requirements

• Basic understanding of Oracle SQL Query writing.
• No prerequisite software required. You should be able to use PC/laptop comfortably.

Target audience

• Oracle SQL Developers who want to optimize the SQL queries.
• Aspirants seeking career opportunities in Oracle Database and SQL.
• DBA, Developers, Support Analyst who wants to troubleshoot Oracle SQL queries and fix it.