Introduction to TOAD for Oracle

Professional Training Solutions Ltd

Add to wishlist

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 1 Day
Call: +971 4 5490356

Course details

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

Prerequisites:

No previous experience of TOAD required. Some Oracle experience is beneficial.

Installation/Migration/Connecting Topics:

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 & auto substitution

Schema Browser Tips and Techniques :

viewing/changing Data
creating reports,
extracting Data
working with scripts
working with spreadsheets

Working with PL/SQL:

develop, execute, and debug PL/SQL routines
work with templates to create procedures/functions/triggers

Query Builder/ER Diagrammer/Master Detail Browser :

viewing application data relationships
viewing related Data

Tuning with TOAD:

explain plans
finding problem SQL using TOAD’s interface to wait events
TOAD’s session interface to SQL
using the Oracle Trace Facility

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current Oracle jobs in UAE