|
| SUMMARY: |
This course is an introduction to Toad features and its functionality that will immediately impact end-user productivity. It will help improve student’s use of Toad in their daily work environment. All aspects of Toad will be covered, including the use of students’ tables in class. |
| AUDIENCE: |
Data Analysts, Developers, and End-Users |
| PREREQUISITES: |
Basic understanding of Oracle tables and the SQL language
|
| OBJECTIVES: |
At the end of this course, delegates will be able to:
- Create SQL statements with the aid of the features of SQL Editor.
- View different objects stored in their schema.
- Tune queries
- Use SQL Modeler to build SQL statements
- Understand the tips and tricks regarding customizing Toad’s options
- Manage Oracle projects with Project Manager
- Build PL/SQL objects using Procedure Editor features
- Debug PL/SQL objects
- Use Profiler to determine tuning candidates
|
| COURSE CONTENT: |
- Toad Overview
- Logging On and Off
- Schema Preparation
- The Basics
- SQL Editor
- Data Grids
- Procedure Editor
- Schema Browser
KEW/08 |
|
© 2007 Verhoef Training, Inc.
|