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 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.

View all Oracle courses

Who is the course for?

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

Course subjects

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
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
Reports
- Classic SQL reports
- Interactive reports components
- Mobile reports
Forms
- Create form wizards
- Form on a table with report
- Master detail forms
- Tabular forms
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
Page-Processing
- Computations
- Page Process use cases
- Validations
Application Validation and Debugging
- Using the Application Advisor
- Enabling and Disabling Debug mode
Shared Components
- Introduction to Shared Components
- Navigational Shared Components
- Lists and Breadcrumbs
- Navigation Bar
Themes and Templates
- Themes fundamentals
- Types of Templates and use cases
- Using Cascading Style Sheets
- Uploading and using images
Application Security Fundamentals
- Authentication Schemes page
- Authorisation methods
- Session State Protection
Application Navigation
- Hierarchical lists
- Database-drive navigation reports
- Building a Site Map
Additional User Interface Elements
- Data load wizard
- Charts
- Calendars
- Trees
Dynamic Actions and Plug-ins
- Dynamic actions use cases
- Plug-in fundamentals
- Plug-in repository usage
- Using plug-ins on a page
Other Features
- Application express printing
- Report queries and layouts
- Team development and application feedback

Prerequisites

Oracle Database SQL course or equivalent SQL knowledge

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.