Go Back
Oracle Series
Total Time: 25 - 27 hours
Recommended Prerequisite
SQL: Basic Query Techniques Time: 2 - 4 hours SQL112
SQL: Basic Query Techniques describes how to compile SQL (IBM's Structured QueryLanguage queries to retrieve information from relational databases.
  • SQL Overview
  • Rows and Columns
  • Query Techniques
  • Query Practice

    • Oracle: Introduction to PL/SQL Time: 4 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: 3 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: 4 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: 4 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: 4 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

    • Go Back