4.39 out of 5
4.39
9 reviews on Udemy

Oracle APEX Low-code Platform Fundamentals – Hands On

Dive into the basics of Oracle APEX (20.1) from scratch! Learn how to build a web application with very less code!
Instructor:
Velchandru M
612 students enrolled
English [Auto]
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

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

You only need to have a basic knowledge of SQL and PL/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 in creating 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 be learning 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 in-built security features in Oracle APEX.

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

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

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

Getting Started

1
Introduction

In this lecture, you will be getting to know a brief overview of this course.

2
What is Oracle APEX?

In this lecture, you will be getting to know what is Oracle APEX.

3
Why should I use Oracle APEX?

In this lecture, you will be getting to know why should one use Oracle APEX as a career path.

Understanding Oracle APEX

1
Oracle APEX Architecture

In this lecture, you will be getting to know the architecture of Oracle APEX.

2
Oracle APEX Structure

In this lecture, you will be getting to know how Oracle APEX is designed for a developer.

3
What you should know

In this lecture, you will be informed with prerequisites before proceeding to further lectures in this course.

Setting up the Workspace

1
Requesting a New Workspace

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.

2
Installing Sample Database Application

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.

3
Creating a New Application

In this lecture, you will be getting to know how to create a new application from scratch using the default settings.

Exploring the New Application

1
Running the Boilerplate Application

In this lecture, you will be getting to know how a newly installed application appears to the end user.

2
Creating and Understanding a Page

In this lecture, you will be getting to know the role of a page in an application and the components of page designer.

3
Regions and Page 0

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.

4
Buttons and Page Items

In this lecture, you will be getting to know a brief overview of the components of a region like buttons and page items.

Regions

1
Interactive Grid - Part 1

In this lecture, you will be getting to know the purpose of Interactive Grid region in Oracle APEX.

2
Interactive Grid - Part 2

In this lecture, you will be getting to know the interactive features in Interactive Grid

3
Forms

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.

4
Reports

In this lecture, you will be getting to know the various reports available in Oracle APEX and the benefits of using it.

5
Charts

In this lecture, you will be getting to know how to use the chart region and the various charts available in Oracle APEX.

6
Other Regions - Part 1

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.

7
Other Regions - Part 2

In this lecture, you will be getting to know the usage of region types in Oracle APEX like Faceted Search, Tree and URL

8
Page Items - Part 1

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.

9
Page Items - Part 2 and Buttons

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.

Dynamic Actions

1
Dynamic Actions - Part 1

In this lecture, you will be getting to know what is Dynamic Action in Oracle APEX and the examples of commonly used browser events.

2
Dynamic Actions - Part 2

In this lecture, you will be getting to know the usage of framework and component events under Dynamic Actions.

Page Processing

1
Processing points

In this lecture, you will be getting to know a brief overview of the processing points in Oracle APEX.

2
Computations

In this lecture, you will be getting to know what, why and how to use computation process in Oracle APEX.

3
Validations - Part 1

In this lecture, you will be getting to know the purpose of using validations for forms in Oracle APEX.

4
Validations - Part 2

In this lecture, you will be getting to know how to add validations in Interactive Grid process.

Shared Components

1
Application Logic and Other Components

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.

2
Navigation

In this lecture, you will be getting to know the usage of Lists under the Navigation section in Shared Components.

3
User Interface and Files

In this lecture, you will be getting to know the usage of User Interface and Files section in Shared Components.

4
Data Load

In this lecture, you will be getting to know how to use the Data Load feature in Oracle APEX.

Security

1
Authorization Schemes - Part 1

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.

2
Authorization Schemes - Part 2

In this lecture, you will be getting to know how to use the Authorization Scheme as a package in PL/SQL business logic.

3
Session State Protection and Read Only

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.

Demo Application: Expense Splitter

1
Groups Overview Report

In this lecture, we will be using the home page which displays the groups for the logged-in user in a report region.

2
Form for New Group

In this lecture, we will be creating a new modal page for creating a new group in a form region.

3
Note

A short note about the next lecture.

4
Expenses Overview Report

In this lecture, we will be creating a new page for displaying the expenses based on the group in a report region.

5
Form for Adding New Expense

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.

6
Expense Details Report

In this lecture, we will be creating a new page for displaying the expense details.

7
Members Overview Report and Form for New Member

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.

8
Actions for Updating and Deleting an Expense

In this lecture, we will be adding the actions for updating and deleting an expense in the expense details page.

9
Amount Pending Functionality

In this lecture, we will be creating new page for amount pending functionality that shows the balances of each member within the group.

10
Graphical Representation

In this lecture, we will be creating a new page for representing the data graphically in the form of charts provided by Oracle APEX.

Utilities

1
Page Utilities

In this lecture, you will be getting to know the basic utilities available for the page in Oracle APEX.

Next Steps

1
Congratulations!

All the best and watch the video till the end!

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.4
4.4 out of 5
9 Ratings

Detailed Rating

Stars 5
5
Stars 4
2
Stars 3
2
Stars 2
0
Stars 1
1
c087082ac64587213cdb4a89921ef1af
30-Day Money-Back Guarantee

Includes

7 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion

External Links May Contain Affiliate Links read more

Join our Telegram Channel To Get Latest Notification & Course Updates!
Join Our Telegram For FREE Courses & Canva PremiumJOIN NOW