Oracle APEX Administration Training Overview
This Oracle APEX Administration training course teaches attendees how to install, configure, and manage a secure, production-quality APEX environment that supports internal and public internet applications.
Location and Pricing
This course is taught as a private, live online class for teams of 3 or more. All our courses are hands-on, instructor-led, and tailored to fit your group’s goals and needs. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for online corporate training, please contact us.
In addition, we offer some courses as live, instructor-led online classes for individuals.
Objectives
- Install and configure APEX, ORDS, Tomcat, and Apache
- Create, backup, and restore workspaces and applications
- Enable secure connections to external services
- Install a digital certificate and enforce the use of https when connecting to a virtual host
Prerequisites
Prior Oracle SQL experience is helpful, as is prior web server administration experience. Prior APEX experience is not presumed.
Outline
Expand All | Collapse All
Architecture
- Describe the web application processing model
- Differentiate the middle tier services
- Understand the purpose of the ORDS listener
- Compare the various web tier options
- Summarize the APEX structures: the instance, workspaces, applications
Install APEX
- Install the APEX code into the database
- Configure the database schemas
- Enable network services
- Consider options: full or runtime install, additional language support
Configure ORDS
- Describe Oracle REST Services
- Configure ORDS as an HTTP listener with a database access descriptor
- Install the Tomcat servlet container
- Deploy ORDS to Tomcat
- Consider alternative deployment models
The Apache Web Listener
- Understand the role of a reverse proxy
- Consider firewall requirements
- Compile and install the Apache http server
- Deploy images to the Apache server
- Route requests to Tomcat
- Create virtual hosts
- Configure for scalability and performance
Basic APEX Administration
- Connect to the INTERNAL workspace
- Configure the APEX instance
- Create user workspaces
- Manage applications
- Export and import components
- Monitor activity
Additional Administration Tasks
- Manage access to remote network services
- Understand the job system
- Upgrade and patching
- Configure inbound and outbound traffic over SSL
- Create and use a digital certificate wallet
- Set up access to email and print servers
- Understand how to backup and restore an APEX environment
Conclusion
Training Materials
All Oracle APEX training students receive comprehensive courseware.
Software Requirements
- Oracle Application Express 5, 2018, or later
- Each student computer will need a web browser and Oracle SQL Developer installed
- Please contact us for detailed setup instructions if you have purchased this class
