TOAD Tips and Techniques

    

Summary:
This course 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 & tune SQL statements, and discover all of the features of TOAD. This short course will also cover exactly how to put Oracle data into Excel spreadsheets and take data in Excel spreadsheets and put it back into the Oracle database! The course will also show how to see the data relationships of the application data and how to view this data.This is a hands-on workshop. Students will be able to learn by using TOAD in a test environment. This workshop includes on-line tutorials of all the topics useful to enable the end user to be more successful when working with the Oracle database.

Duration:
1 Day/Lecture & Lab

Topics:

• SQL Editor Tips and Techniques (viewing/changing Data, creating reports,
• Schema Browser Tips and Techniques (viewing/changing Data, creating reports,
• Procedure Editor Usage (develop, execute, and debug PL/SQL routines, work
• SQL Modeler/ER Diagrammer/Master Detail Browser (viewing application data
• Tuning with TOAD including explain plans but more in areas of finding problem
• Miscellaneous topics include TOAD configuration and other topics not covered in

Prerequisites:
There are no prerequisites for this course.

Last Update: May 23, 2012