Oracle APEX Training Course Curriculum

Module 1: Introduction to Oracle APEX

What is Oracle APEX?
Introduction to Oracle Autonomous Database
Understand Low Code Application Development
Oracle APEX Availability and Architecture
Oracle APEX Use Cases

Module 2: Oracle APEX Set Up

Provisioning an APEX Workspace
APEX History and Product Components
Oracle APEX Architecture in detail
Previewing out of the box apps given by Oracle
Installing a Sample APEX Application

Module 3: SQL, PL SQL Refresher

Understand SQL Basics
Use SQL Commands and SQL Scripts
Generate SQL by Using Quick SQL
Basics of PL SQL
Build Sample Datasets

Module 4: Build First Application in APEX

App Builder Concepts
App Builder and the Create App Wizard
Application Based on Existing Tables
Create an Application from a File

Module 5: Build Complex Point of Sale APEX App – Part 1

Introduction to Point of Sale App Design
Design and Set up Data Model for POS App
Build complex APEX Application Page to manage Purchasing
Add Administration in PoS App using various APEX Components

Module 6: Build Complex Point of Sale APEX App – Part 2

Build complex APEX Application Page to manage Sales
Build Complex Apex Page to Add and Manage Customers
Build Complex Dashboard Page to Display Stock and Other Details

Module 7: Build Expense Tracker App – Part 1

Introduction to Expense Tracker App Design
Design and Set up Data Model for Expense Tracker App
Build page to add variety of expenses
Build complex page to display transactions
Build Complex APEX Bar Chart to display expenses by Category etc.

Module 8: Build Expense Tracker App – Part 2

Create Faceted Search Reports
Build and manage summary report cards
Manage Smart Filters to display expenses by Month and Year
Build Dashboard to display expense totals and graphs
Build Interactive Reports in APEX

Module 9: Design Complex E-commerce App

Introduction to E-commerce App
Design the app and setup the data model
Introduction to Understanding Security and Authentication

Module 10: Implementing Security in your Application ECommerce App

Understanding and Using Authorization Schemes
Creating and Using Access Control Administration Page
Build Login page with Password Reset and Other login options
Understand user authorization and access control

Module 11: Build Complex E-commerce App – Part 1

Discuss the design for End User and Admin Modules
Load products into E-Commerce App using image and excel upload
Add search page for end user to search for products and add them to cart
Build Check Out Page with address and other details

Module 12: Build Complex E-commerce App – Part 2

Apex Integration with test payment gateway
Design Admin section to manage the E-Commerce App
Admin pages to manage products, users etc.
Manage Interactive Grids as Developer and End User
WhatsApp Integration with APEX App

Module 13: APEX Computations, Processes and Validations – Ecommerce App

Understanding Page Rendering and Page Processing
Manage APEX Computations
Creating and Understanding Page Processes
Build and Manage Validations in APEX
Understand Validations and Branches

Module 14: Creating and Using Dynamic Actions – Ecommerce App

Understanding Dynamic Actions
Enabling and disabling Items using Dynamic Actions
Setting an Item Value using Dynamic Actions
Filtering and Refreshing a Report using Dynamic Actions

Module 15: Build Complex HRMS Solution in APEX

Understand Complex HRMS Solution design
4 Apex Apps required for this solution
Set up required data model
Manage Page Items and Application Items
Create and Manage List of Values
Create and Customize Buttons

Module 16: Build Recruitment App in APEX

Understand Recruitment App Solution design
Set up required data model
Build required pages to raise requisition and track candidates
Build reports to fetch and display selected or rejected candidates
Understand how file upload and print functionality works in APEX

Module 17: Build Employee App in APEX – Part 1

Understand Employee App Solution
Set up required data model and load data
Build required pages to add and manage employees
Create, Edit and Manage Automations

Module 18: Build Employee App in APEX – Part 2

Introducing and Managing Approvals
Creating Master Detail Forms
Understanding and Creating Forms
Understanding Collections

Module 19: Build Employee App in APEX – Part 3

Managing REST Enabled SQL References
Creating and Managing REST Data Sources - Part 1
Creating and Managing REST Data Sources - Part 2
Creating an Editable Interactive Grid

Module 20: Build Attendance App in APEX

Understand Attendance App design
Set up required data model
Build required pages to capture attendance manually
Build reports to fetch and display attendance information by dept
Build page to upload bulk attendance data into app

Module 21: Build Leave Tracker App in APEX

Understand Leave Tracker App design
Build required pages to capture leaves manually
Build reports to fetch and display leave information
Build page to upload bulk leave data into app

Module 22: Build Complex HRMS Apex App

Build Complex HRMS Apex App displaying links to other 4 Apps
Understanding Themes
Understanding Theme Styles and Theme Roller
Understanding Templates
Managing Themes and Using Custom CSS
Creating and Using Lists
Creating and Using Navigation Menu and Navigation Bar List
Sending Emails
Adding Search to an Application
Apex automation
Push notifications
Test the entire HRMS Apex Solution together with all apps

Module 23: Guidance on Certification, Interview and Resume Preparation

We will provide most comprehensive guidance in Oracle APEX Certification
We will share couple of resumes and help you prepare Perfect Oracle APEX resume
We will teach all possible interview questions in Oracle APEX

× Chat with us