Mastering Oracle APEX 23-24: Workflows and Security Training Course

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