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.
-
Building 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. -
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. -
Introduction to JavaScript for APEX Developers
Duration: 1 hour
Intended Audience: Intermediate
Objectives:- Javascript Basics
- Adding Javascript to APEX applications
- Working with jQuery and the DOM
Learn how to your APEX apps to the next level by incorporating JavaScript. -
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.
Archived Tutorials
Looking for tutorials for previous releases of Oracle APEX? You can access all of our archived tutorials here.
View Archived TutorialsPre-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.