Oracle Series

Oracle Series
Total Time: 35 hours

Recommended Prerequisite:
A basic understanding of how to retrieve information from relational databases using SQL

Oracle: Introduction to PL/SQL

Time: 5 hours

PLSC01

Oracle: Introduction to PL/SQL provides an introduction to the PL/SQL, Oracle's procedural language extension to SQL.

PL/SQL

PL/SQL Structures

Packages

Triggers

Stored Procedures

Oracle: Overview of Developer/2000

Time: 6 hours

ORDC01

Oracle: Overview of Developer/2000 presents the common features shared by the suite of tools in Oracle Developer/2000. These tools include Oracle Forms 4.5, Oracle Reports 2.5, Oracle Graphics 2.5, and Oracle Procedure Builder 1.5.

Introducing Oracle Applications

The Windows Interface

The Object Navigators

Setting Object Properties

Introducing the Layout Editors

Working with Objects in the Layout Editor

Introducing the PL/SQL Editors

Getting Help

Object Orientation and OLE2

Oracle: Forms 4.5 and Reports 2.5

Time: 6 hours

ORDC02

Oracle: Forms 4.5 and Reports 2.5 provides an overview of Oracle Forms 4.5 and Oracle Reports 2.5.

Overview of Oracle Forms

Introducing Forms Designer

The Layout Editor

The PL/SQL and Menu Editors

Creating Forms Objects and Libraries

Overview of Oracle Reports

Introducing Reports Designer

The Reports Designer Editors

Displaying Report-Style Formats

Oracle: Graphics 2.5 and Procedure Builder 1.5

Time: 6 hours

ORDC03

Oracle: Graphics 2.5 and Procedure Builder 1.5 provides an overview of Oracle Graphics 2.5 and Oracle Procedure Builder 1.5.

Overview of Oracle Graphics

Introducing Graphics Designer

The Layout Editor

The Chart Template and Program Unit Editors

Displaying Chart Types

Overview of Procedure Builder

Introducing Procedure Builder

The Procedure Builder Editors

Debugging PL/SQL Program Units

Oracle: Developer/2000 Applications

Time: 8 hours

ORDC04

Oracle: Developer/2000 Applications explores the development of applications using Oracle Forms and Oracle Reports.

Developing Oracle Forms Applications

Developing Oracle Reports Applications

Oracle: Developer/2000 Integration

Time: 4 hours

ORDC05

Oracle: Developer/2000 Integration explores the incorporation of Oracle Graphics displays into an application and the integration of Oracle Forms, Oracle Reports, Oracle Graphics, and Oracle Procedure Builder applications through a single point of entry for the user.

Developing Oracle Graphics Applications

Integration and Deployment in the Windows Environment