Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

The Complete Oracle APEX Fundamentals Course (2026)

Name: The Complete Oracle APEX Fundamentals Course (2026)
Rating: 4.3 (3011 reviews)

The easiest way to learn Oracle APEX step-by-step from scratch. Rapidly develop a new project with low code.

Created byVelchandru M

Last updated 6/2026

English

What you'll learn

The course provides the entire toolbox you need to become an Oracle APEX developer
Impress interviewers by showing an understanding of the complete Oracle APEX platform
Unfold the power of low code platform
Learn how to build a new web application from scratch
Start coding in SQL and learn how to use it for displaying the data graphically
Understand the Interactive features in Interactive Grid Region for a better representation of the data
Learn how to pre-process and post-process the data
Warm up your fingers as you will be eager to apply everything you have learned here to more and more real-life business cases

Course content

12 sections • 52 lectures • 6h 51m total length

Introduction1:49
In this lecture, you will be getting to know a brief overview of this course.
What is Oracle APEX?2:00
In this lecture, you will be getting to know what is Oracle APEX.
Why should I use Oracle APEX?2:23
In this lecture, you will be getting to know why should one use Oracle APEX as a career path.

Requesting a New Workspace1:55
In this lecture, you will be getting to know the Oracle APEX official website and requesting a new workspace in that platform for the course to follow.
Oracle APEX 21.1 version0:41
Installing Sample Database Application3:42
In this lecture, you will be getting to know the brief idea of how an empty workspace looks at the beginning and then learning to install a sample/productivity application for the course to follow.
Creating a New Application3:41
In this lecture, you will be getting to know how to create a new application from scratch using the default settings.

Running the Boilerplate Application2:55
In this lecture, you will be getting to know how a newly installed application appears to the end user.
Creating and Understanding a Page7:22
In this lecture, you will be getting to know the role of a page in an application and the components of page designer.
Update from Oracle APEX 21.22:56
Regions and Page 06:44
In this lecture, you will be getting to know what is a region in a page and the importance of page 0 in an application.
Buttons and Page Items7:40
In this lecture, you will be getting to know a brief overview of the components of a region like buttons and page items.

New Update : Attributes tab0:09
Interactive Grid - Part 18:42
In this lecture, you will be getting to know the purpose of Interactive Grid region in Oracle APEX.
Interactive Grid - Part 211:01
In this lecture, you will be getting to know the interactive features in Interactive Grid
Forms11:42
In this lecture, you will be getting to know the structure of form region in Oracle APEX and the form submission with respect to DML operations.
Reports9:56
In this lecture, you will be getting to know the various reports available in Oracle APEX and the benefits of using it.
Charts7:25
In this lecture, you will be getting to know how to use the chart region and the various charts available in Oracle APEX.
Other Regions - Part 113:43
In this lecture, you will be getting to know the usage of other region types in Oracle APEX like Calendar, PL/SQL Dynamic Content and Region Display Selector.
Other Regions - Part 212:04
In this lecture, you will be getting to know the usage of region types in Oracle APEX like Faceted Search, Tree and URL
Page Items - Part 117:18
In this lecture, you will be getting to know the page items in Oracle APEX which supports free inputs and the difference of setting values at the session and at the source and default section.
Page Items - Part 2 and Buttons15:21
In this lecture, you will be getting to know the page items which supports specific inputs and the basic actions of buttons in Oracle APEX.

Processing points6:37
In this lecture, you will be getting to know a brief overview of the processing points in Oracle APEX.
Computations5:05
In this lecture, you will be getting to know what, why and how to use computation process in Oracle APEX.
Validations - Part 16:35
In this lecture, you will be getting to know the purpose of using validations for forms in Oracle APEX.
Validations - Part 27:29
In this lecture, you will be getting to know how to add validations in Interactive Grid process.

Application Logic and Other Components11:29
In this lecture, you will be getting to know what is shared component and its usage in Application logic section and as well as in the Other Components section like List of Values, plugins, etc.
Navigation7:43
In this lecture, you will be getting to know the usage of Lists under the Navigation section in Shared Components.
User Interface and Files10:00
In this lecture, you will be getting to know the usage of User Interface and Files section in Shared Components.
Note about the Next Lecture0:20
Data Load12:23
In this lecture, you will be getting to know how to use the Data Load feature in Oracle APEX.

Authorization Schemes - Part 18:57
In this lecture, you will be getting to know how to use the Authorization Scheme for each component in Page Designer, which can be found under Security section in Shared Components.
Authorization Schemes - Part 26:06
In this lecture, you will be getting to know how to use the Authorization Scheme as a package in PL/SQL business logic.
Session State Protection and Read Only9:00
In this lecture, you will be getting to know how to use the in-built feature of Security done by Oracle APEX for the page items at the Session level and at the Read Only conditions.

Groups Overview Report11:06
In this lecture, we will be using the home page which displays the groups for the logged-in user in a report region.
Form for New Group14:34
In this lecture, we will be creating a new modal page for creating a new group in a form region.
Note0:09
A short note about the next lecture.
Expenses Overview Report9:06
In this lecture, we will be creating a new page for displaying the expenses based on the group in a report region.
Form for Adding New Expense16:52
In this lecture, we will be creating a new page for adding new expense to the group which will be represented in a form region.
Expense Details Report12:42
In this lecture, we will be creating a new page for displaying the expense details.
Members Overview Report and Form for New Member15:26
In this lecture, we will be creating one page for displaying the members of the group in a report region and another modal page for adding members to the group.
Actions for Updating and Deleting an Expense18:38
In this lecture, we will be adding the actions for updating and deleting an expense in the expense details page.
Amount Pending Functionality21:20
In this lecture, we will be creating new page for amount pending functionality that shows the balances of each member within the group.
Graphical Representation13:06
In this lecture, we will be creating a new page for representing the data graphically in the form of charts provided by Oracle APEX.

Requirements

A standard web browser like Google Chrome / Mozilla Firefox / Opera / Edge / Safari
Basic knowledge of SQL
You don't need to be a SQL to succeed in this course!

Description

This course gives you the complete fundamentals of the Oracle APEX platform.

You only need to have a basic knowledge of SQL.

Starting from setting up the workspace, this course will give a brief overview of how the Oracle APEX architecture is designed and learn the art of using the low code platform to enter into a zone of rapid development of web applications.

You will be learning how to build an application from scratch. This course also helps create new blank pages and decorate them with the components provided by Oracle APEX.

You will be able to understand how to create a new region like Interactive Grid, Forms, and various kinds of reports for a page. This includes other page rendering components like buttons and page items as well.

You will learn how to create Dynamic Actions and the necessity of using validations and computations in page processing.

Also, this course covers the shared components section to get a brief idea of how to implement and make use of it.

More importantly, you will be learning how to secure your page by understanding the built-in security features in Oracle APEX.

Finally, we will be creating a real-time web application that takes advantage of a low code platform to design and develop a quick graphical interface for the end user.

You need not worry about designing your web page as Oracle APEX page designer greatly helps you with its layout and component view system.

By the end of this course, you will be able to build web applications with ease!

Who this course is for:

Business Users who wants to create web applications from a spreadsheet
Developers who have knowledge in Oracle Database
Anyone who is having basic SQL knowledge can directly jump here

The Complete Oracle APEX Fundamentals Course (2026)

What you'll learn

Explore related topics

Course content

Getting Started3 lectures • 6min

Understanding Oracle APEX3 lectures • 4min

Setting up the Workspace4 lectures • 10min

Exploring the New Application5 lectures • 28min

Regions10 lectures • 1hr 47min

Dynamic Actions2 lectures • 24min

Page Processing4 lectures • 26min

Shared Components5 lectures • 42min

Security3 lectures • 24min

Project: Expense Splitter10 lectures • 2hr 13min

Requirements

Description

Who this course is for: