Oracle Application Express: Administration



Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Sep 20, 202209:0005:00EDTToronto - In Class or by Video Conference2$2,700 USDPurchase

Oracle Application Express: Administration

Description: In the Oracle Application Express: Administration Ed 2 course, students will learn the different ways in which Oracle Application Express can be installed and will perform a full development environment installation on a multitenant architecture of Oracle Database 12c. They will identify the three options of configuring a web server for Oracle Application Express and will install and configure the Oracle REST Data Services.

Duration: 2 Days

Learn To

  • Install Oracle Application Express.
  • Install and Configure Oracle REST Data Services.
  • Rectify Common Installation Errors.
  • Create and Manage Workspaces and Users.
  • Manage and Monitor An Entire Development Instance.
  • Manage and Monitor Workspaces.

Required Prerequisite

  • Oracle Database 11g: Administration Workshop I Ed 2 (FR)
  • Connaissances des principes fondamentaux de l'administration de base de données


  • Web Administrator
  • Application Developers
  • Security Administrators
  • Database Administrators

Course Objectives

  • Troubleshoot common performance issues
  • Install and configure APEX 5.0
  • Install and configure Oracle REST Data Services
  • Create Workspace, Users and Schemas
  • Configure Instance settings such as Email, Report Printing and Storage
  • Configure Security
  • Configure Features such as Application Development, SQL workshop and Database Monitoring
  • Managing Service Requests for a Workspace
  • Creating Users and Groups
  • Create Workspace announcements, monitor workspace activity and using dashboards
  • Manage Service Requests
  • Manage Session State
  • Export and Import Workspaces
  • Manage Public Themes
  • Monitor Activity in an Entire APEX Instance
  • Using APEX_INSTANCE_ADMIN API procedures and functions


Course Overview

  • Course Objectives
  • Suggested Schedule
  • Course Environment
  • Accessing the labs Directory


  • Product Overview
  • ReviewingTerms and Concepts
  • Performing Database Administration and Linux Review

Installing Oracle Application Express

  • Overview
  • Identifying Pre-installation Tasks
  • Installing Oracle Application Express
    Administering Post Installation Tasks

Installing and Configuring Oracle REST Data Services

  • Installing Oracle REST Data Services
  • Configuring Oracle REST Data Services in Standalone Mode

Creating Workspaces

  • Managing Instance and Workspace Administration
  • Creating Workspaces
  • Creating Users
  • Creating Schemas
  • Managing Existing Workspaces

Configuring Administration Services

  • Configuring Instance Settings
  • Configuring Security Settings
  • Configuring Features

Administering a Workspace

  • Managing Administration Page and Tasks
  • Managing Services
  • Creating Users and Groups
  • Monitoring Activity
  • Using Dashboards

Administering An APEX Instance

  • Managing Service Requests
  • Managing Session State
  • Exporting/Importing Workspaces
  • Managing Public Themes
  • Monitoring Activity
  • Managing Announcements
  • Managing Custom Applications


  • Learning about the APEX_INSTANCE_ADMIN API
  • Managing Workspaces
  • Managing Schemas
  • Managing Parameters

Key APEX Administration Tasks

  • Managing Instance Administrator Tasks
  • Administering DBA Tasks
  • Managing Schemas
  • Troubleshooting


Right Menu IconMENU