Toad for Oracle Developers - PL/SQL Profiling and SQL Optimization - Free
-
说明
This self-paced, web-based training course is available for FREE to all users. This course is based on Toad for Oracle 12.5 or later. If you have an older release of Toad for Oracle, please visit our Support portal to upgrade. If you have any questions, please contact your local Sales Representative for further details contact us.
This course is intended for the Oracle Developer or Database Administrator who needs to learn how to best leverage Toad’s PL/SQL Profiler to profile code for performance bottlenecks and SQL Optimization to automatically re-write SQL statements to find better alternatives.
There is a test that correlates to the course. This test is just a knowledge check of what you have learned.
Click Here to launch the test.
NOTE: The certificate of completion is currently NOT available at this point.
-
时长: Approximately 2-3 Hours
-
目标受众
Oracle Developers or Database Administrators who need to learn how to best leverage the Toad Development Suite’s PL/SQL Profiling and SQL Optimization features. -
前提条件
- A working knowledge of Toad for Oracle, or the completion of the Toad for Oracle Fundamentals course is recommended.
- An understanding of Oracle database application development.
Browser Requirements:
The courseware has been tested to run on the following browsers:
- Google Chrome v32 or higher
- FireFox 26 or higher
- Internet Explorer 9 or higherEnable automatic popups and adding the following sites to the exceptions list:
*.quest.com
*.software.quest.comhttps://www.wikihow.tech/Add-a-Website-to-Trusted-Sites
Re-launch browser
If the course or simulations within the course do not work, try to launch the course using a different web browser.
-
目标
This course will cover how to:
- Profiling your PL/SQL code to identify where the performance bottlenecks are occurring
- Optimizing your PL/SQL code by automatically re-writing the original SQL statement to find better alternatives to maximize performance
-
主题
Introduction -
- Database Management Lifecycle
- Database Development Scenario
- Benefits of using PL/SQL Profiling and SQL Optimization
Lesson 1 –
- PL/SQL Profiler setup (for both the DBMS and Hierarchical profilers)
- Profile PL/SQL
- Review Profiler Results
- Display of Code Coverage Indicators
Lesson 2 –
- Toad for Oracle’s Auto Optimize SQL
- SQL Optimizer for Oracle’s Optimize SQL, Optimize Indexes, Scan SQL and Batch Optimize SQL
-
格式
Students complete this course through self-paced web-based training. This course provides the participant the opportunity for hands-on practice resolving real-world problems through use case driven simulations. Each lesson contains closing questions allowing for a knowledge check. There is a test that correlates to the course. Upon passing a test, customers have the opportunity to achieve a Certificate of Completion.
-
特别说明
