Oracle

This series presents the common features shared by the Oracle Developer/2000 suite of tools, including Forms 4.5, Reports 2.5, Graphics 2.5, and Procedure Builder 1.5. It covers navigation of the development environment and describes editing and debugging features, as well as features that provide object orientation, integration, and OLE2 support. The series covers each tool in greater detail, examining the capabilities and functions of each. Advanced topics covered include the development of applications using Forms and Reports, and the integration of Oracle applications through a single point of entry for the user.

Syllabus

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

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

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

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

DEVELOPER/2000 APPLICATIONS

Explores the development of applications using Oracle Forms and Oracle Reports.

• Developing Oracle Forms Applications
• Developing Oracle Reports Applications

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

Qualifications

Qualification: Printable Transcript

On completion of this course you may print a transcript off as evidence of your progression throughout the course.

Requirements for Entry

There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.

Study Options

If you do not have Internet access, or would prefer to study this course via the traditional paper/postal based study method, you can find more information on the course by clicking on the link below.

Study Hours

This is only an approximate figure and is dependant upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material. Furthermore, at the end of each lesson there is a question paper that needs to be completed and returned to your tutor. You should allow at least 1 - 2 hours of study to complete each question paper.

The approximate amount of time required to complete the course is: 40 hrs.