Oracle - Online Course

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.

This series is for programmers and database administrators who will be using PL/SQL with Oracle database products or Oracle Developer/2000. This online course contains 6 lessons and should take approximately 36 hours to complete.

Lesson 1: Introduction to PL/SQL (5.0) hours

Introduction to PL/SQL teaches you how to describe the building blocks of PL/SQL and its environment, explain the benefits of the basic components of PL/SQL structures, explain the benefits of packages over stand-alone procedures and functions, create various types of triggers, and create and use procedures. This course provides an introduction to the PL/SQL, Oracle's procedural language extension to SQL. Topics include PL/SQL, PL/SQL Structures, Packages, Triggers, and Stored Procedures.

Lesson 2: Overview of Developer/2000 (6.0) hours

Overview of Developer/2000 teaches you how to navigate the menus and toolbars of the development environment, describe the features available for editing and debugging an application, and explain the features that provide object-orientation, product integration, and OLE2 support. This course 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. Topics include 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, and Object Orientation and OLE2.

Lesson 3: Forms 4.5 and Reports 2.5 (6.0) hours

Forms 4.5 and Reports 2.5 teaches you how to develop a Forms application, a menu, and a library, use the PL/SQL Editor in Oracle Forms, develop tabular and master/detail reports, and use the Data Model Editor, Parameter Form Editor, and Program Unit Editor in Oracle Reports. This course provides an overview of Oracle Forms 4.5 and Oracle Reports 2.5. Topics include 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, and Displaying Report-Style Formats.

Lesson 4: Graphics 2.5 and Procedure Builder 1.5 (6.0) hours

Graphics 2.5 and Procedure Builder 1.5 teaches you how to develop a pie chart and a column chart, use the Chart Template Editor in Oracle Graphics, develop functions, procedures, packages, and database triggers, and use the Database Trigger Editor in Oracle Procedure Builder. This course provides an overview of Oracle Graphics 2.5 and Oracle Procedure Builder 1.5. Topics include 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, and Debugging PL/SQL Program Units.

Lesson 5: Developer/2000 Applications (8.0) hours

Developer/2000 Applications teaches you how to create Oracle Forms templates containing visual attributes, property classes, a toolbar, and triggers, use OLE2 in your application, use Visual Basic Custom Controls to enhance your application, create Oracle Reports templates containing standard headers, trailers, and margin items, create break, drill-down, and integrated application reports using templates and OLE2, add buttons and PL/SQL to drill-down into a detail report, and create a report trigger for auditing. This course explores the development of applications using Oracle Forms and Oracle Reports. Topics include Developing Oracle Forms Applications, and Developing Oracle Reports Applications.

Lesson 6: Developer/2000 Integration (5.0) hours

Developer/2000 Integration teaches you how to create a parameter-driven display, pass parameters from Oracle Forms to Oracle Graphics, create a format trigger to conditionally modify a chart, import an image file, create multiple environments for development, testing, demonstration, training, and production, recognize GUI styles and standards, optimize memory, disk space, and performance, and insert OLE2 objects into an Oracle database. This course 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. Topics include Developing Oracle Graphics Applications, and Integration and Deployment in the Windows Environment.