Low code Programming and App Development Using Oracle Database 26ai and Oracle Apex 26.1

Good — APEX 26.1 is a real, recently released version (GA in mid-2026), so this roadmap will be current. Here's what you need to learn:

1. Oracle Database Fundamentals

• RDBMS concepts: tables, keys, relationships, normalization
• Installing Oracle Database (Express Edition/Free) or using Oracle Autonomous Database (cloud, easiest way to get APEX + DB together)
• SQL*Plus / SQL Developer basics

2. SQL

• DDL, DML, DQL — same as before: joins, subqueries, aggregate/string/date functions
• Views, sequences, indexes, constraints
• This is non-negotiable for APEX since almost every region/report is SQL-driven

3. PL/SQL

• Blocks, variables, control structures
• Cursors, procedures, functions, packages
• Triggers, exception handling, collections
• APEX leans heavily on PL/SQL for processes, validations, and dynamic actions

4. Oracle APEX Core Concepts

• Workspace, applications, pages — the basic building blocks
• Page Designer: regions, items, buttons, processes, validations, branches
• Session state and substitution variables (:P1_ITEM, &P1_ITEM.)
• Item types: text fields, select lists, LOVs, popup LOV
• Navigation: lists, breadcrumbs, tabs
• Authentication & Authorization schemes

5. APEX Data Components

• Interactive Reports (IR) vs Interactive Grids (IG) vs Classic Reports
• Forms: automated row fetch/DML forms based on tables
• Master-detail forms
• Charts and Map Regions (now enhanced with vector tile layers in 26.1)
• Cards, Calendars, Trees

6. Dynamic Actions & JavaScript/CSS Basics

• Client-side dynamic actions (show/hide, set value, refresh)
• Basic JavaScript for custom interactivity
• Basic CSS for styling beyond templates

7. Shared Components

• Templates, themes (Universal Theme — now with the new Iris style in 26.1)
• LOVs, lists, breadcrumbs as reusable shared components
• Application items/processes, build options

8. APEX 26.1-Specific New Features (worth learning early since they're the platform's direction)

• APEXlang — the new declarative, human-readable spec language for exporting/versioning apps (Git-friendly, AI-friendly)
• AI Agents & AI Tools — building agents that can query data or run PL/SQL through approved tools
• AI Interactive Reports (NL2IR) — natural language filtering/searching in reports
• Data Reporter — self-service reporting for non-developers
• Trigger Action — new behavior type for buttons/menus tied to dynamic actions
• Declarative row selection in IRs (checkboxes without custom code)

9. Security

• Session state protection
• Authorization schemes, access control
• SQL injection prevention (bind variables)
• New CSP (Content Security Policy) improvements in 26.1

10. Deployment & Admin

• Workspace management
• Exporting/importing apps (Standard Export vs. new APEXlang export)
• ORDS (Oracle REST Data Services) — required for APEX (26.1 needs ORDS 26.1.1+)
• REST Data Sources / Web Services integration

11. Bonus / Future-Proofing

• REST APIs — APEX apps often expose or consume REST services
• Oracle Autonomous Database — simplifies setup since APEX comes pre-installed
• Git integration — increasingly relevant now that APEXlang makes version control practical

Suggested learning order: SQL → PL/SQL → APEX basics (pages, items, session state) → Reports & Forms in APEX → Dynamic Actions/JS → Shared components & security → APEX 26.1 AI features → Deployment/ORDS.

Want me to build you a week-by-week study plan, or suggest a practical project (like a small inventory or HR app) where you'd apply each concept as you learn it?