Course Outline

Introduction to Oracle APEX 23-24

  • Overview of Oracle APEX 23-24
  • Key features and improvements in APEX 23 and 24
  • APEX architecture and components

Setting Up APEX Environment

  • Installation and configuration of Oracle APEX 23-24
  • Overview of Oracle REST Data Services (ORDS)
  • Creating and managing APEX workspaces

Building Applications

  • Creating a new application
  • Using Universal Theme and page components
  • Introduction to Page Designer

Advanced Components and Features

  • Interactive grids, charts, and forms
  • Using RESTful Web Services and REST Data Sources
  • Integrating external data using the OData Connector

Introduction to Workflows

  • Overview of workflow capabilities in APEX
  • Key components of a workflow: Tasks, Approvals, Actions

Designing and Implementing Workflows

  • Creating and configuring workflows
  • Defining task parameters and outcomes
  • Using Action Tasks and Approval Processes
  • Managing workflow participants and roles

Advanced Workflow Management

  • Enhancements in APEX 23.2 and 24.1 for workflows
  • Iterative development with Fusion Apps Extensions

APEX Security Fundamentals

  • Understanding APEX security architecture
  • Authentication and authorization mechanisms
  • Managing user roles and privileges

Advanced Security Features

  • Implementing fine-grained access control
  • Data encryption and protection
  • Secure coding practices in APEX

Security Enhancements in APEX 23-24

  • New security features and improvements
  • Secure REST Data Sources and API integrations
  • Automating security checks and audits

Integrating APEX with Other Systems

  • Integrating APEX applications with Oracle and third-party systems
  • Using RESTful services and APIs for integration

Testing and Debugging

  • Testing APEX applications for functionality and security
  • Debugging workflows and resolving common issues

Deployment and Maintenance

  • Best practices for deploying APEX applications
  • Continuous integration and delivery (CI/CD) for APEX
  • Maintaining and upgrading APEX applications

Summary and Next Steps

Requirements

  • Basic understanding of SQL and PL/SQL
  • Familiarity with web development concepts

Audience

  • Developers
  • Database administrators
  • IT professionals
 21 Hours

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

  • Pre-course call with your trainer
  • Customisation of the learning experience to achieve your goals -
    • Bespoke outlines
    • Practical hands-on exercises containing data / scenarios recognisable to the learners
  • Training scheduled on a date of your choice
  • Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from €6840 online delivery, based on a group of 2 delegates, €2160 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Contact us for an exact quote and to hear our latest promotions


Public Training

Please see our public courses

Testimonials (1)

Provisonal Upcoming Courses (Contact Us For More Information)

Related Categories