In the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently.
Benefits To You:
Benefit from gaining a deeper understanding of Oracle SQL statement tuning and how write well-tuned SQL statements appropriate for the Oracle database in this application development-centric course. You will learn how to decipher, decide and then apply tuning to your SQL code. Various tuning techniques are demonstrated.
Introduction to SQL Tuning
Using Application Tracing Tools
Understanding Basic Tuning Techniques
Generating and Displaying Execution Plans
Interpreting Execution Plans and Enhancements
Optimizer: Table and Index Access Paths
Optimizer Join Operations
Other Optimizer Operators
Introduction to Optimizer Statistics Concepts
Using Bind Variables
SQL Plan Management
Recommended Related Training Courses:
Using Java - for PL/SQL and Database Developers
This Java for PL/SQL and Developers training teaches you to access Oracle Database using JDBC , UCP, Java stored procedures and SQLJ technologies. Learn to create, load, resolve and publish Java classes in the Database and more.
Oracle Database: SQL Workshop II NEW
This Oracle Database: SQL Workshop II helps you manage the database objects, data dictionary views and multicolumn subqueries. Learn to write more efficient queries using the functions supporting the timezone and regular expressions.
Oracle Database: SQL Tuning for Developers
Oracle Database: Develop PL/SQL Program Units
This Oracle Database: Develop PL/SQL Program Units training helps you enhance your skills by developing stored procedures, functions, packages, and database triggers. Learn to manage PL/SQL program units and use Oracle-supplied packages.
Oracle Database: PL/SQL Fundamentals
Oracle Database: PL/SQL Fundamentals introduces you to the PL/SQL programming language. Learn about stored procedures, functions and creating blocks of application code that can be shared by multiple forms and data management applications.