◊ ORACLE ONLINE TRAINING SERIES
Online Oracle Training
Database » Oracle
Only $99.95
Oracle Series (36 hours)
ONLINE Oracle TRAINING FEATURES
- Learn Oracle online with these interactive online Oracle courses.
- Affordable Pricing (Only $99.95 for the complete series)
- A full year to complete the Oracle courses
- Retake the Oracle courses as many times as you like
- Measure your progress with assessment tests after each course
- Earn completion certificates after passing each assessment test
1. Introduction to PL/SQL
Time: 5 hours
This course provides an introduction to the PL/SQL, Oracle's procedural language extension to SQL.
Objectives
- 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
- Create and use procedures
Topics
- PL/SQL
- PL/SQL Structures
- Packages
- Triggers
- Stored Procedures
2. Overview of Developer/2000
Time: 6 hours
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.
Objectives
- Navigate the menus and toolbars of the development environment
- Describe the features available for editing and debugging an application
- Explain the features that provide object-orientation, product integration, and OLE2 support
Topics
- 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
3. Forms 4.5 and Reports 2.5
Time: 6 hours
This course provides an overview of Oracle Forms 4.5 and Oracle Reports 2.5.
Objectives
- Develop a Forms application, a menu, and a library
- Use the PL/SQL Editor in Oracle Forms
- Develop tabular and master/detail reports
- Use the Data Model Editor, Parameter Form Editor, and Program Unit Editor in Oracle Reports
Topics
- 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
4. Graphics 2.5 and Procedure Builder 1.5
Time: 6 hours
This course provides an overview of Oracle Graphics 2.5 and Oracle Procedure Builder 1.5.
Objectives
- Develop a pie chart and a column chart
- Use the Chart Template Editor in Oracle Graphics
- Develop functions, procedures, packages, and database triggers
- Use the Database Trigger Editor in Oracle Procedure Builder
Topics
- 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
5. Developer/2000 Applications
Time: 8 hours
This course explores the development of applications using Oracle Forms and Oracle Reports.
Objectives
- 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
- Create a report trigger for auditing
Topics
- Developing Oracle Forms Applications
- Developing Oracle Reports Applications
6. Developer/2000 Integration
Time: 5 hours
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.
Objectives
- 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
- Insert OLE2 objects into an Oracle database
Topics
- Developing Oracle Graphics Applications
- Integration and Deployment in the Windows Environment
Resources for Oracle
