Oracle course

Total Items: 6 Total Time: 36.00 hour(s)

Summary:

This training 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.

Learning Segment  1 : Introduction to PL/SQL

Summary:

This learning segment 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

Learning Segment 2: Overview of Developer/2000

Summary:

This learning segment 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

Learning Segment 3: Forms 4.5 and Reports 2.5

Summary:

This learning segment 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

Learning Segment 4: Graphics 2.5 and Procedure Builder 1.5

Summary:

This learning segment 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

Learning Segment 5: Developer/2000 Applications

Summary:

This learning segment 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

Learning Segment 6: Developer/2000 Integration

Summary:

This learning segment 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

Features:

• Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
• Activities allow learners to apply course concepts in an interactive questioning environment.
• Exercises allow learners to practice in the actual application being studied.
• Supplied sample files include sample documents, application files, programs, and programming code that enable learners to practice with these files, enhancing the learning experience.
• A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
• Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary.
• In addition, it lets them find other occurrences of the term in the same course.
• Search text enables learners to rapidly search all text within a course to easily retrieve information required.
• Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
• A skill assessment generates a customized learning path based on the results of a pre-test.
• A glossary provides a reference for definitions of unfamiliar terms.
• Bookmarking tracks the learner's progress in a course.

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.