Data Private On-Demand

Advanced Oracle APEX Training (APEX201)

5 days
OracleOracle Application Express (APEX)

Advance your Oracle Application Express (APEX) skills and build more capable, secure, and maintainable applications.

Talk to a Learning ConsultantRequest a Private Class

Register or Request Training

  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal
Price per student
$249.75 or 5 vouchers
  • On-Demand 24/7
  • Readings, Video Presentations, Exercises
  • Quizzes to knowledge check
  • Life-Time Access

Course Overview

Advance your Oracle Application Express (APEX) skills and build more capable, secure, and maintainable applications. Designed for developers who already have experience with Oracle APEX, this hands-on course explores the features that help you solve more complex application development challenges.

Working alongside a live expert instructor, you’ll learn how to manage session state, build sophisticated data loading processes, strengthen application security, create dynamic navigation, develop interactive grids and charts, customize themes and templates, build plug-ins, and create advanced dynamic actions. You’ll also gain experience working with files, generating documents with APEX Office Print, integrating RESTful services, managing application changes, and troubleshooting applications with Oracle APEX debugging tools.

Throughout the course, you’ll complete hands-on labs that reinforce best practices for building secure, maintainable Oracle APEX applications. Each exercise is designed to help you apply advanced features in realistic development scenarios so you can confidently incorporate them into your own projects.

By the end of the course, you’ll be able to implement advanced Oracle APEX features, integrate external services, strengthen application security, manage application changes, and troubleshoot complex applications more effectively.

Course Benefits

  • Master advanced features and functionalities of Oracle Application Express (APEX).
  • Gain expertise in session state management and data loading techniques.
  • Learn to implement robust security measures including custom authentication and authorization.
  • Enhance user experience with advanced navigation, dynamic actions, and interactive elements.
  • Develop skills in creating and using APEX plug-ins and RESTful services.
  • Understand best practices for troubleshooting, debugging, and application change management.
  • Acquire practical experience through hands-on exercises and real-world scenarios.
  • Learn to use APEX Office Print for generating professional reports and documents.
  • Improve data presentation with advanced charting and interactive grids.
  • Explore themes and templates to create consistent and visually appealing applications.

Delivery Methods

Private Class
Delivered for your team at your site or online.
On-Demand
Learn at your own pace with 24/7 access.

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)

Class Materials

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

Class Prerequisites

Experience in the following is required for this Oracle Application Express (APEX) class:

  • SQL
  • PL/SQL
  • Prior experience with or training in Oracle APEX

Experience in the following would be useful for this Oracle Application Express (APEX) class:

  • Some Web Development experience with:
    • HTML
    • CSS
    • JavaScript and jQuery

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant