This course covers the Oracle APEX Administration essentials for DBAs. You will learn how to install, configure and manage a secure, production-quality APEX environment that supports internal AND public-facing internet applications. Learn how to 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 use of https when connecting to a virtual host.
The current releases of all components are used for exercises and demonstrations.
Prerequisite Knowledge
Extensive knowledge of system administration, database administration, or application development is not needed. However, the nature of APEX Admin is that it crosses over all those domains and so some understanding of them is required.
Technical Requirements
Nothing is required for labs (workshops). SkillBuilders will provide everything you need for all hands-on labs. Modest PC or Mac specs are required to connect to the online class. Detailed specs can be found here.
Also, if possible, we recommend using two monitors for this class. One monitor can be used for viewing the instructor screen, a second can be used for your connection to the lab environment.
Course Features
- Lecture 0
- Quiz 0
- Duration 2 Half Days (~8 hours)
- Skill level All levels
- Language English
- Students 25
- Assessments Yes
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
