Oracle Application Express APEX 20.1 Administration Training

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.