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.
This course is intended for Power Users and Business Analysts.
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
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
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.