Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Oracle TOAD

( Duration: 1 Day )

This Oracle TOAD training course covers all of the features necessary to develop, manipulate, and debug PL/SQL code, develop & tune SQL statements, using Query Builder and ER tools, and discover useful features of TOAD. You will also see the data relationships of the application data and how to view/save this data. We will illustrate the latest features of TOAD necessary to view, extract, and manipulate data within the Oracle database.

The Oracle TOAD class is ideal for:

  • Those looking to expand their knowledge and understanding of Oracle database relationships, debugging PL/SQL and DB manipulation.

COURSE AGENDA

1

Working with SQL

  • viewing/changing Data
  • Creating reports
  • Extracting Data
  • working with SQL
  • Discovering all of the help available
  • Creating SQL with minimal key strokes using templates and auto substitution)
2

Schema Browser Tips and Techniques

  • Working with PL/SQL (PL/SQL routines, templates to create procedures/functions/triggers)
3

Query Builder/ER Diagrammer/Master Detail Browser

4

Tuning with TOAD

  • Explain plans
  • Wait events
  • TOAD session interface to SQL
  • Oracle Trace Facility
5

Using the new Fast Reports reporting tool

  • Miscellaneous topics include TOAD configuration and other topics not covered in the other areas such as using the TOAD session monitor, viewing useful data dictionary information, database compare/export
6

Methods of creating DDL and data-oriented scripts.

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X