This Oracle Database 11g: SQL Tuning Workshop Release 2 training assists database developers, DBAs and SQL developers in identifying and tuning inefficient SQL statements. You'll explore investigative methods to reveal varying levels of detail about how the Oracle database executes the SQL statement; this helps you determine the root causes of the inefficient SQL statements.
Benefits to You
Gain expertise in relational database data management as you learn how to effectively use SQL commands against your business data. These features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects.
Explore the Optimizer
Expert instructors will also help you explore how the optimizer chooses the path. You'll also learn how to influence the optimizer to ensure the best method is used.
Automatic SQL Tuning Tools
This course covers Automatic SQL Tuning tools and resources available in the Automatic Workload Repository. Furthermore, take advantage of bind variables, trace files and different types of indexes.
Note: this course is based on Oracle Database 11g Release 2.
Exploring the Oracle Database Architecture
Introduction to SQL Tuning
Introduction to the Optimizer
Interpreting Execution Plans
Optimizer: Table and Index Operations
Optimizer Join Methods
Optimizer: Other Operators
Case Study: Star Transformation
Using Bind Variables
Using SQL Tuning Advisor
Using SQL Access Advisor
Using Automatic SQL Tuning
SQL Performance Management
Recommended Related Training Courses:
Oracle Enterprise Manager 11g: Grid Control Essentials
This Enterprise Manager 11g training teaches you how to implement and use Grid Control to manage your enterprise-computing environment. Learn to install & configure the Grid Control framework and use out-of-box management capabilities.
Parallel Processing in Oracle Database 11g - Seminar
This Parallel Processing in Database 11g training teaches you the benefits of parallelizing requests in an 11g database & use features of parallel processing. View recorded demos of parallel processing in various database server configurations.
Oracle SQL Tuning for Developers Workshop
This SQL Tuning for Developers training assists database developers, DBAs and SQL developers to identify and tune inefficient SQL statements. You'll learn to interpret execution plans and the different ways that data can be accessed.