This tutorial video and article is meant to help you setup your APEX installation so you can proceed through the Advanced Tutorials. It covers creation of a new workspace for the tutorials, as well as installation of the OEHR sample data needed for the tutorials themselves.

High Level Steps

Preliminary reading and video tutorials:
APEX Software Download - All OS’s
APEX Installation Tutorial

1. Extract OEHR sample data file. (0:55)
2. Navigate to and login to APEX Admin (1:41)
3. Create workspace and user in APEX (3:47)
4. Install OEHR Sample data (6:01 )
5. Verify data was loaded properly. (8:42)

Times in parenthesis are approximate start time for that step in the video

Notes and Resources

The creation of a new user and workspace is covered in more detail in the getting started and 2 day administrators guides. the importing of the OEHR is actually covered in section 1 of the Advanced tutorials.

The documentation and Tutorials (base and advanced) are available here: Tutorial and Documentation

The OEHR Sample data is one of many packaged applications and samples availible for APEX. The OEHR sample data is available here.

Many smaller aspects of navigating the APEX interface and various screens are not covered here. There will be an overview video of these in the near future. All of these screens and interfaces are covered in the formal documentation.

Related Information:

1. Oracle APEX Advanced Tutorial 1 - Creating a Tabular Form - Video Walkthrough

   This tutorial is designed to walk you through section 2 of the Oracle APEX Advanced Tutorial, Creating a Tabular Form....

2. Oracle APEX Tutorial 3 - Drilldown Report Part 1- Video Training

   This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a drilldown report...

3. Oracle APEX Tutorial 3 - Drilldown Report Part 2- Video Training

   This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a Drilldown Report...

4. Install Oracle Apex 3.2 on XE and XP Pro - Video Walkthrough Tutorial

   This tutorial is a supplment to the install video linked to below. It takes you through the process of installing...

5. Oracle APEX Tutorial 8 - Up and Downloading Files - Part 1 - Video Training

   Reports and data entry constitue the bulk of what most of these tutorials cover, and what many businesses need. However,...

6. Oracle APEX Tutorial 2 - Parameterized Report Part 1 - Video Training

   This Tutorial is a guided walkthrough of section 3 of the Oracle APEX Advanced Tutorials....

7. Oracle APEX Tutorial 4 – Form Layout – Part 2 – Video Training

   APEX gives you a lot of power and flexibility with it's built in wizards. They are very good at creating...

8. Oracle APEX Video Training Tutorials - Complete List

   A few kind readers asked, so we have delivered. Below is a consolidated list of all of the APEX training...