Oracle APEX Version 5.0.4

Course:  ORAPEX
Duration:  5 Days
Level:  II
Course Summary

This course provides a complete, hands-on introduction to Oracle APEX 5.0.4, Oracles premier Rapid Application Development tool. With this revolutionary tool, developers can quickly and efficiently create highly complex web-based applications that will run on any operating system environment including smart phones. Interactive reports can be created that allow for full customization including:

  • Searching and sorting
  • Creating control break reports
  • Performing highlighting to focus on specific rows or values
  • Adding custom computations including aggregations
  • Charting and custom dashboards

In this class, students will actually build a fully functioning application from the ground up.

« Hide The Details
Topics Covered In This Course


Chapter 1 Introduction To APEX


Life Without Oracle Application Express

A Summary of APEXs History

Controlling the History Of APEX

APEX Instance Options

Choosing A Web Browser


  • Copy and Paste In SQL*Plus
  • Launching SQL*Plus From The Command Prompt

SQL Developer

  • Running Queries
  • Using Query Builder
  • Exploring And Manipulating Objects
  • Running Scripts


Chapter 2 APEX Installation


The Database

Downloading APEX

Staging the Installation Files

Removing the Preinstalled Version Of APEX

Running the Main APEX Installation Script

APEX Admin Account Setup

Configuring Restful Services

Configuring the Embedded PL/SQL Gateway

Miscellaneous Tasks

Enabling Network Services

Logging In As Admin And Creating A Workspace

Setting Up Email

Creating A Workspace Based on An Existing Schema

Objects Created in A New Or Existing Schema


Chapter 3 Overview of The APEX Workspace


Workspace Anatomy

  • The  Parse As  Schema

Roles for APEX Users

  • Instance Administrators
  • Workspace Administrators
  • Developers
  • End Users

Anatomy of An Application

  • Applications
  • Pages
  • Regions
  • Items

Relationships Between Workspaces, Applications and Database Schemas

  • Associating Multiple Schemas with An Application

Overview of APEX Modules

The APEX Home Page

The Application Builder Drop-Down and Page

  • Create Application
  • Import
  • Export
  • Dashboard
  • Workspace Utilities
  • Application Migrations

The SQL Workshop Drop-Down and Page

  • The Object Browser
  • The Table Link
  • The Data Link
  • The Indexes Link
  • The Model Link
  • The Constraints Link
  • The Grants Link
  • The Statistics Link
  • The UI Defaults Link
  • The Triggers Link
  • The Dependencies Link
  • The SQL Link
  • SQL Commands
  • SQL Scripts
  • Utilities
  • Query Builder
  • Data Workshop
  • Generate DDL
  • Methods On Tables
  • User Interface Defaults
  • Schema Comparison
  • Object Reports
  • Recycle Bin

The Team Development Drop-Down And Page

The Packaged Apps Drop-Down And Page

The Administration Drop-Down And Page


Chapter 4 Our Real World Problem


The Problem and Solution Requirements

Needed Database Objects

  • The Team Table
  • The Work Orders Table
  • The WO_Details Table

Designing For APEX

Primary Key Considerations With APEX


Schemas for Database Objects


Chapter 5 Initial Object Design


Overview of Our Process

Creating Our Application Objects

  • The Team Table
  • The Work_Orders Table
  • The WO_Details Table

The Table and Column Comments

Additional PL/SQL Objects and Modifications Needed

Documenting Your Application


Chapter 6 Object Design II


Loading Data into Our Tables

Creating Lookup Tables

Loading and Running Scripts

User Interface Defaults

  • Defining Table Dictionary Defaults


Chapter 7 Creating & Navigating Apps


Using the Create Application Wizard

  • Packaged / Sample Applications

Understanding Websheet Applications

Creating Applications from Spreadsheets

  • Highlighting
  • Control Break Reports
  • Inserting New Records
  • Updating Records
  • Deleting Records

Creating Applications from The Ground Up

  • Naming Applications
  • Adding A Page
  • Shared Components
  • Application Attributes

Understanding Page Designer

  • The Toolbar
  • The Tree Pane
  • The Central Pane
  • Property Editor
  • Resizing Components Of Page Designer
  • Gallery Pane

Building Our Home Page

Using Public Pages

Using Navigation Bar Entries

Using Global Pages

Using Breadcrumb Regions

  • Breadcrumb Entries

Using Lists

Generating and Using Lists Of Values

  • Static LOVs
  • Dynamic LOVs

Release / Screen Reader

  • Customizing Release Information
  • The Screen Reader Mode Link


Chapter 8 Basic Forms and Reports


Building A Form On A Table

Modifying A Form On A Table

Looking Behind The Curtain

Creating A Form On A Procedure

Modifying A Form On A Procedure

Creating Master-Detail Reports And Forms

Modifying Master-Detail Reports


Using Session State

  • Inspecting Available Session State Variables
  • A Valuable Button

Using APEX Items

  • The Benefits of Bind Variables
  • Using Built ?In Items

URL Syntax

Copying Web Pages

Creating Searchable Reports

  • Modifying Our Report
  • The Need For Reset Pagination
  • Highlighting Your Search Term

Deleting Pages

Modifying Form Design

  • Changing Display Order
  • A Few Additional Tweaks


Using Declarative BLOBs


Chapter 9 Advanced Forms and Reports


Creating Tabular Forms

Modifying Tabular Forms

  • Creating A Button That Links to A Page

Interactive Reports

  • Creating Interactive Reports
  • Running The Interactive Report
  • The Finder Drop-Down
  • Select Columns
  • Filter
  • Rows Per Page
  • Format
  • Sort
  • Control Break
  • Highlight
  • Compute
  • Aggregate
  • Save Report
  • Chart
  • Group By
  • Pivot
  • Flashback
  • Building A New Summary Report

Restricting Interactive Functionality

  • For Each Report

The Column Heading Menu

User Help for Interactive Reports

Subscribing to Reports

Downloading Interactive Reports

Modifying the Edit Link for Interactive Reports

Creating Calendars

  • Creating the Lease Expires Calendar
  • Adding Supplemental Information To Calendar Entries

Creating Charts

  • SQL For Charts
  • Chart Creation

The  Lost Updates  Issue


Chapter 10 Programmatic Components


Using Conditions

Using Required Values

Using Validations

  • Item-Level Validations
  • Page-Level Validation
  • Validations For Tabular Forms

Creating Computations

  • Understanding Execution Timing
  • Computation Types
  • Creating Computations

Creating Processes

  • Using A Process
  • Undocumented Feature Report
  • Adding Columns To Tables Mid-Stream

Using PL/SQL Regions

Using Dynamic SQL


Chapter 11 Dynamic Actions


Understanding Dynamic Actions

Implementing Dynamic Actions

  • Dynamic Actions Based on Page-Level Events

Using Multiple Triggering Elements

Using PL/SQL For Dynamic Actions

Using JavaScript For Dynamic Actions


Chapter 12 APEX Security


Integrating User Security into Your Application

Creating Needed Database Objects

Who Do You Think You Are?

Security Model Implementation


Custom Authentication

Switching Authentication Schemes

Database Authentication

Conditional Security

Controlling Access


Using Read-Only Items

Securing Data

Protecting Session State


Chapter 13 Mobile Applications


A Fresh Look at Mobile Applications

Less Is More???

Creating the Mobile Application

The Fifty-Cent Tour of Mobile Applications

  • Which Wizard?

Back to Building Pinnacle Mobile

  • Wiring Up the Custom Authentication
  • Trigger Modification
  • Building The Home Page
  • Building The Submit A Work Order Page
  • Copying Pages From Other Applications


Chapter 14 Websheets


Introduction to Websheet

The Structure of A Websheet

Navigating Websheets

  • Navigating Content
  • Structural Navigation

Websheet Help

Markup Syntax

Authenticating Users

User Authorization

Sections in Websheets

  • Text Sections
  • Navigation Sections
  • Data Sections
  • Chart Sections

Using Annotations

The Administration Drop-Down

Exporting A Websheet

Importing A Websheet

Deleting A Websheet


Chapter 15 Creating A Websheet Application


Creating the Database Objects

Websheet Creation and Configuration

Creating Websheet Content

  • Data Grid Constraints
  • Alternative Default Reports
  • SQL Tags

Websheet Access Controls


Chapter 16 Bundling and Deployment


Application Component Identification

  • New Applications
  • Existing Applications
  • Using APEX-Based Files
  • Application Export
  • Exporting A Websheet

Including Supporting Objects

Importing an Application


Chapter 17 Additional Developer Tools


Understanding Page Locks

Application Groups

Page Groups

The APEX Data Dictionary

APEX Searches in Applications

Monitoring APEX Applications


APEX Plug-Ins

The APEX Advisor

APEX Build Options

  • Creating the Build Option
  • Applying The Build Option

Using Page-Specific Utilities

Using SQL Developer With APEX


Using Theme Roller


Chapter 18 Workspace Management


The APEX Administration Interface

Service Management

Workspace Preferences

Editing Announcements

Metadata Management

  • Developer Activity and Click Count Logs
  • Click Count Logs
  • Session State
  • Application Cache
  • Websheet Database Objects
  • Application Build Status
  • File Utilization
  • Interactive Report Settings

User / Group Management

  • User Groups

Monitoring Activity


Utilization Report

Deleting Applications


Chapter 19 APEX Team Development


Architectural Overview

The Team Development Interface

  • The Team Development Home Page


  • History Button
  • Progress Log Button


  • Milestones Page
  • By Owner
  • Features By Milestone

To-Do Items



Team Development Utilities

  • Manage Links
  • Manage News
  • Team Development Settings
  • Release Summary

Available User Roles

What You Can Expect

In this class, students will actually build a fully functioning application from the ground up. In fact, they will create:

  • A desktop application with interactive reports
  • A mobile application with data entry and review capability
  • A multiple page website (websheet) with an interactive database interface
Who Should Take This Course

This course is appropriate for any database user wanting to explore rapid application development. That would include end users, business analysts, application developers, database administrators and IT management.

Recommended Prerequisites

Students attending this course should have:

  • Completed our five day Oracle  12c SQL course or have equivalent experience
  • Completed our five day Oracle  12c PL/SQL course or have equivalent experience
Training Style

Instructor Led

Lecture and Hands on Labs

« Hide The Details
Related Courses
Code Course Title Duration Level
Oracle18c SQL
5 Days
Oracle 11g/12c: Express Introduction to SQL and SQL*Plus
3 Days
Oracle 11g/12c Express Introduction to SQL, SQL*Plus, and PL/SQL
3 Days
Oracle 11g/12c Developer: Introduction to PL/SQL
2 Days
Oracle 11g/12c Essentials: SQL, SQL*Plus and PL/SQL
5 Days
Oracle 11g/12c Developer: PL/SQL Complete
5 Days
Oracle 11g/12c Developer: Intermediate PL/SQL
3 Days
Oracle 11g Advanced PL/SQL
3 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]