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.

  • Spreadsheet Lab

    Duration: 1 hour
    Intended Audience: Novice / No experience
    What You Will Learn -

    • Creating an App from a File
    • Updating the Interactive Report
    • Creating a Calendar
     

    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.

    Run on Autonomous Database Run on apex.oracle.com

  • Existing Tables Lab

    Duration: 1.5 hours
    Intended Audience: Novice / No experience
    What You Will Learn -

    • Install a sample dataset
    • Use the Create App Wizard to create an app on existing tables
    • Make several minor improvements to improve the usability of the application
     

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

    Run on Autonomous Database Run on apex.oracle.com

  • Proof-of-Concept Lab

    Duration: 1 hour
    Intended Audience: Novice / No experience
    What You Will Learn -

    • Define new data structures using Quick SQL
    • Run the generated script to create database objects
    • Use the Create App Wizard to create an app on top of your new tables
     

    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.

    Required Files: QuickSQL Shorthand Script

    Run on Autonomous Database Run on apex.oracle.com

  • REST Lab

    Duration: 1.5 hours
    Intended Audience: Beginner
    What You Will Learn -

    • Define REST Services in one schema
    • Create an app in a second workspace
    • Define Web Sources
    • Create a Report and Form based on the REST Services
    • Implement a function using APEX_EXEC
    • Define a List of Values based on a REST Service
     

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

    Run on Autonomous Database Run on apex.oracle.com

  • Remote Tables

    Duration: 1.5 hours
    Intended Audience: Intermediate
    What You Will Learn -

    • Define a table using Quick SQL
    • Populate a table from a REST API
    • Manipulate an Interactive Report
    • Define a chart with three differenet series
    • Define a select list to drive the chart
     

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

    Run on Autonomous Database Run on apex.oracle.com

  • Building a Demo Project Application

    Duration: 3 hours
    Intended Audience: Beginner
    What You Will Learn -

    • How to use the Create Application Wizard
    • How to enhances various types of pages
    • How to add new pages using the Create Page Wizard
     

    Learn how to build a working application for managing projects and tasks using some of the latest features of Oracle APEX. The lab assumes no prior knowledge of Application Express. This lab can also be utilized for migrating your application development from one environment to another, such as from on-premises to the cloud.

    Run on apex.oracle.com

Pre-Built VM

Rather than utilizing apex.oracle.com, another option is to install Oracle VM Virtual Box and install a pre-built VM with everything already installed and ready to go. This option allows you to work on your laptop without needing internet connectivity.

The Database App Development VM includes Oracle Database 19c, Oracle APEX 19.1, SQL Developer 19.1, and Oracle REST Data Services (ORDS) 19.1. Most importantly, a number of the labs are 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 install 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.