Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
---|---|---|---|---|---|---|---|
Sep 20, 2022 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 2 | $2,700 USD | Purchase |
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