Getting Started with Oracle APEX on the Oracle Autonomous Database |
- Describe Oracle APEX
- Creating and Managing a Workspace
- List and describe the major components of Oracle APEX
|
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 an APEX Application |
- Create an APEX application based on existing tables
- Create an APEX application from a file
- Create a progressive web application (PWA)
- Managing Application Attributes with App Builder Concepts
|
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 and customize the interactive report
- Create and customize the interactive grid
- Create and customize the classic report
- Create a report with a form
- Create and customize Cards
- Create and customize Smart Filter
- Create and customize a faceted search page
|
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, Validations, and Branches |
- Create computations
- Create page processes
- Create validations
- Create branches
|
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
- Search Configurations
|
Managing Application Data |
- Use Collections
- Manage REST Enabled SQL References
- Manage REST Data Sources
- Data Synchronisation
|
Using Themes and Theme Styles |
- Create and use a new theme
- Use Theme Styles
- Use Theme Roller and Live Template Options
|
Extending Application Capabilities |
- Sending E-Mail from an application
- Automation
- Approvals and Unified Tasks Lists
- Describe and 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
- Using Session State Protection
|
Adding Additional Pages to Your Application |
- Oracle JET Charts
- Calendars
- Trees
- Maps
|
Creating and Using Dynamic Actions |
- 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 them into the target development environment
- Perform One-click Remote Application Deployment
|
Official Information |
https://education.oracle.com/oracle-apex-cloud-developer-professional/pexam_1Z0-770 |