top of page

Advanced APEX Training Content

Version 22.1

Training Duration : 16 hrs

1. Introduction to JavaScript

  • JavaScript in Oracle APEX

  • JavaScript vs jQuery vs APEX API

  • Declaring and Defining at Page Level

  • JavaScript on Dynamic Action

  • JavaScript Initialization

2. AJAX Callback

  • Introduction to AJAX Callback

  • Defining the Server Logic (PL/SQL)

  • Defining the Client Logic (JavaScript)

  • Examples

3. Interactive Grid (IG) in Details

  • Rendering new IG toolbar buttons using JS

  • Defining actions for the new toolbar buttons

  • Removing existing actions from the IG

  • Defining actions for the IG selected records

  • Client side validations

  • Adding row level actions and listening to data changes

4. APEX JavaScript API

  • Introduction to JavaScript APIs in APEX

  • apex.message

  • apex.page

  • apex.util

5. Understanding ORDS in Details

  • Introduction to ORDS

  • ORDS in details

  • ORDS PL/SQL package reference 

6. Securing Web Services

  • Understanding different ways to secure web services

  • OAUTH 2.0

  • Defining roles and privileges

  • Accessing the protected web services

7. Important APEX APIs

  • Introduction to APEX APIs

  • APEX_APPLICATION

  • APEX_COLLECTION

  • APEX_MAIL

  • APEX_UTIL

  • APEX_WEB_SERVICE

8. APEX Collections in Details

  • Basics of APEX collections

  • Different methods used in collections

  • Collection examples 

  • APEX Collection API 

bottom of page