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

Introduction to Oracle APEX 23-24

• General overview of Oracle APEX 23-24
• Principal features and enhancements in APEX 23 and 24
• Architecture and core components of APEX

Configuring the APEX Environment

• Installing and setting up Oracle APEX 23-24
• Overview of Oracle REST Data Services (ORDS)
• Creation and administration of APEX workspaces

Application Development

• Initiating a new application project
• Leveraging the Universal Theme and page components
• Getting started with the Page Designer

Advanced Components and Features

• Interactive grids, charts, and forms
• Utilizing RESTful Web Services and REST Data Sources
• Integration of external data via the OData Connector

Foundations of Workflows

• Overview of workflow capabilities within APEX
• Essential workflow elements: Tasks, Approvals, and Actions

Workflow Design and Implementation

• Construction and configuration of workflows
• Specification of task parameters and outcomes
• Utilization of Action Tasks and Approval Processes
• Oversight of workflow participants and roles

Advanced Workflow Administration

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

Core APEX Security Concepts

• Comprehension of APEX security architecture
• Mechanisms for authentication and authorization
• Management of user roles and privileges

Advanced Security Capabilities

• Implementation of fine-grained access control
• Data encryption and protective measures
• Adherence to secure coding practices in APEX

Security Advancements in APEX 23-24

• New security features and recent improvements
• Secure REST Data Sources and API integrations
• Automation of security checks and audits

System Integration with APEX

• Integration of APEX applications with Oracle and third-party systems
• Employment of RESTful services and APIs for connectivity

Testing and Troubleshooting

• Verification of APEX application functionality and security
• Debugging workflows and resolving prevalent issues

Deployment and Upkeep

• Best practices for the deployment of APEX applications
• Continuous integration and delivery (CI/CD) strategies for APEX
• Maintenance and version upgrading of APEX applications

Recap and Future Steps