Oracle APEX Developer Professional (2025)
The world's most comprehensive Oracle Apex course that will qualify you as a Professional Apex Developer.
Oracle APEX Developer Professional (2025) udemy course free download
The world's most comprehensive Oracle Apex course that will qualify you as a Professional Apex Developer.
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
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
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
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
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
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
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
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
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
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
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
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
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:
Lists
Navigation Menus
Breadcrumbs
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.
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
Creating Maps
Create map using latitude & longitude
Create map using Geometry
Get latitude & longitude Dynamically
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.
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
Calendar Component
Creating Calendars
Editing Calendar Attributes in Property editor
Tree Component
Creating and modifying Tress in APEX
Enabling dragging and dropping of Data
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
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
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
Load | Stress | Regression Testing using JMeter
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
