Oracle Application Express

Hands-On Labs

In order to participate in the Hands-On Labs run at conferences, and so forth, it is preferable to install the pre-built VM.

Installing the Pre-Built VM

The Database App Development VM includes Oracle Database 18.3, Oracle APEX 18.2, SQL Developer 18.3, and Oracle REST Data Services (ORDS) 18.3. Most importantly all of the labs pre-installed and pre-configured.
Follow these steps to install the VM on your laptop:

  • Install Oracle VM Virtual Box
  • Download the latest Database App Development VM
    {Note: This file is approximately 8 GB so will take significant time to download,
    unless you have a strong internet connection}
  • Import the VM into VirtualBox on your machine, which can take up to 20 minutes depending on your machine.
    {Note: To instal the VM requires 21 GB of free disk space}
  • Update the VM Settings to maximize the System > Base Memory and Processor(s).
  • Start the VM.

Downloading just the lab materials

If you can not install the VM, then you will need another environment, such as Oracle Database Express Edition (XE) and Application Express 18.x or later installed onto your laptop.
If there is strong enough internet connectivity, you could also use Oracle's free hosted-service, or Oracle Database Cloud Service.

Below are files that you can download and work from in your own environment, on, or in the Oracle Database Cloud:

Oracle APEX 19.x Labs

  • Beginner's Hands-On Lab

    Learn how to create your first app based on a spreadsheet. Next you improve the report in the app before adding a calendar. For your second app, you first define some data structures and then generate an app based on your new tables. 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. 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.
    Oracle APEX Beginner Hands-On Lab (v19.1) {Required text file}
    Note: This labs will take approximately 1 hour to complete.
  • REST Hands-On Lab

    Learn how to define REST Web Services in one schema and then utilize them as the basis for an application in another schema. Utilizing a second REST Web Service and the APEX_EXEC package learn how to define a List of Values on a REST URI.
    Oracle APEX REST Hands-On Lab (v19.1)
    Note: This labs will take approximately 2 hours to complete.
  • Building a Demo Project Application

    These tutorials demonstrates how to build a working application for managing projects and tasks using some of the latest features of Oracle APEX 18.1. They assume no prior knowledge of Application Express.
    These labs can also be utilized for migrating your application development from one environment to another, such as from on-premises to the cloud.
    Basic Lab (v1.0.3)
    Note: This labs will take approximately 3 hours to complete.
    Advanced Lab ... Coming Soon

Oracle Application Express 5.1 Labs

Oracle Application Express 5.0 Labs