Performance Monitoring Experts

COURSE DESCRIPTION:

This is a 1 day class (6-hours in duration) that includes lecture, lab and testing for up to 12 students. 


The instructor will illustrate the latest features of Toad necessary to view, extract and manipulate data within the Oracle database.  This workshop covers all of the features necessary to develop, manipulate and debug PL/SQL code, develop and tune SQL statements, using Query Builder and ER (Entity Relationship) tools and discover useful features of Toad.  Dan will also show how to see the data relationships of the application data and how to view and save this data.


Lectures are supported by hands on student lab exercises.


AUDIENCE:

This course is intended for Power Users and Business Analysts.


PREREQUISITES:

None.


ATTENDEES RECEIVE:

      o  Study guide with useful real world examples that includes all presentations and relevant white papers.

      o   White papers on using Toad, Toad Debugger and Toad Profiler


TOPICS COVERED:

      o   Installation, Migration and Connection Topics

      o   Working with SQL:  viewing and changing data, creating reports, extracting data, discovering

           all of the help available, creating SQL with minimal key strokes using templates and

           auto-substitution)

      o   Schema Browser Tips and Techniques (viewing and changing data, creating reports, 

            extracting data, working with scripts, working with spreadsheets, etc.

      o   Working with PL/SQL (develop, execute and debug PL/SQL routines, work with templates to

            create procedures, functions and triggers

      o   Query Builder, ER Diagrammer, Master Detail Browser (viewing application data

            relationships and viewing related data)

      o   Tuning with Toad including explain plans but more in areas of finding problem SQL using

           Toad's interface to wait events and Toad's session interface in SQL as well as using the

           Oracle Trace Facility

      o   Additional SQL performance tuning topics that Toad is very useful for

​      o   Using the new Fast Reports reporting tool

      o   Using the new Automation Designer

      o   Miscellaneous topics include Toad configuration, Toad session monitoring, viewing useful

           data dictionary information, database compare, export, etc.

      o   Various methods of creating DDL and data-oriented scripts.​

Toad Tips and Techniques

Toad  - Foundation Class 

All training is provided by LightSpeed PM

a Certified Quest Partner