Skip to main content
Request a Training Proposal

Instructor-led training

Advanced Oracle Application Express

Oracle training from Hartmann Software Group, delivered onsite or live online.

Request a Training Proposal View Course Outline

What you'll learn

The advanced APEX course is designed to deepen your students' understanding of Oracle APEX, focusing on advanced features and development techniques. It covers complex topics such as session state management, advanced security measures, and the intricacies of data loading and transformation. This course is structured around practical, hands-on exercises that challenge students to apply what they've learned in real-world scenarios, such as implementing custom authentication, navigating complex data relationships, and optimizing application security.

Prerequisites

HTML, CSS, JavaScript, jQuery

Course Outline

  1. Understanding Session State
    1. What is Session State?
    2. Persisted vs. In-Memory Session State
    3. Session State Illustrated
  2. Data Loading
    1. Creating Our Application (Exercise)
    2. Shared Components: Lists of Values (Exercise)
    3. The HR Schema: Employees
    4. Data Load Definition
    5. Creating the Data Load Definition (Exercise)
    6. Loading New Employees from a CSV (Exercise)
    7. Transforming Data on Import
    8. Error Handling Options
    9. Working with Collections
    10. The Invoke API Process
    11. Working with Packages
    12. Introduction to Wizards (Exercise)
    13. Creating a Data Load Wizard: The Data Load (Exercise)
    14. Creating a Data Load Wizard: The Package (Exercise)
    15. Creating a Data Load Wizard: The Template (Exercise)
    16. Creating a Data Load Wizard: File Upload Form (Exercise)
    17. Font Awesome and Universal Theme Color Classes
    18. Creating a Data Load Wizard: Data Validation (Exercise)
    19. Creating a Data Load Wizard: Data Loading (Exercise)
  3. Advanced Security
    1. Custom Authentication and Authorization
    2. Allowing Employees to Log In (Exercise)
    3. Form Processing
    4. Change Password Page (Exercise)
    5. Setting Up Strong Password Validation (Exercise)
    6. Adding Password Validation (Exercise)
    7. Password Reset Strategies
    8. Forcing a Password Reset (Exercise)
    9. Checking Password Expiry on Every Page Load
    10. Implementing LDAP
    11. Using Virtual Private Database (VPD)
    12. Session State Protection
    13. Preventing SQL Injection
    14. Preventing Cross-Site Scripting (Exercise)
    15. Changing the ADMIN Password for the Internal Workspace
    16. Custom Authorization (Exercise)
  4. Navigation
    1. Shared Components: Navigation and Search
    2. Add Page to Navigation Bar List (Exercise)
    3. The APEX_PAGE.GET_URL Function
    4. Creating and Understanding Dynamic Lists
    5. Navigating Department Employees (Exercise)
    6. Navigation Menu Settings
    7. Breadcrumbs and Drill Downs (Exercise)
    8. Breadcrumbs and Drill Downs: Continued (Exercise)
  5. Charts
    1. Chart Types
    2. Creating a Page with a Bar Chart (Exercise)
    3. Dynamically Changing Chart Settings (Exercise)
    4. Creating a Pie Chart (Exercise)
  6. Interactive Grids
    1. Improving the Data Load Wizard (Exercise)
    2. Data Load Wizard: Adding the Interactive Grid (Exercise)
    3. Data Load Wizard: Saving the Grid (Exercise)
  7. Themes and Templates
    1. Themes and Templates
    2. Creating a New Theme (Exercise)
    3. Best Practice: Create Templates for Applications
  8. Build a Plug-in
    1. Overview of APEX Plug-ins
    2. Creating and Using a Plug-in (Exercise)
  9. Advanced Dynamic Actions
    1. Dynamic Actions with True and False Actions
    2. Dynamic Actions that Execute Client-Side Code (Exercise)
    3. Dynamic Actions that Execute Server-Side Code (Exercise)
    4. Text with Autocomplete (Exercise)
  10. Working with Files
    1. Working With Files in APEX
    2. Adding a Profile Picture (Exercise)
    3. Using CSS Files in APEX (Exercise)
  11. APEX Office Print
    1. APEX Office Print Overview
    2. Configuring APEX for AOP (Exercise)
    3. AOP Template Tags
    4. The Template Files (Exercise)
    5. Creating Word and Excel Files (Exercise)
  12. RESTful Services
    1. REST Data Sources
    2. Making API Requests
    3. HTTP Request Methods
    4. Publishing RESTful Services
    5. Creating a RESTful Data Service (Exercise)
    6. The emp_post_example Resource Template
    7. Creating a RESTful PUT Data Service (Exercise)
    8. Creating a REST Data Source (Exercise)
    9. Creating an Interactive Report from the REST Data Source (Exercise)
  13. Application Change Management
    1. Working Copies
    2. Create a Working Copy (Exercise)
    3. Editing a Working Copy (Exercise)
    4. Comparing Working Copy to Main Application (Exercise)
    5. Merging Changes from Working Copy into Main Application (Exercise)
    6. Refreshing a Working Copy with Changes from Main (Exercise)
  14. Troubleshooting and Debugging
    1. Best Practice: Logging and Debugging
    2. Enabling Debugging
    3. The apex_debug_messages View
    4. Writing Messages to the Debug Log
    5. Debugging PL/SQL with APEX_DEBUG (Exercise)
    6. Viewing Error Information (Exercise)

Training locations

Advanced Oracle Application Express training across the U.S. and beyond.

We provide Advanced Oracle Application Express training onsite and live online for organizations throughout the United States and internationally.

View all Advanced Oracle Application Express training locations

Train your team with HSG

Private, instructor-led training customized for your organization.

  • Onsite or live online delivery
  • Customized curriculum
  • Training for groups of 3 or more
  • Flexible scheduling
  • Experienced instructors
Request a Training Proposal

Questions? Call us at 303.377.6176
or email info@hartmannsoftware.com

Browse all Oracle courses →

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176