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

1. Getting Started with Oracle APEX

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

2. Using SQL Workshop

08 - Getting started and using SQL Workshop components
09 - Use SQL commands and SQL scripts
10 - Sample datasets
11 - Generate SQL 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 - Understanding Page and Page components
18 - Pages, Regions, and Page Designer

5. Creating Different Types of Reports

19 - Classic reports and cards
20 - Creating different types of reports

6. Creating and Using Forms

21 - APEX application form types
22 - Create and edit a form
23 - Editable interactive grid and master detail form

7. Creating Database Application Components

24 - Charts
25 - Calendars
26 - Maps

8. Implementing Security in Your Application

27 - Security and authentication
28 - Authorization

9. Migrating Application Development Between Environments

29 - Security and authentication