|
|
|
|
|
|
Oracle Training Overview
This Oracle 10g courseware training guide book will provide application software developers with the skills to build and customize advanced enterprise-scale web applications using the Oracle10g Forms product.
Oracle Training Prerequisites
The following courses are mandatory prerequisites for this course:
- The course Oracle Database 10g: Introduction to SQL
- The course Oracle Database 10g: Programming With PL/SQL
- The course Oracle10g Forms I: Build Internet Applications
Oracle Training Audience
The target audience for this course is web application developers and designers, as well as their management, who will be developing and customizing complex Internet applications using the Oracle10g Forms product.
Oracle Training Objectives
Major subject areas to be explored are:
- Building client-side triggers and program units to customize forms applications.
- Dynamically controlling form objects and behavior during runtime.
- Taking advantage of built-in functions and procedures.
- Writing efficient and well-tuned client-side logic.
- Integrating multiple Oracle10g modules into enterprise applications.
- Exploiting object-oriented features to maximize reuse of components.
- Specialized techniques such as hierarchical trees, procedure data blocks, and timers.
- Integrating forms logic with database server objects into a cohesive solution.
Oracle Training Certification Examination
Tests for the Oracle Certified Professional program are administered by Sylvan Prometric, Inc. This course applies to the certification as an "Oracle PL/SQL & Forms Developer". Specifically, this course considers subjects included within the examination entitled "Oracle Forms Developer: Build Internet Applications".
Following any training sessions Oracle Corporation recommends six-months production experience with the technology prior to taking the certification examinations. While this is good practice it may not be necessary for all individuals.
Oracle Training Course duration
5 Days
Oracle Training Course outline
DEVELOPING PROGRAMS WITHIN FORMS
- ABOUT ORACLE10g PROGRAM DEVELOPMENT
- UNDERSTANDING CLIENT-SIDE TRIGGERS
- UNDERSTANDING CLIENT-SIDE PROGRAM UNITS
- UNDERSTANDING BUILT-IN SUBPROGRAMS
- UNDERSTANDING PL/SQL LIBRARIES
THE PL/SQL EDITOR - UNDERSTANDING PL/SQL EDITOR CONCEPTS
- USING THE PL/SQL EDITOR
- USING THE PL/SQL EDITOR PRODUCTIVITY FEATURES
THE VALIDATION TRIGGERS - USING THE VALIDATION TRIGGERS
- USING WHEN-VALIDATE-ITEM
UNDERSTANDING BUILT-INS USING ALERTS - UNDERSTANDING BUILT-IN CONCEPTS
- CATEGORIES OF BUILT-INS
- CALLING BUILT-IN PROCEDURES VS. FUNCTIONS
- USING OBJECT ID REFERENCES
- REFERENCING OBJECT PROPERTIES
- USING THE ALERT BUILT-INS
USING THE ITEM BUILT-INS - UNDERSTANDING ITEM BUILT-INS
- USING GENERAL ITEM BUILT-INS
- USING NAVIGATION ITEM BUILT-INS
- USING ITEM BUILT-INS TO GET & SET PROPERTIES
SPECIALTY ITEM BUILT-INS - ABOUT SPECIALTY ITEM BUILT-INS
- USING GUI CONTROL ITEMS BUILT-INS
- USING MENU ITEM BUILT-INS
- USING IMAGE ITEM BUILT-INS
USING BUILT-INS FOR OTHER FUNCTIONAL OBJECTS - ABOUT THE FUNCTIONAL OBJECT BUILT-INS
- USING THE BLOCK BUILT-INS
- GET_BLOCK_PROPERTY() & SET_BLOCK_PROPERTY()
- TRUE / FALSE Properties List
- USING THE RECORD BUILT-INS
- USING THE LOV BUILT-INS
- USING THE EDITOR BUILT-INS
- USING THE RELATION BUILT-INS
- ABOUT RESTRICTED BUILT-INS
USING APPLICATION & MODULE BUILT-INS - ABOUT THE APPLICATION & FORM BUILT-INS
- USING THE APPLICATION BUILT-INS
- USING THE FORM BUILT-INS
SPECIALIZED PROGRAMMING TECHNIQUES - ABOUT THE TECHNIQUES
- USING SYSTEM VARIABLES
- USING GLOBAL VARIABLES
- USING INDIRECT REFERENCES
INTERMEDIATE-LEVEL TRIGGERS AND BUILT-INS - ABOUT INTERMEDIATE-LEVEL TRIGGER CATEGORIES
- USING END USER ACTION TRIGGERS
- USING NAVIGATIONAL TRIGGERS
- USING QUERY TRIGGERS & BUILT-INS
- USING BLOCK PROCESSING TRIGGERS
- USING KEY TRIGGERS & BUILT-INS
DYNAMIC CONTROL OVER VISUAL OBJECTS - WORKING WITH VISUAL OBJECTS
- USING THE WINDOW BUILT-INS & TRIGGERS
- USING THE CANVAS BUILT-INS
ERROR CUSTOMIZATION
ADVANCED FORMS CUSTOMIZATION - ABOUT RECORD GROUPS & DYNAMIC LISTS
- USING RECORD GROUPS
- USING DYNAMIC LISTS
APPLICATIONS WITH MULTIPLE MODULES - ABOUT MULTIPLE MODULES & PARAMETER LISTS
- CALLING FORM MODULE BUILT-INS
OBJECT ORIENTATION, PROPERTY CLASSES - UNDERSTANDING OBJECT ORIENTATION CONCEPTS
- OBTAINING INHERITANCE WITH PROPERTY CLASSES
OBJECT ORIENTATION, BUILDING REUSABLE COMPONENTS - ABOUT REUSABLE COMPONENTS
- OBTAINING INHERITANCE WITH OBJECTS
- USING OBJECT GROUPS
- USING OBJECT LIBRARIES
OBJECT ORIENTATION, WRITING REUSABLE LOGIC - UNDERSTANDING ADVANCED OBJECT PRINCIPLES
- OBJECT ORIENTATION WITH PACKAGES
- OBJECT ORIENTATION WITH PL/SQL LIBRARIES
INTEGRATING SERVER-SIDE LOGIC - ACCESSING DATABASE SERVER-SIDE LOGIC
- INTEGRATING DATABASE CONSTRAINTS
- INTEGRATING DATABASE PROCEDURES
- INTEGRATING DATABASE TRIGGERS
BUILDING STORED PROCEDURE DATA BLOCKS - CHOOSING THE DATA BLOCK SOURCE
- IMPLEMENTING STORED PROCEDURE DATA BLOCKS
HIERARCHICAL TREES - WHAT ARE HIERARCHICAL TREES?
- CREATING THE HIERARCHICAL TREE
- POPULATING THE TREE WITH DATA
- HIERARCHICAL TREE TRIGGERS & SYSTEM VARIABLES
- USING FTREE() & HIERARCHICAL TREE BUILT-INS
- ADD_TREE_DATA()
- ADD_TREE_NODE()
- DELETE_TREE_NODE()
- GET_TREE_NODE_PARENT()
- GET_TREE_NODE_PROPERTY()
- GET_TREE_PROPERTY()
- GET_TREE_SELECTION()
- POPULATE_GROUP_FROM_TREE()
- POPULATE_TREE()
- SET_TREE_NODE_PROPERTY()
- SET_TREE_PROPERTY()
- SET_TREE_SELECTION()
- FIND_TREE_NODE()
|
|
|
|
|
