O12cTSQL. Oracle SQL Tuning for Developers Workshop.

Course with a trainer with over 15 years of experience.

Course level 2 :

For those who are already familiar with the basics of SQL and want to improve their skills in query optimization.

Oracle TSQL course audience

• PL/SQL Developers
• Application developers
• Database administrators
• Information storage administrators
• Information storage developers
• Technical support specialists

Result of the Oracle SQL Tuning course :

After completing the course, you will be able to effectively analyze the performance of SQL queries and implement optimization techniques to increase their execution speed.

You will learn:

Analyze the performance of SQL queries
Use SQL Trace, TKPROF and other tracing tools
Interpret execution plans and configure the optimizer
Rewrite queries to improve performance
Use Oracle adaptive optimization mechanisms

After the course you will be able to:

Analyze and interpret query execution plans, choosing optimal data access methods.
Monitor the performance of SQL statements in real time.
Collect and analyze query usage statistics at different levels, understanding its impact on performance.
Identify inefficient SQL queries and apply best practices for optimizing them.
Deeper understanding of the principles of Oracle query optimizer operation and its decision-making mechanisms.
Ensure stable performance of SQL queries even under changing database operating conditions.

O12cTSQL course program. Oracle SQL Query Tuning for Developers:

Module 1: Introduction to SQL Optimization

• SQL query performance basics
• Identifying problematic SQL statements
• Workarounds to improve performance

Module 2: Analyzing Inefficient SQL Queries

• Query analysis strategy
• Using SQL Trace and TKPROF
• Interpreting trace files to understand optimizer decisions
• End-to-end query tracing