Data Private Public On-Demand

Introduction to Oracle APEX (APEX101)

5 days
OracleOracle Application Express (APEX)

Learn to build, secure, and deploy database-driven web applications with Oracle APEX using SQL Workshop, Page Designer, reports, forms, and dynamic actions.

Talk to a Learning ConsultantRegister for a Public ClassRequest a Private Class

Register or Request Training

Price per student
$2,795.00
Guaranteed to run
Select a date
Please select a class.
Interested in a private class?
  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal
Price per student
$249.75 or 5 vouchers
  • On-Demand 24/7
  • Readings, Video Presentations, Exercises
  • Quizzes to knowledge check
  • Life-Time Access

Course Overview

Learn to build secure, database-driven web applications with Oracle Application Express (APEX). This hands-on course shows developers with SQL and PL/SQL experience how to create professional applications using APEX's low-code development tools.

Explore SQL Workshop, Page Designer, forms, reports, Dynamic Actions, session management, authentication, authorization, deployment, and team development. Through practical exercises, you will learn how APEX components work together to create applications that are functional, secure, and maintainable.

By the end of the course, you will be prepared to build, customize, secure, and deploy Oracle APEX applications with confidence.

Course Benefits

  • Explain Oracle APEX architecture, components, roles, and deployment options.
  • Use SQL Workshop and Query Builder to access and work with application data.
  • Create applications and design pages with Page Designer.
  • Build forms, classic reports, interactive reports, calendars, and reusable page regions.
  • Use items, buttons, computations, validations, processes, and branches to implement application behavior.
  • Enhance user experiences with Dynamic Actions, drill-down reports, filtering, and plug-ins.
  • Manage session state, authentication, authorization, and session state protection.
  • Export, import, and deploy APEX applications.
  • Use Team Development tools to support application collaboration and issue tracking.

Delivery Methods

Public Class
Live expert-led online training from anywhere. Guaranteed to run .
Private Class
Delivered for your team at your site or online.
On-Demand
Learn at your own pace with 24/7 access.

Course Outline

  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 a Graphical Representation (Exercise)
    6. Creating Queries in Query Builder from a 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. Creating 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 Method for Creating a Classic Report Page
  7. Forms
    1. Basic Functionality of a Form
    2. Browsing Records in a Table
    3. Creating a Form to Browse Employees (Exercise)
  8. Interactive Reports
    1. Features of Interactive Reports
    2. Creating a 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. Creating 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. Calculating Employee Benefits Contributions
    3. Creating a Computation (Exercise)
  12. Validations
    1. Validations Overview
    2. Sequence of Events During Page Submission
    3. Creating 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. Creating a Departments-in-Country Branch (Exercise)
  15. Using Plug-ins
    1. Plug-in Basics
    2. Using a Plug-in (Exercise)
    3. Best Practice: Choose Plug-ins Wisely
  16. Calendars
    1. APEX Calendar Features
    2. Using a Calendar for Employee Hire Dates (Exercise)
  17. Dynamic Actions
    1. Types of Dynamic Actions
    2. Creating and Using Dynamic Actions (Exercise)
    3. Adding Check All 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 Securely
  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)

Class Materials

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

Class Prerequisites

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

  • Working knowledge of SQL
  • Working knowledge of PL/SQL

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

  • Some web development experience, including familiarity with HTML, CSS, JavaScript, or jQuery

Prerequisite Courses

Courses that can help you meet these prerequisites:

Follow-on Courses

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant