back to Course Categories | back | print
TOAD Tips and Techniques for Power Users          

Duration: 2 days

Description 
This class is designed to develop skill working with the advanced features of TOAD. SQL and PL/SQL developers will learn how to leverage TOAD to develop SQL and PL/SQL applications.

Topics

  • Installing TOAD
  • Schema Browser functions
  • Multiple connections
  • Edit and export data
  • TOAD options
  • Viewing data
  • Viewing tablespaces
  • TOAD utilities
  • Using explain plan
  • Script manager
  • SQL and Procedure editor
  • Creating a project
  • Syntax checking
  • Code profiling
  • SQL modeler
  • SQL command recall
  • Create database objects
  • Creating constraints
  • Analyzing tables
  • Drop and truncate tables
  • TOAD monitor
  • Export and import
  • Compare schemas
  • SQL analyzer
  • SQL tracing
  • Ask the Xpert
  • PL/SQL profiler
  • Master/detail browser
  • PL/SQL Knowledge Xpert
  • Project manager

Prerequisites

  • Fundamentals of SQL programming
  • Basic understanding of TOAD


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design