Getting Started with Oracle APEX on the Oracle Autonomous Database

• Creating and Managing a Workspace
• Getting Started with Oracle APEX Service
• Creating and Managing APEX Service

Using SQL Workshop

• Create and modify database objects
• Run SQL Commands and Scripts
• Load and Unload data using the Data Workshop Utility
• Generate SQL using Quick SQL

Creating a Database Application

• Create a database application based on existing tables
• Create a database application from a file
• Create applications for mobile devices

Working with Pages and Regions

• Create different page types and regions
• Manage pages in Page Designer
• Manage page attributes
• Add Page Components

Developing Reports

• Create an interactive report
• Create an interactive grid
• Create a classic report
• Create a report with form
• Create a faceted search page
• Use and customise interactive report as an end user
• Manage interactive report attributes
• Configure the display of interactive report controls as a developer
• Manage interactive grid attributes
• Customize the Interactive Grid Toolbar
• Customize interactive grid as an end user
• Customize faceted search region and facet behaviour

Creating and Using Forms

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

Creating Application Page Controls

• Create and use page-level items and buttons

Adding Computations, Processes, and Validations

• Create computations
• Create page processes
• Create validations

Implementing Navigation in your Application

• Create, edit, and use the following shared components that aid navigation in an application:
• Lists
• Navigation Menus
• Breadcrumbs
• Navigation bar entries

Managing Application Data

• Manage REST Enabled SQL References
• Manage Web Source Modules

Using Themes and Theme Styles

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

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

Adding Additional Pages to your Application

• Create, customize, and use the following pages in your application:
• Oracle JET Charts
• Calendars
• Trees

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 the application definition, underlying database objects, and data from your development environment and import in the target development environment
• Perform One-click Remote Application Deployment