Oracle APEX Developer Professional (2025)

About Oracle APEX Developer Professional (2025)

This is a very comprehensive course, specially designed for students, beginners and professionals. We will start from oracle Apex foundations and move towards advance topics gradually. Course content is 1.

Oracle APEX Overview and Architecture

Describe Oracle Application Express (APEX)

Explain the key features of Oracle Application Express

Describe Oracle Application Express architecture

Oracle APEX Workspaces and Applications

Create Workspace (Local, Cloud and Autonomous Database)

Internal Workspace in Oracle APEX

Multiple Schema Assignment

List and describe the components of Oracle Application Express

Major components of Oracle APEX

Log into Oracle Application Express

Browser as IDE for Oracle APEX development

Install and run a packaged applications 2.

SQL Workshop

Describe SQL Workshop and list its components

What is SQL Workshop?

SQL Scripts

Execute SQL Commands

Creating, Executing, Saving, Importing and Export SQL Scripts between Workspaces

Oracle APEX Utilities

Load CSV,XLSX,XML and JSON data into Database Table

Unload Data into Text or XML

Query Builder Utility - Declarative way

Methods on Tables Utility - Create Package and procedures

Quick SQL Utility to create SQL.

Browse through database objects using the Object Browser

Create and modify database objects

Create a lookup table

Generate DDL statements 3.

Creating Database Applications

Explain App Builder concepts

Describe the types of applications you can build using Application Express

Create database application in Oracle APEX

Edit database application properties

Create applications from JSON,XLSX,XML and text files

List the components of a database application

Determine your application user interface

Create a database application from scratch

Create a database application from a spreadsheet

Create a mobile web application 4.

Oracle APEX Page Designer

Explain application page components

Create an application page and view its definition

Manage pages in page designer

Describe page designer UI elements

Add page components 5.

Developing Reports

List the type of reports that you can create in Apex

Describe the different ways of creating reports in Application Express

Create an interactive report

Create an interactive grid

Create a classic report

Create a report with form 6.

Managing and Customizing Interactive Reports

Describe interactive report components

Searching for information in an interactive report

Searching for information within a specific column

Show or Hide columns in interactive report

Adding a filter in an interactive report

Describe types of filters

Adding column filter and row filter

Selecting column sort order in interactive report

Creating aggregation in interactive report

Adding a computed column

Performing a Flashback query in interactive report

Creating a control break

Adding highlighting a row in interactive report

Creating a group by in interactive report

Specifying a group by Sort order

Saving an Interactive report

Resetting a report

Downloading a reports

Using Column Heading Menu

Customizing an interactive report as a developers

Editing Interactive Report Region Attributes

Modifying an interactive Report Source Query

Editing interactive report attributes

Customizing the search bar

Customizing the Actions Menu

Specifying the download formats

Managing Link Columns

Use and customize an interactive report as an end user

Manage interactive report attributes

Configure the display of interactive report controls as a developer

Column Headers & Linking Columns

Single Row View of Interactive Reports 7.

Managing and Customizing Interactive Grids

Customizing an Interactive Grid as a Developer

Making an interactive Grid Editable

Adding column group headers

Manage interactive grid attributes

Control Interactive Grid Pagination

Create error messages

Configure the Search bar, Action menu, and download options

Control if and how users save the report

Configure supported views.

Customize the Interactive Grid Toolbar

Enable Users to Save Public Interactive Grid

Modifying SQL Source of an Interactive Grid

Customize interactive grid as an end user

Rearranging and Resizing Grid Columns

Changing column display width in interactive grid

Adjusting column display order

Toggling columns button

Creating filter, highlight row or Column

Downloading or Emailing an Interactive grid

Refresh an interactive Grid

Interactive grid Flashback, Reversing an interactive Grid to a Previous State

Classic Reports Overview

Customization of Classic Reports

Using Different Templates for Classic Reports

Using Classic Reports as Cards

Using Classic Reports as Media List

Using Classic Reports as Timeline

Using Classic Reports as Value Attribute Pairs

Classic Report with Download and Printing Options

Faceted Search in Oracle Apex

Design Cards in oracle Apex 8.

Interactive Reports Advance Topics

URL Types in Oracle APEX

Redirect to other pages in APEX

APEX_UTIL.PREPARE_URL Utility

Call Saved Reports & Apply Filters Runtime 9.

Creating and Using Data Forms

Describe an application form in Application Express

Understanding form types

Understanding Item Types

List the different types of application forms that you can create

List the different wizards you use to create forms

Create a form on a table and link a report to a form

Create an editable interactive grid

Creating a master detail form

Different types of master detail forms and reports in APEX

Editing a form using Quick Edit option

Modifying Display Type of a Page Item

Altering Display order of page items 10.

Creating Application Page Items

Identifying different types of Items

Different types of page items

Create and use page level items and edit Item attributes

Create and use application level items

Referencing items values in SQL, PL/SQL and static text

Creating a Quick Pick Selection

Adding Help Text along with Page Items.

What is a List of Values (LOV)? And Types of LOVs

Usage of Select List, Popup LOV, Radio Group, Checkbox and Shuttle component in APEX

Popup LOV with Additional Outputs

Creating a Static and Dynamic LOVs

Creating shared LOVs to use on Multiple pages within application

Associating a Named LOV (Shared Component) with an Item

Creating a Cascading LOV

Create and use buttons

Auto Complete Text Field and Rich Text Editor

Date Picker, Checkboxes and Radio Buttons 11.

Computations, Validations, Processes and Branching

Explain page rendering and page processing

Show page (page rendering) and Accept Page (Page Processing) processes

What is a computation?

Creating a page-rendering computation.

Creating a page-processing Computation.

What is a process?

Create form wizard automatic data manipulation Processes

Automatic Row Fetch Process

Automatic Row Processing process

Create a page level process

Creating on submit process

Create on Load Process

Application Level Process

Page Rendering Process

Understanding Validations

Creating a Validation for a Page Item

Creating a SQL Validation Type

Creating a PL/SQL Validation Type

Creating a Regular Expression Validation Type

Creating a Row Validation in an Interactive Grid

Understanding Branching

Create a branch within an Application 12.

Shared Components & Global Navigations

Describe the use of shared components in an application

Understanding Navigational Shared Components

Create, edit, and use the following shared components that aid navigation in an application: 1. Lists 2. Navigation Menus 3. Breadcrumbs 4. Navigation bar entries

What are Lists?

APEX Support for Lists

What are Static and Dynamic Lists?

Creating Static List.

Adding Entries to a List.

Creating a Dynamic List

Adding a list to a page.

What is a Navigation Menu?

Creating a Navigation Menu Entry.

What is Breadcrumb?

Creating a Breadcrumb.

Adding Breadcrumb Entries.

Adding a Breadcrumb Region in a Page.

What is a Navigation Bar Entry?

Accessing a Navigation bar List.

Creating a Navigation bar List. 13.

Themes and Theme Styles

Describe themes and templates

Types of Themes supported in APEX.

Standard themes and custom themes

Accessing Themes Page in Shared Components

Editing APEX Universal Theme

Creating a new theme from the Repository.

Creating a Copy of an Existing Theme.

Switching an Active Theme

Understanding Universal theme

Using theme Styles

Creating a Theme Style

Enabling Users to select a theme style as per their choice.

Using Theme Roller, Declarative way to style your applications

Understanding Templates and Template Options

Creating Template Options

Using Live Template Options

Using Custom Cascading Style Sheets.

Uploading CSS, JavaScript, icons and images to static files 14.

Creating Maps

Create map using latitude & longitude

Create map using Geometry

Get latitude & longitude Dynamically 15.

Security Implementation

How to secure an APEX application?

How to implement Authentication in APEX?

Custom Authentication Scheme

How to Change Current Authentication Scheme?

Create Global or Application Level Page Items

Show Signed-in Username in Navigation Bar

Database Accounts Authentication Scheme

No Authentication Scheme

Open Door Credentials Authentication Scheme

Application Express Accounts Authentication Scheme

Social Sign-in | OAUTH2 | Google Authenticator

Providing Security through Authorization

Create and attach an authorization scheme to your entire application, page, region & Other components

Creating Access Control Administration Page.

Creating an Authorization Scheme to an Application.

Attaching an Authorization Scheme to a Page.

Attaching an Authorization Scheme to a Control or components.

Enable and configure Session State Protection. 16.

Creating and Using Dynamic Actions & plug-ins

Describe Dynamic Actions

Create and use Dynamic Actions

Understanding Dynamic action Events

Categories of Events

Browser Events

Framework Events

Component Events

Custom Events

Enable & Disable, Hide and Show Page Items

Enable & Disable using javascript

Validation Errors, Add & Remove CSS

Highlight Page Items on Focus

Execute Server Side Code By Dynamic Action

Setting Value of Page Items.

Set Page Item Value Using PL/SQL Function

Filter Data and Refresh Region

Describe, import and use Plug-ins

Implement Plug-ins in your application

Viewing Plug-in Repository

Importing and installing a Plug-in

Viewing a plug-in Definition 17.

Calendar Component

Creating Calendars

Editing Calendar Attributes in Property editor 18.

Tree Component

Creating and modifying Tress in APEX

Enabling dragging and dropping of Data 19.

Migrating Applications, DB Objects & Plugins Between Environments[DEV,QA,UAT,PROD]

Export entire application and its supporting objects

Importing application into target Environment

Migrating database objects – tables, triggers etc.

Migrating data from one application to other

Recreating database objects in target Environment.

Identifying the supporting objects for your application

Migrate Plugins from Dev Environment to Prod Environment 20.

Oracle APEX 23.2 - New Features

Combo box Page Item

Image Upload Page Item

Generate QR Code & Bar Code

Application Working Copies

Integrated Diff

Simple Merge

Workflow

Custom Map Backgrounds 21.

Create and Consume Webservices

Restful Service to Get Employees Data

Report with Pagination using Webservice

Filter Webservice Data, Passing URL Parameters

Webservice to Update Employee Data

Webservice to Delete Employee Data

Webservice to get Documents & Images

Secure Webservices | OAuth 2 22.

Load | Stress | Regression Testing using JMeter

23.

Workflows, Tasks & Automation

Task Definition & Types

Understand task types: Action & Approval

Key attributes: Priority, Participants, Deadline, Potential Owner, Business Administrator, Parameters, Actions

Task Instance Creation

Create Action and Approval Task Instances

Retrieve primary key values

Design Task Details Page

Build page to initiate task instances

Unified Task Lists

My Tasks

Admin Tasks

Initiated by Me

Task Operations & Workflow Integration

Map task operations to events and states

Design Leave Management with Multi-Level Approval

Workflow Fundamentals

Introduction to Workflow

Workflow Parameters, Variables, and Participants (Owner, Business Admin)

Workflow Activities: Start, End, Send Email, Human Task, Switch, Wait, Push Notification

Workflow Versions: Active vs Inactive