About this course

Course code TPD56259GC20
Duration 2 Days

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. 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. Benefits To YouStudents will benefit by learning how to troubleshoot installation issues and review the installation log. Students will be shown how to log into the Oracle Application Express Administration Interface and manage an entire development Instance and they will learn to create users and workspaces and manage and monitor the Oracle Application Express instance. Students will also learn to log into the Oracle Application Express application as a workspace administrator and monitor and manage a Oracle Application Express workspace.Live Virtual Class FormatA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Delegates will learn how to

  • 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

Outline

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

2 Days

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Virtual learning

Recreates a classroom experience online, enabling full interactions with the learning professional leading the course.

Find dates and prices

Sorry, we don't have any public dates scheduled for this course, but it can be run as a closed event for your company.
Please contact us for details on alternative ways we can help you 0845 757 3888 or email us at info@qa.com.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.