• Support
• Bildungsdienstleistungen
• Toad for Oracle
• Toad for Oracle Developers - PL/SQL Profiling and SQL Optimization - Free

Toad for Oracle Developers - PL/SQL Profiling and SQL Optimization - Free

• Beschreibung

  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.

  
  

• Dauer: Approximately 2-3 Hours

  Kurs starten

• Zielgruppe

  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.

• Voraussetzungen

  • 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 higher

  Enable automatic popups and adding the following sites to the exceptions list:

  *.quest.com
  *.software.quest.com

  https://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.

• Ziel

  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

• Themen

  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

• Format

  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.

• Besondere Hinweise

  Download Course Description