Oracle Application Express: Administration

Description: 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.

Duration: 2 Days

Learn To

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

Required Prerequisite

• Oracle Database 11g: Administration Workshop I Ed 2 (FR)
  
• Connaissances des principes fondamentaux de l'administration de base de données

Audience

• Web Administrator
  
• Application Developers
  
• Security 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

Topics

Course Overview

• Course Objectives
  
• Suggested Schedule
  
• Course Environment
  
• Accessing the labs Directory

Introduction

• Product Overview
  
• ReviewingTerms and Concepts
  
• Performing Database Administration and Linux Review

Installing Oracle Application Express

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

Installing and Configuring Oracle REST Data Services

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

Creating Workspaces

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

Configuring Administration Services

• Configuring Instance Settings
  
• Configuring Security Settings
  
• Configuring Features

Administering a Workspace

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

Administering An APEX Instance

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

Using the APEX_INSTANCE_ADMIN API

• Learning about the APEX_INSTANCE_ADMIN API
  
• Managing Workspaces
  
• Managing Schemas
  
• Managing Parameters

Key APEX Administration Tasks

• Managing Instance Administrator Tasks
  
• Administering DBA Tasks
  
• Managing Schemas
  
• Troubleshooting