Oracle Application Express APEX 20.1 Administration Training

Learn the installation and configuration of Oracle APEX 20.1 with complete mastery over APEX Administration & Management


   Office Productivity, Oracle, Oracle APEX

Language - English Published on 12/2021


A warm welcome to the Oracle APEX Administration course by Uplatz.

Oracle Application Express (APEX) is an important tool provided by Oracle for Database and web application development. APEX helps to build web based applications using SQL and PL/SQL.

Oracle APEX has been adopted by the businesses across the world and is recognized for the value of keeping costs down and simplifying technical solutions to deliver business requirements. In other words, by using APEX you can develop complex systems at up to 1/4 of the time it takes for an equivalent Java deployment – with no loss of functionality. It’s stable, it scales, and it’s secure while exploiting all the features of the Oracle Database.

APEX is a great solution to consolidate spreadsheets, improve data quality and security, reduce duplication and administration and enhance functionality. Oracle Application Express is fantastic for creating beautiful rich user interfaces with support for all major browsers rendering well on a range of devices.

What is Oracle APEX Administration?

Oracle Application Express administration involves managing an entire Oracle Application Express instance. So, an Oracle APEX administrator is a superuser who manages the entire hosted instance using the Oracle Application Express Administration Services application. Oracle Application Express administrators use the Manage Service page to configure service for an Oracle APEX environment.

Oracle Application Express Admin Features

APEX has an administrative interface to perform many of the system functions and remove the tedium from entering the corresponding PL/SQL procedure calls. The main administration menu for APEX has four major areas, service management workspace management, application management and the important activity monitor.

The key pages under Oracle Application Express Administration Services include:

  • Instance Administration Home Page - It is the starting point for managing an entire Oracle Application Express instance

  • Manage Instance Page - It is used to configure an Oracle Application Express instance

  • Manage Workspaces Page - It is used to manage workspaces for an Oracle Application Express instance

Uplatz offers this comprehensive course on Oracle APEX Administration.

This Oracle APEX Administration course will help the students to learn how to log into the Application Express application as a workspace administrator and administer an Oracle Application Express workspace.

The Oracle APEX Admin course will enable the database and system administrators succeed in managing Oracle Application Express (APEX) environments. The primary focus is to build capabilities for creating the right combination of scalability, high-availability, backup and recovery, integrity, and resource control in the Oracle Application Express environment.

In this course, the students will learn the different ways in which Oracle APEX can be installed and will perform a full development environment installation on a multitenant architecture of Oracle Database 12c. You will also be able to identify the three options of configuring a web server for Oracle Application Express and will install and configure the Oracle REST Data Services.

Course Objectives

  • Manage Workspaces and Users

  • Build Administration Services

  • Set up Oracle APEX listener with WebLogic Server

  • Confirm installation requirements

  • Install Full Development Environment

  • Examine An Entire Development Instance

  • Examine Workspaces

  • Set up Application Express

  • Administrative tasks on APEX

Oracle APEX Administration - Course Syllabus

  • Overview of Oracle Application Express (APEX) Administration

  • Installation of Windows 10 on Oracle Virtual Box

  • Installation of Oracle 19c Database and Create Database

  • Installation of Oracle APEX 20.1

  • Installation of Tomcat

  • Installation of ORDS

  • Oracle APEX Admin Tasks

Who this course is for:

  • Oracle Application Express Administrators
  • Oracle Apex Developers & Support Analysts
  • System Administrators
  • Database & Web Administrators
  • Newbies and Beginners aspiring for a career in System & Database Administration
  • Oracle Apex Engineers
  • Anyone interested in end-to-end management of Oracle Application Express instances
  • Application Developers
  • Oracle Consultants & Analysts
  • Technical Architects & Engineering Managers
  • IT Consultants & IT System Managers

What Will I Get ?

  • Installation, Configuration, Administration & Management of Oracle APEX entire server instance

  • Installation of Windows 10 on Oracle Virtual Box

  • Installation of Oracle 19c Database and Create Database

  • Installation of Oracle APEX 20.1

  • Installation of Tomcat

  • Installation of ORDS

  • Oracle APEX Admin Tasks

  • Instance Administration Home Page, Manage Instance Page, Manage Workspaces Page

  • Understanding Workspace Administration

  • Monitoring Activity Within a Workspace

  • Using the Manage Service Page

  • Making a Service Request

  • Configuring Workspace Preferences

  • Defining a Workspace Message

  • Managing Users in a Workspace

  • Purging the Developer Activity and Click Count Log Files

  • Managing Session State for a Workspace

  • Managing User Preferences

  • Managing Page and Region Caching

  • Changing Build Status for Multiple Applications

  • Viewing Workspace Dashboards


  • Enthusiasm and determination to make your mark on the world!

    Feedbacks (0)

  • No Feedbacks Posted Yet..!

We make use of cookies to improve our user experience. By using this website, you agree with our Cookies Policy.