Course Title:
Advanced Database Procedures & Triggers

Duration: 2 days

Course Overview
This course gives the delegate a complete understanding in the use of server-based objects in the ever increasing world of client/server technology. It will cover the creation and modification of procedural database objects, such as Procedures, Functions, Packages and Database Triggers. It will also cover various applications for these objects and discuss the use of objects that are supplied with Oracle 8. Extensive hands-on experience will be gained.

Target Audience


It is expected that attendees will be technically involved with application design, development of database administration. Delegates should already have a good understanding of SQL and PL/SQL. Preferably they should have attended the Introduction to SQL & SQL*Plus and introduction to PL/SQL courses.

Course Content








Introduction
to OAS

The
Role of the Oracle Application Server

OAS
Architecture

Single
and Multinode Configurations

Characteristics
of CORBA and Web Applications


Installing
OAS

Hardware
and Software Requirements

Identifying
Product Dependencies

Multinode
Systems

Installation
Life Cycle

Management
of the Application Server

OAS
Manager

Security


Authentication
and Restriction Schemes

Establishing
Secure Web Sessions

Using
SSL



Web Listeners


Types
of Listener

Security
with Web Listeners


Managing Applications
and CORBA-Based Services

Application
Types

Configuring,
Monitoring and Adding Applications

Managing
and Configuring the ORB

Tuning


Configuring


Database
Access

PL/SQL
Applications

JAVA
Applications



Using the
Log Server

Overview


Using
Log Analyser

Procedure
Reports



Migration




My group have used Pentland Training twice in the past two years for in-house Oracle courses. Pentland Training was recommended to us by another group with whom we interact within GSK.

The two courses met all our objectives relating to price, content covered, and tailoring to our needs. The last objective of having customised course content was especially important to us as other training companies tended to offer “one size suits all” training where much of the content was irrelevant to our needs.

Pentland will be our first choice for future training needs.

Data Management Manager
GlaxoSmithKline


Enter your email address to register for our newsletter:


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.

follow us on Twitter