ORACLE Application Express

Administration Ed 2

2 days training event

6100-3048

Course Outlines - Download PDF

In the Oracle Application Express: Administration Ed 2 course, students will learn to install and configure Oracle Application Express 5.0 and Oracle REST Data Services 3.0

Learn To

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.

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

Audience

  • Security Administrators

  • Web Administrator

  • Web Administrator

  • Application Developers

  • Database 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 Topics

Course Overview

  • Suggested Schedule

  • Course Environment

  • Course Objectives

  • Accessing the labs Directory

Introduction

  • Product Overview

  • Performing Database Administration and Linux Review

  • ReviewingTerms and Concepts



Installing Oracle Application Express

  • Identifying Pre-installation Tasks

  • Administering Post Installation Tasks

  • Overview

  • Installing Oracle Application Express

Installing and Configuring Oracle REST Data Services

  • Installing Oracle REST Data Services

  • Configuring Oracle REST Data Services in Standalone Mode

Creating Workspaces

  • Managing Existing Workspaces

  • Creating Workspaces

  • Creating Schemas

  • Creating Users

  • Managing Instance and Workspace Administration

Configuring Administration Services

  • Configuring Security Settings

  • Configuring Instance Settings

  • Configuring Features

Administering a Workspace

  • Monitoring Activity

  • Managing Administration Page and Tasks

  • Managing Services

  • Creating Users and Groups

  • Using Dashboards

Administering An APEX Instance

  • Managing Announcements

  • Managing Public Themes

  • Managing Custom Applications

  • Managing Service Requests

  • Exporting/Importing Workspaces

  • Monitoring Activity

  • Managing Session State

Using the APEX_INSTANCE_ADMIN API

  • Managing Parameters

  • Learning about the APEX_INSTANCE_ADMIN API

  • Managing Workspaces

  • Managing Schemas

Key APEX Administration Tasks

  • Administering DBA Tasks

  • Troubleshooting

  • Managing Schemas

  • Managing Instance Administrator Tasks

TRAINING LOCATIONS

أماكن ومقرات التدريب حول العالم

Dubai

Dubai

Kuala Lumpur

Kuala Lumpur

Tunis

Tunis

Istanbul

Amman

Amman

Sunny resort beach with palm tree at the coast shore of Red Sea in Sharm el Sheikh, Sinai, Egypt, Asia in summer hot. Bright sunny light

Sharm El Sheikh

Ottawa

Ottawa

Paris

Lagos

Lagos

Harare

Harare

Kampala

Kampala

Casablanca

Casablanca