Oracle APEX: Foundations (2023)

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

1. Getting Started with Oracle APEX

01 - Low code application development
02 - Oracle APEX - Introduction
03 - Availability and architecture
04 - Use cases
05 - Provision an APEX workspace
06 - Product components
07 - Install a sample application

2. Using SQL Workshop

08 - Get started and use SQL workshop components
09 - Use SQL commands and SQL scripts
10 - Sample datasets
11 - Generate SQL by using quick SQL

3. Creating a Database Application

12 - App Builder concepts
13 - Access and use App Builder
14 - Database application based on existing tables
15 - Create an application from a file
16 - Progressive web app (PWA)

4. Managing Pages in an Application

17 - Understand Page and Page components
18 - Pages, Regions, and Page Designer

5. Creating Different Types of Reports

19 - Developing reports
20 - Classic reports and cards
21 - Create different types of reports

6. Creating and Using Forms

22 - APEX applications form types
23 - Create and edit a form
24 - Editable interactive grid and master detail form

7. Creating Database Application Components

25 - Charts
26 - Calendars
27 - Maps

8. Implementing Security in Your Application

28 - Security and authentication
29 - Authorization

9. Migrating Application Development between Environments

30 - Export and import application