Build enterprise apps 20x faster with 100x less code.
Oracle APEX provides you with all the tools you need to build apps in a single, extensible platform, which runs as a part of Oracle Database. Discover the benefits Oracle APEX has to offer and how you can start building superior apps today.
Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You won’t need to be an expert in a vast array of technologies to deliver sophisticated solutions. Focus on solving the problem and let APEX take care of the rest.
Overview
This OAE-W1: Oracle Application Express Workshop I training teaches you how to quickly and efficiently develop database-centric web applications using Oracle Application Express. Explore implementing security in your applications, managing application navigation, basic validation and debugging techniques used while developing an application in Oracle Application Express.
Learn To:
- Create database applications for both desktop and mobile interfaces.
- Add various components like new pages, reports regions, items and other components required to enhance an application.
- Create processes, validations, computations and dynamic actions within an application.
- Change the look and feel of your web applications using built-in themes and templates.
- Create and use shared components for an application.
- Understand managing and using session state variables.
- Implement security in an application.
- Manage application navigation using shared components.
- Improvise your application by creating calendars, charts and trees.
- Extend your application by adding advanced features like printing, BLOB object, data loading, site and more.
- Enable feedback mechanisms from the application and tracking the feedback from Oracle APEX.
Skills Covered
- Create Pages and Regions in an Application
- Log in to an Oracle Application Express Workspace
- Create Page and Application Items and Buttons
- Create Page Processes and Validations
- Implement Security
- Manage Application Navigation
- Extend an Application
- Create Themes and Templates
- Create Shared Components such as Tabs, Lists, and Breadcrumbs
- Add Dynamic Actions
- Import and Use Plug-Ins
- Create and Use Calendars and Trees
- Utilize Application Express Printing methods
- Manage Application feedback
- Create Reports and Forms in an application
- Create and Run Database Applications using desktop and mobile interfaces
Prerequisites
- Basic knowledge of SQL, PL/SQL, and HTML
Suggested Prerequisites:
Target Audience
- Application Developers
- Database Administrators
- System Analysts
- Project Manager
- Forms Developer
- Business Intelligence Developer
- Web Administrator
Module 1: Course Overview
- Course Goals
- Course Outline
- Order Management Database Application (OMDA)
- Introducing Course Persona: Jack
- Course Environment: Products Installed
- Course Environment: Workspace Details
- Accessing the Labs Directory
Module 2: Introducing Oracle Application Express
- Application Express Overview
- Application Express Terms and Concepts
- Using Application Express
Module 3: Creating a Desktop and Mobile Database Application
- Application Builder Overview
- Introducing Database Applications
- Creating Database Applications
- Creating Mobile Application
Module 4: Working with Reports for Desktop Application
- Creating Reports for a Mobile Application
- Creating Column Toggle Report
- Creating a Reflow Report
Module 5: Creating Forms
- Using Forms
- Creating Forms
- Modifying Forms
- Creating a Form in a Mobile Application
Module 6: Working with Pages and Regions
- Introducing Page Definition
- Working with Page Regions
- Working with Pages
Module 7: Adding Items and Buttons
- Introducing Items
- Using Items
- Creating List of Value (LOV) Type of Items
- Using Buttons
Module 8: Understanding Session State
- Understanding Session State in Oracle Application Express
- Using Session State in Oracle Application Express
Module 9: Including Page Processing
- Introducing Page Processing
- Including Computations
- Including Processes
- Including Validations
- Including Branches
Module 10: Validating and Debugging Your Application
- Using the Advisor
- Managing Your Attribute Dictionary
- Debugging Your Application
Module 11: Adding Shared Components That Aid Navigation
- Introducing Shared Components
- Creating Tabs
- Creating Lists
- Creating Breadcrumbs
- Creating a Navigational Bar
Module 12: Working with Themes, Templates and Files
- Using Themes
- Using Templates
- Using Files
Module 13: Implementing Security
- Securing an Application
- Using Authentication Schemes
- Using Authorization Schemes
- Using Session State Protection
Module 14: Managing Application Navigation
- Building a Hierarchical List with Images
- Building a Site Map
- Enforcing Authorization on Your Site Map
- Linking Interactive Reports using a Declarative Filter
Module 15: Extending Your Application
- Creating Data Load Wizard Pages
- Creating an Upload and Download Page
- Adding BLOB Data to an Existing Application
- Sending Email from an Application
Module 16: Creating and Editing Charts
- Creating and Using Charts
- Enhanced Charting Examples
Module 17: Adding Calendars and Trees
- Using Calendars
- Using Trees
Module 18: Using Dynamic Actions and Plug-Ins
- Using Dynamic Actions
- Using Plug-Ins
Module 19: Utilizing Application Express Printing
- Printing a Standard Report with Derived Output
- Creating a PDF Report with Multiple Queries
Module 20: Managing Application Feedback
- What is Team Development?
- Managing Feedback
Dates & Locations
June 22, 2026 - June 26, 2026
June 22, 2026 - June 26, 2026
September 21, 2026 - September 25, 2026
September 21, 2026 - September 25, 2026
December 14, 2026 - December 18, 2026
December 14, 2026 - December 18, 2026
Exam & Certification
This course is not associated with any Certification.
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
