Oracle APEX (Application Express) Training

Live Online & Classroom Enterprise Training

Oracle APEX (Application Express) is a low-code development platform that enables developers to build scalable, secure, and enterprise-ready web and mobile applications using only a web browser. It leverages Oracle Database capabilities to rapidly create data-driven applications with minimal coding.

Looking for a private batch ?

REQUEST A CALLBACK

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Oracle APEX (Application Express) Course about?

This course provides a comprehensive introduction to Oracle APEX architecture, development environment, and application-building capabilities. Learners will explore how to design, develop, deploy, and manage database-centric applications using APEX components such as forms, reports, dashboards, and workflows. The training also covers security, performance optimization, and integration with other Oracle services.

What are the objectives of Oracle APEX (Application Express) Course ?

Understand Oracle APEX architecture and core components
Build data-driven web applications using APEX tools
Implement authentication, authorization, and security best practices
Design responsive UI using APEX themes and templates
Deploy and manage applications in Oracle Cloud or on-premise environments

Who is Oracle APEX (Application Express) Course for?

Database Developers
PL/SQL Developers
Web Application Developers
Oracle Cloud Developers
Technical Consultants working on Oracle platforms

What are the prerequisites for Oracle APEX (Application Express) Course?

Prerequisites:

Basic SQL knowledge
Basic database concepts understanding
Familiarity with web technologies (HTML, CSS – basic level)
Understanding of relational database design
Basic programming logic knowledge

Learning Path:

Introduction to Oracle APEX and Environment Setup
Database Objects and Data Modeling in APEX
Application Development (Forms, Reports, Dashboards)
Security, Authentication, and Authorization
Deployment, Performance Tuning, and Integration

Related Courses:

Oracle SQL and PL/SQL Fundamentals
Oracle Database Administration Fundamentals
Oracle Cloud Infrastructure (OCI) Foundations
Oracle Visual Builder or Low-Code Development Platforms

Available Training Modes

Live Online Training

2 Days

Course Outline Expand All

Expand All

Module 1: Introduction to Oracle APEX

Overview of Oracle APEX platform

Low-code development concepts

APEX architecture overview

Use cases for rapid application development

APEX vs traditional development approaches

Module 2: Oracle APEX Set Up

Installing and accessing Oracle APEX

Workspace creation and configuration

Database schema setup

Developer environment configuration

Connecting APEX to Oracle Database

Module 3: SQL, PL/SQL Refresher

SQL query fundamentals

Joins, views, and indexes

PL/SQL blocks and procedures

Exception handling

Performance optimization basics

Module 4: Build First Application in APEX

Creating first APEX application

Page types and navigation basics

Forms and reports creation

Basic validations

Running and testing applications

Module 5: Build Complex Point of Sale (POS) APEX App

POS data model design

Product and inventory management screens

Billing and transaction processing

Payment workflow logic

POS reporting dashboards

Module 6: Build Expense Tracker App

Expense data model creation

Expense entry forms and workflows

Approval workflow implementation

Reporting and dashboards

User-based expense tracking

Module 7: Design Complex E-Commerce App

E-commerce data architecture

Product catalog management

Shopping cart functionality

Order management workflows

Customer account management

Module 8: Implementing Security in E-Commerce Application

Authentication and authorization

Role-based access control

Data security best practices

Session management

Preventing common web vulnerabilities

Module 9: APEX Computations, Processes and Validations – E-Commerce

Computations and derived values

Process automation logic

Server-side validations

Transaction processing workflows

Debugging process logic

Module 10: Creating and Using Dynamic Actions – E-Commerce

Dynamic action fundamentals

Client-side event handling

Conditional UI behavior

AJAX-based updates

Performance optimization

Module 11: Build Complex HRMS Solution in APEX

HRMS architecture design

Employee master data management

Payroll and HR workflows overview

HR reporting dashboards

Integration with external HR tools

Module 12: Build Recruitment App in APEX

Candidate data management

Job posting management

Interview workflow automation

Recruitment analytics

Offer and onboarding workflow

Module 13: Build Employee App in APEX

Employee self-service portal

Profile and document management

Employee request workflows

Employee dashboard creation

Notification and alerts

Module 14: Build Attendance App in APEX

Attendance tracking data model

Check-in and check-out workflows

Attendance reporting

Integration with biometric or external systems

Attendance analytics

Module 15: Build Leave Tracker App in APEX

Leave policy configuration

Leave request and approval workflows

Leave balance tracking

Manager dashboards

Notifications and reminders

Module 16: Build Complex HRMS APEX Application (Final Integration Project)

Integrating HR modules into single system

Cross-module workflows

ole-based dashboards

Performance optimization

Deployment and production readiness

Who is the instructor for this training?

The trainer for this Oracle APEX (Application Express) Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree