Mastering Oracle APEX 23-24: Workflows and Security

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

Audience

• Developers
• Database administrators
• IT professionals

Oracle APEX (Application Express) is a low-code development platform that enables users to build scalable, secure enterprise applications.

This instructor-led, live training (online or onsite) is aimed at intermediate-level developers and IT professionals who wish to learn how to leverage new features in APEX 23-24, design efficient workflows, and ensure application security.

By the end of this training, participants will be able to:

• Develop and manage APEX applications using the latest features in versions 23-24.
• Design and implement efficient workflows within APEX.
• Apply advanced security measures to protect APEX applications and data.
• Integrate APEX applications with external systems and ensure smooth data exchange.
• Test, debug, and deploy APEX applications following best practices.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

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