Getting Started with Oracle APEX on the Oracle Autonomous Database

• Describe Oracle APEX and its key components
• Create and manage a workspace

Using SQL Workshop 

• Create and modify database objects
• Generate SQL using Quick SQL, and Run SQL commands and scripts
• Load and unload data using the Data Workshop utility

Creating an APEX Application 

• Create an APEX application based on existing tables and from a file
• Explain the concepts of App Builder

Managing Pages and Regions

• Create different page types and regions
• Manage pages and page components in Page Designer

Developing Reports 

• Create and customize an interactive report, an interactive grid, and a classic report
• Create a report with form
• Create and customize cards, smart filters, and faceted search page
• Customize interactive grid as an end user

Creating and Using Forms 

• Create an editable interactive grid
• Create and modify a simple form and link a report to this form
• Create different types of master detail forms

Creating Application Page Controls  

• Create and use page-level items and buttons

Adding Computations, Processes, Validations and Branches

• Create computations, page processes, validations and branches

Implementing Navigation in your Application 

• Create, edit, and use shared components that aid navigation in an application
• Configure search

Managing Application Data   

• Use Collections
• Manage RESTenabled SQL references and REST Data Sources
• Use Data Synchronization

Using Themes and Theme Styles      

• Create and use a new theme
• Use Theme Styles, Theme Roller and Live Template Options
• Create Template Components

Extending Application Capabilities     

• Sending E-Mail from an application
• Using Automations
• Implement Plug-ins in your application

Implementing Security in your Application   

• Create and use an authentication scheme for your application
• Create and attach an authorization scheme to your application, page, or components
• Use Session State Protection

Adding Additional Pages to your Application 

• Create and use Oracle JET charts and Calendars
• Create, customize, and use Trees and Maps

Creating and Using Dynamic Actions and Plug-ins 

• Create and use Dynamic Actions
• Implement Plug-ins in your application

Migrating Application Development Between Environments

• Export artifacts from your development environment and import into the target development environment
• Perform One-click Remote Application Deployment
• Create and manage Working Copy

Managing Workflows and Tasks

• Create and Customize Workflows
• Use Approvals and Unified Tasks Lists

Leveraging Generative AI in Oracle APEX

• Using APEX Assistant in Code Editors and, to create a data model and an application
• Using Dynamic Action to Show AI Assistant and Generate Text with AI

Creating Progressive Web Apps 

• Creating and Enhancing a Progressive Web Application
• Sending and Receiving Push Notifications

Earn your credential