Tutorials

Try your hand at completing these Hands on Labs to gain even more knowledge and experience building apps.

Hands On Labs

The following labs provide step-by-step instructions to complete a given scenario, and cover everything from basics to more advanced topics.

  • Build a Social Media App

    Duration: 1 hour
    Intended Audience: Everyone
    Objectives:

    • Learn how to use Quick SQL
    • Learn how to use a Form and a Cards Region including Dialogs
    • Learn to work with BLOBs, Dynamic Actions and Custom Events

    This workshop will give everyone a great exposure to what a developer can do with APEX using Low-Code and relatively simple approaches!

  • Build a Movies Watchlist Application

    Duration: 2 hours
    Intended Audience: Everyone
    Objectives:

    • Learn how to set up REST data sources
    • Learn how to create an application to view data from REST sources
    • Learn how to manage a movie watchlist using local tables

    See how easy it is to join REST Data Sources with local tables to build an app that anyone can use! You and your friends can use the resulting app to search for movies and create personal watchlists.

  • Build a Starter Online Shopping App

    Duration: 2 hours
    Intended Audience: Everyone
    Objectives:

    • Create an APEX application based on a sample dataset
    • Learn how to temporarily manage the shopping cart using APEX Collections
    • Learn how to add pages to manage the shopping cart from scratch

    See just how easily you can build a shopping cart app using the database objects that you created in this tutorial.

  • Spreadsheet Lab

    Duration: 1 hour
    Intended Audience: Novice / No experience
    Objectives:

    • Build your first app through uploading a Spreadsheet
    • Improve the Search and Report pages
    • Link pages

    While all of this sounds daunting you will be amazed at how quickly you went from a spreadsheet to a fully featured, responsive Web app.

  • Build an Expense Tracker App Using Oracle APEX

    Duration: 1 hour
    Intended Audience: Everyone
    Objectives:

    • Learn how to create a Task definition
    • Learn how to create a Unified Task List
    • Learn how to create an Email Template

    You will be amazed to see how quickly you can build an app that manages expenses in your department using the Approvals Component in APEX.

  • Existing Tables Lab

    Duration: 1.5 hours
    Intended Audience: Novice / No experience
    Objectives:

    • Build a first cut of an app based on existing tables
    • Learn how to reload an app and regenerate
    • Learn how to add pages, and link pages
    • Learn how to manipulate regions, and items
    • Learn how to define client-side interactivity declaratively

    See just how quickly and easily you can build impressive apps on top of your existing data.

  • Proof-of-Concept Lab

    Duration: 1 hour
    Intended Audience: Novice / No experience
    Objectives:

    • Define new tables and views
    • Create an application on the new data structures
    • Refine the application

    Who knew creating new database tables could be so easy, and then just as easy to build a great app on top of those tables.

  • REST Data Source Lab

    Duration: 1 hours
    Intended Audience: Beginner
    Objectives:

    • REST enabling tables and views
    • Define REST Data Sources against REST endpoints
    • Build an application utilizing REST Data Sources

    Learn just how easy it is to build Oracle APEX apps utilizing RESTful Services.

  • Remote Data Source Lab

    Duration: 1 hour
    Intended Audience: Intermediate
    Objectives:

    • Define and populate a table from a REST endpoint
    • Create an application on the new data
    • Refine the application

    Learn how to manipulate data using simple SQL and charts to gain new insights.

  • Low Code Development

    Duration: 1 hour
    Intended Audience: Beginner
    Objectives:

    • Create an Autonomous Transaction Processing Instance
    • Access APEX in the Oracle Cloud
    • Create an APEX Workspace
    • Create an application from a file
    • Use Quick SQL to create database objects
    • Use SQL Developer Web to access database objects
    • Use SQL Developer Web to create a data model
    • Create and modify an APEX application

    Learn how to easily satrt building apps using APEX and SQL Developer Web.

  • APEX + Server-Side JavaScript

    Duration: 1 hour
    Intended Audience: Intermediate
    Objectives:

    • Write JavaScript in SQL Commands
    • Extend APEX Applications Using JavaScript in Processes and Validations
    • Use External JavaScript Modules

    Learn how to use JavaScript in the Server-Side of your APEX Applications.

Pre-Built VM

Rather than utilizing apex.oracle.com, another option is to install Oracle VM Virtual Box and install Oracle Database 23c Free - Developer Release VirtualBox Appliance. This option allows you to work on your laptop without needing internet connectivity.

A single download gives developers a free VM with:
  • Oracle Database 23.2 Free - Developer Release for Linux x86-64
  • Oracle Linux 8.7
  • Oracle REST Data Services 23.1
  • Oracle APEX 22.2
  • Oracle SQLcl 23.1