Oracle Apex Training | Learn Oracle Application Express

Oracle APEX Training Syllabus

GETTING STARTED

Introduction
What is Oracle APEX?
Why should I use Oracle APEX?

UNDERSTANDING ORACLE APEX

Oracle APEX Architecture
Oracle APEX Structure
What you should know

SETTING UP THE WORKSPACE

Requesting a New Workspace
Oracle APEX 21.1 Version
Installing Sample Database Application
Creating a New Application

EXPLORING THE NEW APPLICATION

Running the Boilerplate Application
Creating and Understanding a Page
Regions and Page 0
Buttons and Page Items

REGIONS

Interactive Grid- Part 1
Interactive Grid – Part 2
Forms : know the structure of form region in Oracle APEX and the form submission with respect to DML operations.
Reports : know the various reports available in Oracle APEX and the benefits of using it.
Charts : know how to use the chart region and the various charts available in Oracle APEX.
Other Regions – Part 1 : know the usage of other region types in Oracle APEX like Calendar, PL/SQL Dynamic Content and Region Display Selector.
Other Regions – Part 2 : know the usage of region types in Oracle APEX like Faceted Search, Tree and URL
Page Items – Part 1 : 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 Buttons : know the page items which supports specific inputs and the basic actions of buttons in Oracle APEX.

DYNAMIC ACTIONS

Dynamic Actions – Part 1 : know what is Dynamic Action in Oracle APEX and the examples of commonly used browser events.
Dynamic Actions – Part 2 : know the usage of framework and component events under Dynamic Actions.

PAGE PROCESSING

Processing Points : know a brief overview of the processing points in Oracle APEX.
Computations : know what, why and how to use computation process in Oracle APEX.
Validations – Part 1 : know the purpose of using validations for forms in Oracle APEX.
Validations – Part 2 : know how to add validations in Interactive Grid process.

SHARED COMPONENTS

Application Logic and Other Components : 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.
Navigation : know the usage of Lists under the Navigation section in Shared Components.
User Interface and Files : know the usage of User Interface and Files section in Shared Components.
Data Load : know how to use the Data Load feature in Oracle APEX.

SECURITY

Authorization Schemes – Part 1 : 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 2 : know how to use the Authorization Scheme as a package in PL/SQL business logic.
Session State Protection and Read Only : 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.

PROJECT : EXPENSE SPLITTER

Groups Overview Report : we will be using the home page which displays the groups for the logged-in user in a report region.
Form for New Group : In this lecture, we will be creating a new modal page for creating a new group in a form region.
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.
Form for Adding New Expense : we will be creating a new page for adding new expense to the group which will be represented in a form region.
Expense Details Report : we will be creating a new page for displaying the expense details.
Members Overview Report and Form for New Member : 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 Expense : we will be adding the actions for updating and deleting an expense in the expense details page.
Amount Pending Functionality : we will be creating new page for amount pending functionality that shows the balances of each member within the group.
Graphical Representation : we will be creating a new page for representing the data graphically in the form of charts provided by Oracle APEX.

UTILITIES

Page Utilities : you will be getting to know the basic utilities available for the page in Oracle APEX.