Oracle Application Express: Administration Ed 2

Course code

OAEA2ed

Duration

2 Days, 16 Acad. Hours

Download pdf

Course Overview

Objectives

Prerequisites

Course Outline

Course Overview

Course overview

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.

Objectives

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 Topics

Prerequisites

Required Prerequisite

Oracle Database 12c: Administration Workshop Ed 2
Oracle Application Express Workshop I Ed 2

Audience

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

Course Outline

Course Topics

1. Course Overview

Suggested Schedule
Course Environment
Course Objectives
Accessing the labs Directory

2. Introduction

Product Overview
Performing Database Administration and Linux Review
ReviewingTerms and Concepts

3. Installing Oracle Application Express

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

4. Installing and Configuring Oracle REST Data Services

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

5. Creating Workspaces

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

6. Configuring Administration Services

Configuring Security Settings
Configuring Instance Settings
Configuring Features

7. Administering a Workspace

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

8. Administering An APEX Instance

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

9. Using the APEX_INSTANCE_ADMIN API

Managing Parameters
Learning about the APEX_INSTANCE_ADMIN API
Managing Workspaces
Managing Schemas

10. Key APEX Administration Tasks

Administering DBA Tasks
Troubleshooting
Managing Schemas
Managing Instance Administrator Tasks

Back to trainings (Oracle)

Request the training

Oracle Application Express: Administration Ed 2

Course code:

OAEA2ed

Duration:

2 Days, 16 Acad. Hours

Apply

Download pdf