Oracle APEX Administration
Duration: 1 Day

John Watson

 5/5 (1)
$1,200.00

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.

  • Call 1-401-783-6172 for Group or Alumni Discounts.
    If you are a student of an accredited academic institution call us for a 25% discount.

    • No Events Scheduled at this time. Call +1-401-783-6172 or email us to schedule this class.
    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
    John Watson
    https://skillbuilders.com/our_team/john-watson/
     5/5

    I was able to get a helpful roadmap for troubleshooting slow-running queries as well as some information on the database admin side that I usually don\'t directly deal with.

    It seemed like our class was mainly filled with people on the development side of things rather than database admins, so it may make sense to cater to that and focus more of the class towards the developer side.

    The software worked well for me.
    Brandon Finn
    October 22, 2019
    $1,200.00

    You May Like

    Copyright © Skillbuilders.com