Advanced Oracle Application Express

Advanced Oracle Application Express (DFAS_APEX_2)

Course Length: 4 days
Delivery Methods: Available as private class only
Course Overview

Participants in this APEX intermediate class will extend the skills learned in the Fundamental class by exploring more-advanced topics, including APEX best practices, navigation, region and item layout, themes and templates, security, and much more. 

Course Benefits
  • Learn best practices for using APEX
  • Learn how to use navigation entries, lists, and breadcrumbs to connect pages
  • Learn how to create custom report templates
  • Learn how to create custom charts and interactive grids
  • Learn how to build a custom plugin
  • Learn how to work with loaded data
  • Learn how to work with files
  • Learn to address a variety of security threats
  • Learn how to publish and consume RESTful services
Course Outline
  1. APEX Best Practices
    1. Customizing the install for easier backups
    2. Managing developers and user accounts
    3. Securing applications
    4. Preventing URL tampering
    5. Managing External Files
    6. Techniques to Make Development Easier
    7. Developing a Standard Application to Copy
  2. Navigation
    1. How to use Navigation Entries, Lists, and Breadcrumbs to connect pages
    2. Using components on the global page (page zero)
    3. Resolve missing Navigation Entries and Breadcrumbs
  3. Region and Item Layout
    1. How to leverage Grid Layout for Regions and Items
    2. How to change region positions
    3. Understand how page templates works
  4. Reports
    1. Customize report templates
    2. Discuss column templates vs row templates
    3. Understand generic column vs named column reports
  5. Charts
    1. How to create and manage pie and bar charts
    2. JET Chart basics
  6. Interactive Grids
    1. Create Interactive Grid
    2. Declarative row-level validations
    3. Adding custom processing
    4. Review the importance of record locking
  7. Themes and Templates
    1. Creating Custom Templates
    2. Using Subscriptions
  8. Build a plugin
    1. Plugin interface and the different functions that exist: render, ajax, validate, and meta
    2. Understand how a plugin renders
    3. Create an AJAX call and process to update the plugin
    4. Bind to the native API so it works with native dynamic actions
  9. Data Loading
    1. Create data upload form for users
    2. Process CSV and other delimited data
    3. Transform the data upon upload
    4. Validate and reject rows
  10. Dynamic Actions
    1. Refresh items and regions
    2. Invoke PL/SQL processes from browser events
    3. Retrieve data from the DB and set items values
  11. Working with Files
    1. User managed files in the database
    2. Developer files on the web server (JavaScript, css, and images)
    3. Upload shared component files
    4. REST services for Media Resources
  12. Understanding Session State
    1. Understand the difference between persisted and in-memory session state
    2. How row fetch and row processing actually works
    3. Explore some of the features those processes provide
  13. Security
    1. Custom Authentication and Authorization
    2. Implementing LDAP and SSO
    3. Using Virtual Private Database (VPD)
    4. Using Session State Protection
    5. Preventing SQL Injection
    6. Preventing Cross-Site Scripting
    7. Managing Application Development
  14. APEX Office Print
    1. How to use the scheduler to run jobs
  15. REST services – Publish
    1. ORDS (Oracle Restful Data Services) requirements
    2. Create a declarative services to expose data for disparate systems
  16. REST services – Consume
    1. Read web service data from PL/SQL
    2. Perform AJAX operations to retrieve data
    3. apex.process javascript object
  17. Application change management, conflicts, and versioning
  18. Troubleshooting and debugging
Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Live Private Class
  • Private Class for your Team
  • Live training
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Proposal