Enter your keyword

Oracle APEX Training with AI

Build Oracle APEX apps with AI: from prompt to production

What is Oracle APEX?

Oracle APEX is a low-code platform for building secure, scalable, enterprise-grade web applications directly on the Oracle Database. With its new generative AI capabilities, you can now describe an app in plain English and have APEX build the data model, pages, and logic for you, then add intelligent features like AI assistants and semantic search on top.

Who is this course for?

Citizen developers, web developers, Oracle database/PL-SQL professionals, and Oracle Fusion/OIC consultants who want to build apps faster and add AI to them, with no heavy front-end coding required.

What you’ll learn in this APEX Training?

  • Set up your own Oracle APEX workspace on Oracle Cloud and build your first app from an Excel file in minutes
  • Design applications end to end: pages, forms, reports, charts, Interactive Grids, faceted search and smart filters
  • Create dynamic, interactive user experiences with Dynamic Actions, validations, computations, and navigation
  • Use SQL Workshop and Quick SQL to design and manage database objects quickly
  • Style your apps professionally with Themes, Templates, and Theme Roller
  • Build apps with AI: generate data models and complete applications from plain-English prompts
  • Add AI to your apps: embed AI assistants, generate text, and connect your own data using RAG
  • Go beyond keyword search: implement semantic search with Oracle AI Vector Search
  • Deploy and migrate apps across environments, including one-click remote deployment
  • Build 5 hands-on projects, from a spreadsheet-to-app conversion to an AI Procurement Agent, a GenAI-powered Q&A interface, and an AI-powered Event Management App
  • Get resume and interview preparation support, plus guidance for the Oracle APEX Cloud Developer Professional (1Z0-770) certification

REQUEST TO ENROL




    Training Course Structure

    Course Outline
    • What is Oracle APEX
    • Why Oracle APEX
    • The APEX architecture
    • Use-cases of Oracle APEX
    • On-premises and Oracle Cloud options for Oracle APEX
    • Pre-requisites for Oracle APEX setup and installation
    • Setup Oracle APEX on Oracle Cloud
    • Setup Oracle APEX as a service
    • Provisioning an Oracle APEX workspace
    • How to create workspace users
    • Instance Administration Tasks
    • Overview of APEX pages
    • Types of Oracle APEX applications
    • Understanding of Regions
    • Understanding of Forms, Reports, Charts
    • Understanding of dynamic actions
    • Creation of first application using existing excel files
    • How tables are getting created from the excel files
    • How to add and modify filters
    • App builder Overview
    • Page Designer Overview
    • Getting started and using SQL workshop components
    • How to use SQL commands and SQL scripts
    • Build and save SQL queries using Query Builder
    • Import and export data using Utilities
    • Generate SQL by using quick SQL
    • Start building application pages
    • Exploring page structure and components
    • Understanding of regions
    • Create and modify a region and subregion
    • Add page groups and comments
    • Work with various reports in Oracle APEX
    • Learn how to create various type of reports
    • Create faceted search, cards, and smart filters
    • Create, manipulate and customize interactive reports
    • Create and modify classic and wizard reports
    • Working with Interactive Grids
    • Customize an Interactive Grid as a developer
    • Customize an Interactive Grid as an end-user
    • How to create button and execute events
    • How to work with List of Values
    • How to create dependent List of Values
    • Identify different type of items
    • Create items and edit item attributes
    • Understanding of page rendering and processing
    • Creating and understanding of page computations
    • Creating and understanding of page validations
    • How to create various branches
    • Understanding of Dynamic Actions
    • Working with Dynamic Actions
    • Enabling and disabling components using dynamic actions
    • Filtering and Refreshing the regions
    • Filtering and Refreshing the reports
    • Understanding of Faceted Search
    • Understanding of Smart Search
    • Creating and modifying Faceted Search
    • Creating and modifying Smart Search
    • Working with Cards
    • Working with Navigations
    • Creating different type of Navigations
    • Working with dialog boxes
    • How to navigate from one page to another
    • Working with pagination
    • Understanding of different Themes
    • Understanding of different Templates
    • Managing themes using CSS
    • Understanding theme style and theme roller
    • Create a new theme from the repository and switch to the theme to make current
    • How to consume external REST APIs
    • How to REST data sources
    • REST Data Synchonization

    • How AI is changing low-code development
    • Connecting a Generative AI service to your APEX workspace
    • Generating data models from a plain-English description
    • Creating a working application from an AI prompt
    • Using the AI Assistant inside code editors to write and fix SQL, PL/SQL, and JavaScript

    • Designing intelligent app experiences: what AI can do inside an APEX app
    • Adding the AI Assistant Dynamic Action to any page
    • Generating, summarizing, and rewriting text with AI
    • Creating AI Configurations and connecting RAG Sources so the AI answers from your business data

    • Understanding embeddings and Oracle AI Vector Search
    • Building Retrieval-Augmented Generation (RAG) with AI Vector Search
    • Adding vector-based semantic search to APEX Search Configurations

    • Understanding of Authentication and Authorization
    • Understanding of Authorization scheme
    • Create an authentication scheme for your application
    • Create an authorization scheme using Access Control
    • Implementing security in the APEX application
    • Exporting application from source environment
    • Importing application to target environments
    • Migration of database objects between environments
    • One-click remote deployment

    Project 1: Spreadsheet Conversion Lab
    Turn the Excel files your team already uses into a secure, multi-user web app.

    • Upload a spreadsheet and auto-generate tables and an app from it
    • Add filters, reports, and Interactive Grids for data entry
    • Apply validations and access control

    Project 2: POS (Point of Sale) App
    Build a working retail billing app, from product catalog to checkout.

    • Design the product, customer, and order data model
    • Build cart and billing screens with Dynamic Actions
    • Calculate totals, taxes, and discounts
    • Add sales dashboards and reports

    Project 3: Build an AI Procurement Agent in Oracle APEX
    Create an agent that helps automate the procurement workflow.

    • Model purchase requests, suppliers, and approvals
    • Connect a Generative AI service and configure AI behavior
    • Let the agent assist with requests, supplier queries, and recommendations
    • Integrate with external systems using REST APIs

    Project 4: Build an Innovative Q&A Interface Powered by Generative AI
    Build a chat-style interface that answers questions from your own business data.

    • Set up AI Configurations and RAG Sources
    • Use AI Vector Search to retrieve the most relevant content
    • Design a conversational Q&A experience for end users

    Project 5: Build an AI-Powered Event Management App
    Build a complete event app with AI built in.

    • Manage events, registrations, attendees, and schedules
    • Use AI to generate event descriptions and communications
    • Add smart search and an AI assistant for attendee questions
    • Secure the app with role-based access for organizers and attendees

    Training Schedule

    Training Schedule

    Timings: 9:15 to 11:15 AM IST

    Days: Saturday and Sunday

    Date: 06-Dec-2026

    Duration: 6 weeks

    Mode: Online

    REQUEST TO ENROL