The Complete Oracle APEX Fundamentals Course 2023

The easiest way to learn Oracle APEX step-by-step from scratch. Rapidly develop a new project with low code.
The Complete Oracle APEX Fundamentals Course 2023
File Size :
2.96 GB
Total length :
6h 51m



Velchandru M


Last update




The Complete Oracle APEX Fundamentals Course 2023

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

The Complete Oracle APEX Fundamentals Course 2023


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!


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!


Section 1: Getting Started

Lecture 1 Introduction

Lecture 2 What is Oracle APEX?

Lecture 3 Why should I use Oracle APEX?

Section 2: Understanding Oracle APEX

Lecture 4 Oracle APEX Architecture

Lecture 5 Oracle APEX Structure

Lecture 6 What you should know

Section 3: Setting up the Workspace

Lecture 7 Requesting a New Workspace

Lecture 8 Oracle APEX 21.1 version

Lecture 9 Installing Sample Database Application

Lecture 10 Creating a New Application

Section 4: Exploring the New Application

Lecture 11 Running the Boilerplate Application

Lecture 12 Creating and Understanding a Page

Lecture 13 Update from Oracle APEX 21.2

Lecture 14 Regions and Page 0

Lecture 15 Buttons and Page Items

Section 5: Regions

Lecture 16 New Update : Attributes tab

Lecture 17 Interactive Grid – Part 1

Lecture 18 Interactive Grid – Part 2

Lecture 19 Forms

Lecture 20 Reports

Lecture 21 Charts

Lecture 22 Other Regions – Part 1

Lecture 23 Other Regions – Part 2

Lecture 24 Page Items – Part 1

Lecture 25 Page Items – Part 2 and Buttons

Section 6: Dynamic Actions

Lecture 26 Dynamic Actions – Part 1

Lecture 27 Dynamic Actions – Part 2

Section 7: Page Processing

Lecture 28 Processing points

Lecture 29 Computations

Lecture 30 Validations – Part 1

Lecture 31 Validations – Part 2

Section 8: Shared Components

Lecture 32 Application Logic and Other Components

Lecture 33 Navigation

Lecture 34 User Interface and Files

Lecture 35 Note about the Next Lecture

Lecture 36 Data Load

Section 9: Security

Lecture 37 Authorization Schemes – Part 1

Lecture 38 Authorization Schemes – Part 2

Lecture 39 Session State Protection and Read Only

Section 10: Project: Expense Splitter

Lecture 40 Groups Overview Report

Lecture 41 Form for New Group

Lecture 42 Note

Lecture 43 Expenses Overview Report

Lecture 44 Form for Adding New Expense

Lecture 45 Expense Details Report

Lecture 46 Members Overview Report and Form for New Member

Lecture 47 Actions for Updating and Deleting an Expense

Lecture 48 Amount Pending Functionality

Lecture 49 Graphical Representation

Section 11: Utilities

Lecture 50 Page Utilities

Section 12: Next Steps

Lecture 51 Bonus Lecture(s)

Lecture 52 Congratulations!

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

Course Information:

Udemy | English | 6h 51m | 2.96 GB
Created by: Velchandru M

You Can See More Courses in the Developer >> Greetings from

New Courses

Scroll to Top