Oracle APEX Essentials (23-24) Training in Auckland

Oracle APEX Essentials (23-24) Training in Auckland, New Zealand

This course focuses on APEX 23.x–24.x features, covering application development, UI components, database integration, security, and deployment best practices.

Enroll Now

Oracle APEX Essentials (23-24) Training is a professional training program delivered by ProgNXT in Auckland, New Zealand. ProgNXT, a globally recognized corporate training provider in 55+ countries, offers this Oracle APEX Essentials (23-24) Training course with hands-on, instructor-led sessions. The Oracle APEX Essentials (23–24) Training introduces participants to Oracle Application Express (APEX), Oracle’s low-code platform for building...

Expert Panel

Designed and delivered by the ProgNXT Database Management Expert Panel — a vetted team of industry professionals with 15+ years of hands-on experience in MySQL, PostgreSQL, Oracle, and database optimization

ProgNXT Database Management Expert Panel

Course Code: YMS38
14 Hrs
Last Updated: April 2026

Course Rating5/5

The Oracle APEX Essentials (23–24) Training introduces participants to Oracle Application Express (APEX), Oracle’s low-code platform for building secure, scalable, and data-driven web applications. This course focuses on APEX 23.x–24.x features, covering application development, UI components, database integration, security, and deployment best practices with hands-on labs.

Welcome to the official Oracle APEX Essentials (23-24) Training certification program in Auckland, New Zealand. This comprehensive training is designed to elevate your professional skills and provide you with practical, industry-relevant knowledge locally. As a globally recognized corporate training provider operating in 55+ countries, ProgNXT ensures that our curriculum meets the highest standards of excellence.

Whether you are looking to upskill your team or advance your personal career, our expert-led sessions will guide you through the core concepts of this domain. Upon successful completion of the 14 Hrs program, participants will receive a globally accepted certification, demonstrating their proficiency and readiness to tackle complex challenges in the field.

Basic understanding of SQL and relational databases
Familiarity with web applications is helpful
Prior Oracle Database exposure is beneficial but not mandatory
No prior APEX experience required

By the end of this training, participants will be able to:

Build complete web applications using Oracle APEX
Work with pages, regions, items, and navigation
Create reports, charts, and dashboards
Implement authentication, authorization, and security
Use dynamic actions for interactive applications
Deploy and manage APEX applications effectively

Oracle APEX application development
SQL & PL/SQL integration with APEX
UI/UX design using Universal Theme
Interactive reports and dashboards
Security and access control
Application deployment and lifecycle management

APEX architecture and components
Page and region configuration
Reports, forms, and interactivity
Security and access control
SQL & PL/SQL usage in APEX
Application deployment concepts

Participants who attend all sessions and successfully complete the course assessments will receive a ProgNXT Certificate of Completion.

Introduction to Oracle APEX (23–24)

What is Oracle APEX and low-code development
APEX architecture and components
What’s new in APEX 23.x / 24.x
APEX use cases and success stories

APEX Development Environment

APEX workspace overview
Application Builder, SQL Workshop, Team Development
Database objects and schemas
Connecting to Oracle Database

Creating Your First APEX Application

Application creation wizard
Page types and templates
Navigation menus and breadcrumbs
Running and testing applications

Pages, Regions & Items

Page Designer overview
Regions, items, and buttons
Layouts and grids
Validations and computations

Reports & Forms

Classic vs Interactive Reports
Interactive Grids
Forms on tables and views
Data manipulation using APEX components

Charts, Dashboards & Visualizations

Charts using APEX charting engine
KPIs and dashboards
Dynamic filtering and drill-downs
Data visualization best practice

Dynamic Actions & Interactivity

Client-side logic without JavaScript
Events, actions, and conditions
Partial page refreshes
Improving user experience

Themes, UI & UX Customization

Universal Theme overview
Templates and styling
Responsive design principles
Branding and accessibility basics

Security in Oracle APEX

Authentication schemes
Authorization and access control
Session management
Protecting data and pages
Security best practices in APEX

SQL & PL/SQL in APEX

Using SQL queries in regions
PL/SQL processes and functions
Error handling
Performance considerations

Application Deployment & Lifecycle

Application export and import
Versioning and backups
Managing environments (Dev/Test/Prod)
Monitoring and debugging applications

Hands-on Exercises

Summary and Conclusion

Participants will receive course materials, slides, reference materials, exercises and access to resources for further learning.

Participants will be evaluated based on: Daily quizzes, mock questions and query resolution. Group Discussion and Case Study Discussion. Assessment will be through hands-on labs, quizzes, and hands-on exercises.

ProgNXT Certificate of Completion will be awarded to participants who complete the course and pass the evaluations.

Oracle APEX Essentials (23-24) Training Events in auckland

Online Events

Global Region	Location	Start Date	End Date	Action
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌

More Upcoming Session Dates

October 2026

🌐 Online Instructor-Led

26th Oct 2026→27th Oct 2026

📍 Auckland, New Zealand

27th Oct 2026→28th Oct 2026

November 2026

🌐 Online Instructor-Led

8th Nov 2026→9th Nov 2026

📍 Auckland, New Zealand

10th Nov 2026→11th Nov 2026

🌐 Online Instructor-Led

20th Nov 2026→21st Nov 2026

📍 Auckland, New Zealand

28th Nov 2026→29th Nov 2026

December 2026

🌐 Online Instructor-Led

5th Dec 2026→6th Dec 2026

📍 Auckland, New Zealand

7th Dec 2026→8th Dec 2026

🌐 Online Instructor-Led

21st Dec 2026→22nd Dec 2026

📍 Auckland, New Zealand

22nd Dec 2026→23rd Dec 2026

Events for other courses in Auckland, New Zealand

Global Region	Course Name	Start Date	End Date	Action
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌

Oracle APEX Essentials (23-24) Training in Auckland