IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

Hot Topics

3-day ITIL Foundation

5-day PRINCE2™ Practitioner

4-day Business Analysis

3-day Project Management Fundamentals

Course Title:
TOAD for Beginners

Duration: 1 day

Course Overview
This course provides a hands-on approach to Quest’s application TOAD. Delegates will learn how to create SQL scripts and PL/SQL programs using the application. They will also learn how to create objects such as tables and indexes along with how to maintain individual tables through creating constraints, adding/dropping constraints etc.

In addition they will learn how to set up TOAD to cater for their personal development needs and how to use the application to improve the efficiency of the code they produce. They will also get an insight into the features available to help DBAs perform their daily, weekly and monthly tasks.

Course Objectives


By the end of the course attendees will be able to:

• Set the startup options for a tailored TOAD
• Use SQL Editor to produce SQL scripts
• Save results of scripts to a number of formats
• Use the Procedure Editor to create PL/SQL
• View different objects using the Schema Browser
• Invoke SQL Tuning using TOAD’s tuning tools
• Look at different methods for debugging
• Monitor the database using TOAD-DBA module

Prerequisites


Basic ORACLE knowledge

Course Content


Introduction
• What is TOAD?
• How Can TOAD Help Me?
• Additional TOAD Modules

TOAD Setup
• Database Connectivity
• The TOAD Schema
• TOAD and Security
• Saving Your TOAD Settings

The Schema Browser
• How To Make Schema Browser Your Startup Screen
• Schema Browser Display Styles
• Configuring Schema Browser Tabs
• Filtering
• Advanced Schema Browser Options

TOAD SQL Editor
• Predefined and User-Defined Shortcuts
• Using Variables
• Select Lists
• SQL Templates
• Executing Statements and Scripts
• Saving Results to Different Formats
• Using Explain Plans
• Using Auto Trace
• SQL*Plus Compatibility

TOAD Procedure Editor
• Predefined and User-Defined Shortcuts
• Using Variables
• Select Lists
• SQL Templates
• PL/SQL Object Templates
• Creating, Compiling and Executing PL/SQL Code
• Using DBMS_OUTPUT
• Debugging PL/SQL Code

Using TOAD for DBA Tasks
• Maintaining Tablespaces
• Viewing the Alert Log File
• Checking the Overall Health of the Database
• Monitoring SQL Currently in the Shared Pool
• Determining Resource-Intensive Sessions
• Monitoring and Killing User Sessions
• Maintaining Objects

Enter your email address to register for our newsletter: