Course Description

Prepare to pass exam: Oracle APEX Cloud Developer Professional

An Oracle APEX Cloud Developer Professional has demonstrated the hands-on experience and knowledge required to design, develop, and deploy Oracle APEX applications. Certified Oracle APEX Cloud Developer professionals are capable of building modern, secure, scalable enterprise apps with world-class features that can be deployed anywhere – whether in the cloud or on-premises. This certification aims to evaluate the candidate’s solid understanding of low-code application development with Oracle APEX. It also validates the candidate’s ability to effectively use Oracle APEX capabilities to build compelling solutions for various use cases.

To prepare for the Oracle APEX Cloud Developer Professional exam, focus on mastering the core concepts of Oracle Application Express (APEX) and its features. Familiarize yourself with developing web applications using APEX, including data modeling, application security, and deployment strategies. Utilize official study guides, practice exams, and hands-on experience to reinforce your skills and boost your confidence. Additionally, engage in community forums and resources to gain insights from others who have successfully passed the exam.

Leverage Oracle's official documentation and online courses to stay updated on the latest APEX functionalities and best practices. Creating sample applications will provide practical experience, helping you to solidify your understanding and improve your problem-solving abilities for the exam.

Exam topics covered

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