Advanced Application Express

 Click here

Course Overview

Advanced Oracle Application Express (ApEx) is designed to take your ApEx applications to the next level by utilizing advanced techniques

The presentation style is a series of concise lessons, with each lesson preparing students to apply the knowledge gained in a challenging exercise based on a real-world situation.

Course Goals

• To expand the students knowledge of the APEX development environment and its capabilities.
• To provide students with the skills necessary to take full advantage of the APEX rapid application develop environment to produce real world applications.
• To obtain hands-on experience through exercises in an instructor-led environment, promoting interactive learning.

Prerequisites

• A fundamental knowledge of the ApEx development environment
• A good working knowledge of PL/SQL
• A basic knowledge of Hyper Text Markup Language (HTML)
• A basic knowledge of JavaScript
• A basic knowledge of Cascading Style Sheets

Who Should Attend?

• Any one wishing to gain an understanding of some of the advanced capabilities of the APEX rapid application development environment.

Course Materials

• APEX Course Notes
• APEX Handbook

Duration

• Two (2) days

Course Outline

• JavaScript and Apex Applications
  • Brief review of JavaScript Basics
  • Integrating JavaScript into Apex
  • ApEx supplied JavaScript
  • Quick fills
  • Number formatting and calculations
  • AJAX for dependent LOVs and partial page refresh
  • Custom LOV popups returning multiple values (like Oracle Forms)
  • Arrow navigation in tabular forms
  • Hiding and showing, items, regions, columns
  • Detecting item changes and warning when leaving page
  • More.....
• Using ApEx APIs for custom forms with collections, validations and checksum
• Advanced Reporting
  • High lighting programmatically
  • Named column templates
  • Header tricks
  • Vertical Reports
  • Custom PDF printing with FOP
• Page Layout Tricks
• Making multiple applications act as one
• Essential global processes
• Advanced security topics
• And a bunch of little tricks