Oracle APEX Low-code Platform Fundamentals - Hands On
- Description
- Curriculum
- FAQ
- Reviews
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!
-
1
IntroductionIn 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.
-
4
Oracle APEX Architecture
In this lecture, you will be getting to know the architecture of Oracle APEX.
-
5
Oracle APEX Structure
In this lecture, you will be getting to know how Oracle APEX is designed for a developer.
-
6
What you should know
In this lecture, you will be informed with prerequisites before proceeding to further lectures in this course.
-
7
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.
-
8
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.
-
9
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.
-
10
Running the Boilerplate Application
In this lecture, you will be getting to know how a newly installed application appears to the end user.
-
11
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.
-
12
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.
-
13
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.
-
14
Interactive Grid - Part 1
In this lecture, you will be getting to know the purpose of Interactive Grid region in Oracle APEX.
-
15
Interactive Grid - Part 2
In this lecture, you will be getting to know the interactive features in Interactive Grid
-
16
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.
-
17
Reports
In this lecture, you will be getting to know the various reports available in Oracle APEX and the benefits of using it.
-
18
Charts
In this lecture, you will be getting to know how to use the chart region and the various charts available in Oracle APEX.
-
19
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.
-
20
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
-
21
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.
-
22
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.
-
23
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.
-
24
Dynamic Actions - Part 2
In this lecture, you will be getting to know the usage of framework and component events under Dynamic Actions.
-
25
Processing points
In this lecture, you will be getting to know a brief overview of the processing points in Oracle APEX.
-
26
Computations
In this lecture, you will be getting to know what, why and how to use computation process in Oracle APEX.
-
27
Validations - Part 1
In this lecture, you will be getting to know the purpose of using validations for forms in Oracle APEX.
-
28
Validations - Part 2
In this lecture, you will be getting to know how to add validations in Interactive Grid process.
-
29
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.
-
30
Navigation
In this lecture, you will be getting to know the usage of Lists under the Navigation section in Shared Components.
-
31
User Interface and Files
In this lecture, you will be getting to know the usage of User Interface and Files section in Shared Components.
-
32
Data Load
In this lecture, you will be getting to know how to use the Data Load feature in Oracle APEX.
-
33
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.
-
34
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.
-
35
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.
-
36
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.
-
37
Form for New Group
In this lecture, we will be creating a new modal page for creating a new group in a form region.
-
38
NoteA short note about the next lecture.
-
39
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.
-
40
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.
-
41
Expense Details Report
In this lecture, we will be creating a new page for displaying the expense details.
-
42
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.
-
43
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.
-
44
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.
-
45
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.
