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
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