Oracle APEX (Application Express)

Module 1: Introduction to Oracle APEX

• Overview of Oracle Application Express (APEX)
• APEX architecture: Engine, workspace, schema
• APEX use cases: Low-code app development
• APEX versions: 22.x, 23.x, APEX on OCI
• APEX implementation methodology

Module 2: APEX Workspace and Environment

• Workspace creation and administration
• APEX schema and database objects
• SQL Workshop in APEX
• Team Development features
• APEX on Autonomous Database (ATP)

Module 3: APEX Application Builder

• Creating applications from scratch
• Application creation wizards
• Application and page properties
• Application themes and templates
• Universal Theme customisation

Module 4: APEX Pages and Regions

• Page types: Report, form, master-detail
• Region types: Classic, interactive, cards
• Interactive Grid configuration
• Interactive Report features
• Cards region for dashboards

Module 5: APEX Forms and Validations

• Form page creation
• Item types: Text, select, date, file
• Form validations
• Pre-processing and post-processing
• Automatic Row Fetch and DML

Module 6: Dynamic Actions

• Dynamic action framework
• Show, hide, enable, disable actions
• Execute JavaScript actions
• Execute PL/SQL dynamic actions
• AJAX callbacks

Module 7: APEX Navigation and Security

• Navigation menu configuration
• Breadcrumb and tabs
• Authentication schemes: APEX, LDAP, OAuth
• Authorisation schemes
• Session state protection

Module 8: APEX Reports and Charts

• Classic and interactive reports
• Chart types: Bar, line, pie, Gantt
• Oracle JET charts in APEX
• Map regions with GeoJSON
• Report printing and export

Module 9: RESTful Web Services in APEX

• ORDS (Oracle REST Data Services)
• Creating REST APIs with APEX
• Consuming REST APIs in APEX
• Web Source modules
• REST-enabled SQL

Module 10: APEX for Mobile

• Progressive Web App (PWA) in APEX
• Mobile-first design in Universal Theme
• Push notifications in APEX
• Offline mobile capabilities
• APEX mobile best practices

Module 11: APEX on Oracle Cloud (OCI)

• APEX on Autonomous Database
• APEX Service on OCI
• Deploying APEX apps to OCI
• APEX with OCI Object Storage
• APEX AI features (23.x)

Module 12: Real-Time Projects and Case Studies

• Enterprise APEX application development
• APEX dashboard for business reporting
• End-to-end APEX development project
• Certification and interview preparation

Experience in the Industry Gain knowledge from experts with hands-on Oracle APEX development experience in enterprise low-code application projects.

Backgrounds at the Top Prominent corporations such as HCL, TCS, Infosys, and Oracle Consulting employ our Oracle APEX trainers.

Clear & Effective Teaching Excellent communication and real-world examples simplify complex APEX page development, dynamic actions, and REST API integration.

Hands-On Learning Focus Students apply skills using live Oracle APEX environments with real enterprise application development projects.

Up-to-Date Knowledge Trainers stay current with Oracle APEX 23.x, APEX AI features, OCI deployment, and latest low-code development trends.