Oracle APEX: Foundations

Course details

Oracle APEX is one of the most popular low-code application development platforms for enterprise applications, allowing you to write applications faster and with less code. In this course, get started with low-code application development using Oracle APEX, learning from a product manager on the Oracle APEX product development team. This course shows you how to: create an APEX Service instance; provision an APEX workspace; build cloud applications using APEX on OCI; create and manage database objects using SQL Workshop; manage your application security; and more. If you’re looking to build scalable, secure enterprise apps with world-class features that can be deployed anywhere, check out this course.

Concepts

Getting Started with Oracle APEX

Low-code application development
Oracle APEX introduction
Availability and architecture
Use cases
Provisioning an APEX workspace
Product components
Installing a sample application

Using SQL Workshop

Getting started and using SQL Workshop components
Use SQL commands and SQL scripts
Sample datasets
Generate SQL using Quick SQL

Creating a Database Application

App Builder concepts
Access and use App Builder
Database application based on existing tables
Create an application from a file
Progressive Web App (PWA)

Managing Pages in an Application

Understanding Page and Page components
Pages, Regions, and Page Designer

Creating Different Types of Reports

Classic reports and cards
Creating different types of reports

Creating and Using Forms

APEX application form types
Create and edit a form
Editable interactive grid and master detail form

Creating Database Application Components

Charts
Calendars
Maps

Implementing Security in Your Application

Security and authentication
Authorization

Migrating Application Development Between Environments

Security and authentication