Oracle Database 11g: SQL Tuning Workshop Ed 2 is a comprehensive course designed to help database professionals improve the performance of their existing SQL code. The course provides students with hands-on experience in tuning and optimizing Oracle SQL, utilizing techniques and tools available in the Oracle Database.
The first module of the course is designed to help students understand the importance of optimizing their SQL code and the fundamentals of the Oracle Optimizer, its goals and how it works. The instructor will also explain various common tuning approaches, such as using hints and using the SQL Tuning Advisor.
The second module focuses on specific aspects of SQL Tuning, such as access paths, bind variables and execution plans. This section covers how to identify and analyze execution plans, how to use hints and the SQL Tuning Advisor, and how to debug and control the Optimizer's plan generation process.
The third module covers query optimization techniques and their implications. Topics including optimization principles, join methods, transformation techniques, temporary table usage, bulk operations, query rewrite, performance indicators, and SQL Execution Plans.
The final module teaches advanced techniques of Query Optimization, such as the usage of materialized views, the SQL Plan Baseline feature and dynamic sampling. Students will also gain experience with third-party software products and SQL tuning tools.
Overall, the Oracle Database 11g: SQL Tuning Workshop Ed 2 course provides students with an in-depth understanding of the Oracle Optimizer, its internals and the capabilities of Oracle’s SQL Tuning package. Students will gain the skills to tune their own SQL statements for optimal performance.
This is a Rare Course and it can be take up to 3 weeks to arrange the training.