Data, Analytics & AI Category Banner Image

Oracle Application Express: Developing Web Applications (OCAE)

  • Length 5 days
  • Price  NZD 4500 exc GST
Course overview
View dates &
book now

Why study this course

Oracle Application Express: Developing Web Applications is a hands-on course where you can start creating low-code, scalable, and secure enterprise applications.

We explore the basics of using Oracle® Application Express (APEX), user interface building, look and feel customisation, and application deployment. This course provides a solid foundation in using the platform to build database-driven applications.

Request Course Information

What you’ll learn

After completing this course, students should be able to:

  • APEX Service instance creation and workspace provisioning

  • Cloud applications development in APEX

  • Create and manage Oracle database objects using SQL Workshop

  • Create reports, forms, and pages in web applications

  • Application security principles

  • Application deployment

Oracle corporate PNG logo

Oracle at Lumify Work

Oracle offers a complete enterprise cloud designed to modernise your business, including cloud applications and cloud infrastructure services. Lumify Work offers courses in Oracle Database and web app development so you can utilise the world's leading converged, multimodel database management system in the cloud.

Who is the course for?

Anyone seeking to learn low-code application development using Oracle Application Express.

Course subjects

  1. Oracle Application Express Introduction

    • Oracle Application Express definition and use cases

    • Application types

    • High-level architecture

    • Workspace fundamentals

    • SQL Workshop

    • Application Builder

    • Exporting and importing applications

  2. Database Applications Building Blocks

    • Application Builder home page

    • Database Application user interface types

    • Page Designer

    • Create Application Wizard

    • Desktop Database Application fundamentals

    • Mobile user interfaces

  3. Reports

    • Classic SQL reports

    • Interactive reports components

    • Mobile reports

  4. Forms

    • Create form wizards

    • Form on a table with report

    • Master detail forms

    • Tabular forms

  5. Pages and Regions

    • Page modes: Normal, Modal, and Nonmodal

    • Page Designer UI elements

    • Page regions

    • Conditional display

    • Region display selector

    • Global pages

    • Mobile pages

    • Items and buttons

  6. Page-Processing

    • Computations

    • Page Process use cases

    • Validations

  7. Application Validation and Debugging

    • Using the Application Advisor

    • Enabling and Disabling Debug mode

  8. Shared Components

    • Introduction to Shared Components

    • Navigational Shared Components

    • Lists and Breadcrumbs

    • Navigation Bar

  9. Themes and Templates

    • Themes fundamentals

    • Types of Templates and use cases

    • Using Cascading Style Sheets

    • Uploading and using images

  10. Application Security Fundamentals

    • Authentication Schemes page

    • Authorisation methods

    • Session State Protection

  11. Application Navigation

    • Hierarchical lists

    • Database-drive navigation reports

    • Building a Site Map

  12. Additional User Interface Elements

    • Data load wizard

    • Charts

    • Calendars

    • Trees

  13. Dynamic Actions and Plug-ins

    • Dynamic actions use cases

    • Plug-in fundamentals

    • Plug-in repository usage

    • Using plug-ins on a page

  14. Other Features

    • Application express printing

    • Report queries and layouts

    • Team development and application feedback


Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.