Oracle Apex Training | Learn Oracle Application Express
Oracle APEX Training Syllabus
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
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 – 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.
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.
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.
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.
Page Utilities : you will be getting to know the basic utilities available for the page in Oracle APEX.