Detailed information
| Duration: | 3 Days |
|---|---|
| Price: | £1,495 (VAT will be added to this price) |
| Type: | Training |
| Method: | In a classroom |
| Accreditation: | See course outling for details |
| Prepares for: | Together with the Oracle Forms - Part I course, the content of the Oracle Forms - Part II course is suitable for delegates intending to sit the Oracle PL/SQL Developer OCA examination #1Z0-141: Oracle Forms: Build Internet Applications. |
| Geared towards: | Designed for programmers and software developers who are already familiar with the basic features of Oracle Forms. This Oracle Forms - Part II course is designed to introduce delegates to the more advanced features of Oracle Forms. |
| Requirements: | Requirements Attendance on the pre-requisite courses or practical experience in developing basic Oracle Forms applications. Pre-Requisite Courses • Oracle Forms - Part I |
| Internship: | none |
| Students per class: | 10 |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
Skills Gained
The delegates will practise:
• Implementing mouse and key triggers
• Creating and using timers
• Generating and manipulating runtime record groups
• Controlling Data Block relationships explicitly
• Building multiple-form applications
• Generating custom menus
• Defining Data Blocks based on objects, queries and procedures
• Using Database Server features within a form
• Reusing standard components and Java Beans
Who will the Course Benefit?
Programmers and other software development personnel who need to write write Oracle Forms applications which interface with an Oracle database. Practical experience of the Oracle PL/SQL programming language and some experience of designing basic Oracle Forms applications are pre-requirements for this Oracle Forms - Part II course.
Course Contents - DAY 1
Course Introduction
• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions
Session 1: AN INTRODUCTION
• Notes on Course Content
• Preparation
• Exercise: Creating Basic Oracle Forms Applications
Session 2: MOUSE AND KEY TRIGGERS
• Mouse Triggers
• Cursor Styles
• Key Triggers
• Exercise: Implementing Mouse and Key Triggers
Session 3: TIMERS
• Use of Timers
• Creating and Handling Timers
• Timer Triggers and Built-ins
• Exercise: Creating a Clock Timer
Session 4: RECORD GROUPS
• LOVs and Record Groups
• Record Group Types
• Creating Run-time Record Groups
• Built-in Procedures and Functions
• Record Groups and Lists
• Exercise: Using Run-time Record Groups
________________________________________
Course Contents - DAY 2
Session 5: DATA BLOCK RELATIONSHIPS
• Relation Object Properties
• Creating Relationships Manually
• Procedures and Triggers for Coordination
• Modifying Default Functionality
• Exercise: Creating and Modifying a Relation Object
Session 6: MULTI-FORM APPLICATIONS
• Calling Other Forms
• The OPEN_FORM Procedure
• The CALL_FORM Procedure
• The NEW_FORM Procedure
• Related Built-ins
• Passing Data between Forms
• Creating Parameters and Parameter Lists
• Exercise: Calling Oracle Forms and Passing Parameters
Session 7: CREATING CUSTOM MENUS
• Menu Modules, SubMenus and Menu Items
• The Menu Editor
• Menu and Menu Item Properties
• PL/SQL in Menu Modules
• Menu Item Built-ins
• Menu Security
• Menu Parameters
• Popup Menus
• Exercise: Generating a Custom Menu
Session 8: HANDLING DATABASE OBJECTS
• Object Support and Object Types
• Object Tables
• Column Objects
• Handling REF Columns
• Exercise: Handling Objects with an Oracle Form
________________________________________
Course Contents - DAY 3
Session 9: USING OTHER DATA SOURCES
• Data Source Types
• Using a FROM Clause Query
• Using Procedures which return REF Cursors
• Using Procedures which return PL/SQL Index-By Tables
• Implementing DML using Packaged Procedures
• Exercise: Defining and using FROM Clause Query
• Exercise: Defining and using a Packaged Procedure
Session 10: USING ORACLE DATABASE FEATURES
• Database Functionality
• Handling PL/SQL Code
• Handling Database Server Errors
• Using the FORMS_DDL Package
• DDL Functionality
• Exercise: Using the FORMS_DDL Package
Session 11: REUSABLE COMPONENTS
• Reusable Component Definition
• Oracle-Supplied Components
• Using Oracle's Calendar Class Component
• Notes on Active X Controls
• JavaBeans and PJCs
• Exercise: Implementing the Calendar Component
• Exercise: Implementing Pluggable Java Components
Session 12: INCLUDING CHARTS AND REPORTS
• Including Charts
• Oracle Reports Overview
• Running an Oracle Report
• Integrating Oracle Reports with Oracle Forms
• Viewing an Oracle Report
• Exercise: Interfacing with an Oracle Report
The delegates will practise:
• Implementing mouse and key triggers
• Creating and using timers
• Generating and manipulating runtime record groups
• Controlling Data Block relationships explicitly
• Building multiple-form applications
• Generating custom menus
• Defining Data Blocks based on objects, queries and procedures
• Using Database Server features within a form
• Reusing standard components and Java Beans
Who will the Course Benefit?
Programmers and other software development personnel who need to write write Oracle Forms applications which interface with an Oracle database. Practical experience of the Oracle PL/SQL programming language and some experience of designing basic Oracle Forms applications are pre-requirements for this Oracle Forms - Part II course.
Course Contents - DAY 1
Course Introduction
• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions
Session 1: AN INTRODUCTION
• Notes on Course Content
• Preparation
• Exercise: Creating Basic Oracle Forms Applications
Session 2: MOUSE AND KEY TRIGGERS
• Mouse Triggers
• Cursor Styles
• Key Triggers
• Exercise: Implementing Mouse and Key Triggers
Session 3: TIMERS
• Use of Timers
• Creating and Handling Timers
• Timer Triggers and Built-ins
• Exercise: Creating a Clock Timer
Session 4: RECORD GROUPS
• LOVs and Record Groups
• Record Group Types
• Creating Run-time Record Groups
• Built-in Procedures and Functions
• Record Groups and Lists
• Exercise: Using Run-time Record Groups
________________________________________
Course Contents - DAY 2
Session 5: DATA BLOCK RELATIONSHIPS
• Relation Object Properties
• Creating Relationships Manually
• Procedures and Triggers for Coordination
• Modifying Default Functionality
• Exercise: Creating and Modifying a Relation Object
Session 6: MULTI-FORM APPLICATIONS
• Calling Other Forms
• The OPEN_FORM Procedure
• The CALL_FORM Procedure
• The NEW_FORM Procedure
• Related Built-ins
• Passing Data between Forms
• Creating Parameters and Parameter Lists
• Exercise: Calling Oracle Forms and Passing Parameters
Session 7: CREATING CUSTOM MENUS
• Menu Modules, SubMenus and Menu Items
• The Menu Editor
• Menu and Menu Item Properties
• PL/SQL in Menu Modules
• Menu Item Built-ins
• Menu Security
• Menu Parameters
• Popup Menus
• Exercise: Generating a Custom Menu
Session 8: HANDLING DATABASE OBJECTS
• Object Support and Object Types
• Object Tables
• Column Objects
• Handling REF Columns
• Exercise: Handling Objects with an Oracle Form
________________________________________
Course Contents - DAY 3
Session 9: USING OTHER DATA SOURCES
• Data Source Types
• Using a FROM Clause Query
• Using Procedures which return REF Cursors
• Using Procedures which return PL/SQL Index-By Tables
• Implementing DML using Packaged Procedures
• Exercise: Defining and using FROM Clause Query
• Exercise: Defining and using a Packaged Procedure
Session 10: USING ORACLE DATABASE FEATURES
• Database Functionality
• Handling PL/SQL Code
• Handling Database Server Errors
• Using the FORMS_DDL Package
• DDL Functionality
• Exercise: Using the FORMS_DDL Package
Session 11: REUSABLE COMPONENTS
• Reusable Component Definition
• Oracle-Supplied Components
• Using Oracle's Calendar Class Component
• Notes on Active X Controls
• JavaBeans and PJCs
• Exercise: Implementing the Calendar Component
• Exercise: Implementing Pluggable Java Components
Session 12: INCLUDING CHARTS AND REPORTS
• Including Charts
• Oracle Reports Overview
• Running an Oracle Report
• Integrating Oracle Reports with Oracle Forms
• Viewing an Oracle Report
• Exercise: Interfacing with an Oracle Report
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- c/o YSES, The Enterprise Suite, 9th Floor Centre City Tower, 5-7 Hill Street, Birmingham B5 4UA - B5 4UACity and Borough of Birmingham (England)
- c/o ComputerWorld, Apex House, Westerleigh Business Park, Turner Drive, Yate, Bristol, BS37 5YX - BS37 5YCity of Bristol (England)
- 16 St Mary's Street, Edinburgh, EH1 1SU - EH1 1SUCity of Edinburgh (Scotland)
- Halsbury House, Chancellor Court, 21 The Calls, Leeds, LS2 7EH - LS2 7EHCity and Borough of Leeds (England)
- c/o YSES, St James Court, 30 Brown Street, Manchester, M2 1DH - M2 1DHCity and Borough of Manchester (England)
StayAhead Training
StayAhead Training established 1992, centres throughout the UK...... with a team of full time dedicated professional training consultants......
StayAhead Training has been established since 1992 and is one of the UK's leading independent providers of Oracle, Unix, Linux, MySQL, Java, PHP Web Deveopment, ITIL & Business Analysis training.
Scheduled courses are available in 6 centres throughout the UK including London, Birmingham, Manchester, Bristol, Leeds and Edinburgh. We also provide training on our client's premises, this training can be tailored to the specific needs of the client.
Our courses have been designed to ensure that people can fulfil their job role and also help prepare delegates for certification in Oracle, Red Hat, Solaris, MySQL, Linux, SUSE Linux, Java, ITIL, Business Analysis and HP-UX .
Working in association with both the Oracle (OUG) and Hewlett Packard (HPUG) User Groups, StayAhead Training have a reputation of providing high quality value for money training at a cost effective price.
Our quality is assured by a team of dedicated professional training consultants who work full time for StayAhead Training and who blend their training skills with a wealth of hands-on experience.
StayAhead Training has been established since 1992 and is one of the UK's leading independent providers of Oracle, Unix, Linux, MySQL, Java, PHP Web Deveopment, ITIL & Business Analysis training.
Scheduled courses are available in 6 centres throughout the UK including London, Birmingham, Manchester, Bristol, Leeds and Edinburgh. We also provide training on our client's premises, this training can be tailored to the specific needs of the client.
Our courses have been designed to ensure that people can fulfil their job role and also help prepare delegates for certification in Oracle, Red Hat, Solaris, MySQL, Linux, SUSE Linux, Java, ITIL, Business Analysis and HP-UX .
Working in association with both the Oracle (OUG) and Hewlett Packard (HPUG) User Groups, StayAhead Training have a reputation of providing high quality value for money training at a cost effective price.
Our quality is assured by a team of dedicated professional training consultants who work full time for StayAhead Training and who blend their training skills with a wealth of hands-on experience.
