Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Oracle Application Express APEX 20.1 Administration Training

person icon Uplatz

4.7

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

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Uplatz

English [CC]

category icon Office Productivity,Oracle,

Lectures -7

Duration -2 hours

Lifetime Access

4.7

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

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

Oracle Application Express (APEX) is an important tool that Oracle provides for database and web application development. APEX helps to build web-based applications using SQL and PL/SQL.

Oracle APEX has been adopted by 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

This Oracle APEX Administration course will help the students 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 to 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 for 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.

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.

Goals

  • 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.

Prerequisites

  • Enthusiasm and determination to make your mark on the world!
Oracle Application Express APEX 20.1 Administration Training

Curriculum

Check out the detailed breakdown of what’s inside the course

Overview of Oracle Application Express (APEX) Administration

1 Lectures
  • play icon Overview of Oracle Application Express (APEX) Administration 10:24 10:24

Installation of Windows 10 on Oracle VM

1 Lectures
Tutorialspoint

Installation of Oracle19c and Create Database

1 Lectures
Tutorialspoint

Installation and Configuration of APEX 20.1

1 Lectures
Tutorialspoint

Installation of Tomcat

1 Lectures
Tutorialspoint

ORDS Installation and Configuration

1 Lectures
Tutorialspoint

Oracle APEX Admin Tasks

1 Lectures
Tutorialspoint

Instructor Details

Uplatz

Uplatz

Uplatz is a UK-based leading IT Training provider serving students across the globe. Our uniqueness comes from the fact that we provide online training courses at a fraction of the average cost of these courses in the market.

Within a short span of 6 years, Uplatz has grown massively to become a truly global IT training provider with a wide range of career-oriented courses on cutting-edge technologies and software programming.

Our specialization includes Data Science, Machine Learning, Deep Learning, Data Engineering, AWS, SAP, Oracle, Salesforce, Microsoft Azure, GCP, DevOps, SAS, Python, R, JavaScript, Java, C, C++, Full Stack Web Development, Angular, React, NodeJS, Django, IoT, Cybersecurity, BI & Visualization, Tableau, Power BI, Data warehousing, ETL tools, ServiceNow, Software Testing, RPA, Embedded Engineering, Automotive Engineering, DSP, VHDL, Microcontrollers, Electronics, Computer Hardware Engineering, MATLAB, Digital Marketing, Product Marketing, Finance, Accounting, Tally, and more.

Founded in March 2017, Uplatz has seen a phenomenal rise in the training industry providing training on 300+ self-paced courses and 5000+ tutor-led courses across 180 countries having served 1.5 million students in a period of just a few years.

Uplatz's training courses are highly structured, subject-focused, and job-oriented with strong emphasis on practice and assignments. Our courses are designed and taught by highly skilled and experienced instructors who have strong expertise in varied fields whether it be Cloud Computing, SAP, Oracle, Salesforce, Programming Languages, Web Development, or any other technology and in-demand software.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515