Training On Administering Oracle® Application Express

DBCON launches live online training in administration of Oracle Application Express. Starting right from understanding what is Oracle Application Express to installation, up gradation, configuration, monitoring and management - learn all the essential skills to manage Oracle Application Express Instance in the most effective and efficient way.

Course Contents


  • Introduction to Oracle Application Express
    • What is APEX ?
    • Apex Architecture
    • Key Features of APEX
    • Usage of APEX
    • Benefits of APEX
  • Installing Oracle Application Express
    • Installing Oracle Application Express
    • Upgrading Oracle Application Express to the latest version
    • Configuring Oracle Application Express with embedded PL/SQL Gateway
    • Configuring Oracle APEX with HTTP Server
    • Installing APEX in Multiple Languages
    • Installing APEX in runtime mode
  • Workspaces in APEX
    • Concepts of Workspace in APEX
    • Creating/Editing/ Deleting Workspaces
    • Managing Workspace Schema Assignments
    • Creating/Editing/Removing Workspace Administrators/Developers/Users
    • Export / Import Workspace
    • Managing Build Status of Applications
  • Oracle APEX Administration Services
    • Configuring SQL Workshop Options
    • Configure Print Server
    • Review mail log files
    • Adding Themes to Repository
  • Using SQL Developer to administer APEX
  • Configure Security Options
    • Specify workspace password policy
    • Configure IP Filtering
    • Restrict domain access from URL
    • Enable / Disable logins to APEX Workspace
  • Configure E-Mail in Oracle APEX
    • Configure SMTP Server on Linux
    • Configure SMTP Server with Oracle Application Express
  • Oracle APEX Workspace Administration
    • Load/Unload Data from tables
    • Create DDL
    • APEX Views
    • Compare Schema
  • Using APIs to manage APEX
    • APEX_UTIL
    • APEX_INSTANCE_ADMIN
    • APEX_UI_DEFAULT_UPDATE
    • APEX_CUSTOM_AUTH
  • Administrative Reports & Monitoring
    • Monitor Developer's Activity
    • Monitor Users Activity
    • Monitor Application Changes
    • Monitor Workspace Activity
    • Monitor Application & Workspace Logons

Audience


An excellent course to learn and practise all the required skills and knowledge to administer and manage Oracle Application Express Instance in the most effective and efficient way.

Pre-requisites


Following are the suggested pre-requisites for this course.

  • Basic Oracle Database Concepts
  • Basic knowledge of Linux

Lab Environment


For this training, all participants will have their own dedicated linux server (accessible over Internet through secured shell like Putty) where they will practise to install, upgrade, configure, manage & administer Oracle Application Express Instance.

This linux server will be available to you 24 hours a day for the entire duration of your course. The APEX version is 4.0 running on Oracle XE database.