Introduction to Oracle APEX Training (APEX101)

Use Oracle Application Express (APEX) to build secure, database-driven web applications faster. If you’re already comfortable with SQL and PL/SQL, this hands-on course will help you move beyond the basics and start building professional APEX applications with confidence.

Working alongside a live expert instructor, you’ll create complete applications while learning how to design intuitive user interfaces, build forms and reports, automate business logic, manage user sessions, and secure your applications. Along the way, you’ll gain practical experience with SQL Workshop, Page Designer, Dynamic Actions, Interactive Reports, authentication and authorization, deployment, and team development tools.

This course emphasizes how the pieces of Oracle APEX work together to create secure, maintainable applications. Through hands-on labs, you’ll practice solving real development challenges and apply best practices that you can immediately use in your own projects.

By the end of the course, you’ll be able to build, customize, secure, and deploy Oracle APEX applications more efficiently using the platform’s low-code development tools.

1. Introduction to APEX
   1. What is Oracle Application Express (APEX)?
   2. History of APEX
   3. Why Use APEX?
   4. Architecture and Components
   5. Main Programming Languages in APEX
   6. User Roles in the APEX Ecosystem
   7. APEX Deployment Options
   8. The APEX Hierarchy
   9. Log in to the APEX Workspace (Exercise)
2. SQL Workshop
   1. Components of SQL Workshop
   2. Query Builder
   3. Selecting Data from a Single Table
   4. Joining Tables
   5. Creating Queries in Query Builder from Graphical Representation (Exercise)
   6. Creating Queries in Query Builder from Report (Exercise)
3. Applications
   1. App Builder Areas
   2. Creating An Application (Exercise)
   3. Options for Creating an Application
   4. Best Practice: Create the Oracle Data Model
4. Pages
   1. Page Designer Overview
   2. Create An About Us Page (Exercise)
   3. Page Designer: Left Pane
   4. Page Designer: Right Pane
   5. Page Designer: Central Pane
   6. Breadcrumbs and Navigation
   7. Understanding Layout
   8. Designing the About Us Page (Exercise)
5. Regions
   1. Working with Regions
   2. Creating Regions on a Page (Exercise)
6. Classic Reports
   1. Classic Reports Overview
   2. Creating A Classic Report (Exercise)
   3. Classic Report Attributes
   4. Alternative for Creating a Classic Report Page
7. Forms
   1. Basic Functionality of a Form
   2. Browsing Records in a Table
   3. Create a Form to Browse Employees (Exercise)
8. Interactive Reports
   1. Features of Interactive Reports
   2. Create Departments Interactive Report (Exercise)
   3. Using Drill Downs (Exercise)
9. Items
   1. The ABCs of Items
   2. Layout Properties
   3. Building a Dynamic Countries Form with APEX Items (Exercise)
   4. Dynamic Department Filtering with APEX Checkboxes (Exercise)
10. Buttons and Sessions
    1. Button Actions
    2. Session State Management
    3. Exploring Session Management and Redirection in APEX (Exercise)
11. Computations
    1. Application Computations vs. Page Computations
    2. Calculate Employee Benefits Contribution
    3. Create a Computation (Exercise)
12. Validations
    1. Validations Overview
    2. The Sequence of Events During Page Submission
    3. Create Validations (Exercise)
13. Processes
    1. Application Processes vs. Page Processes
    2. Page Processes
    3. Creating Insert and Delete Processes (Exercise)
14. Branches
    1. Understanding Branches in Oracle APEX
    2. Create Departments in Country Branch (Exercise)
15. Using Plug-ins
    1. Plug-in Basics
    2. Using a Plug-In (Exercise)
    3. Best Practice: Choose Your Plug-ins Wisely
16. Calendars
    1. APEX Calendar Features
    2. Using a Calendar For Employee Hire Date (Exercise)
17. Dynamic Actions
    1. Types of Dynamic Actions
    2. Creating and Using Dynamic Actions (Exercise)
    3. Adding Check and Uncheck All Buttons (Exercise)
18. Security
    1. Session State Protection
    2. Understanding Authorization Schemes
    3. Hashing
    4. Creating Authentication and Authorization Schemes (Exercise)
    5. Best Practice: Build to be Secure
19. Deployment
    1. What is Deployment?
    2. Deployment Strategies
    3. Exporting and Importing Applications
    4. Exporting and Importing an Application (Exercise)
20. Team Development
    1. Team Development Overview
    2. Creating an Issue in Team Development (Exercise)

Each student receives a comprehensive set of materials, including course notes and all class examples.

Experience in the following is required for this Oracle Application Express (APEX) class:

Experience in the following would be useful for this Oracle Application Express (APEX) class: