Developing Applications with Oracle Application Express (APEX) Training Course

Introduction

• Overview of Oracle APEX features and architecture
• Grasping the concept of database applications

Getting Started

• Installation of Oracle APEX
• Accessing the development environment
• Exploring the UI and tools

Creating an Application

• Setting up the workspace
• Utilizing the Create Application wizard
• Adding and removing application features
• Building a database app from a file
• Applying an application blueprint
• Duplicating an existing database application
• Creating a mobile-friendly application
• Configuring application attributes
• Managing application groups
• Utilizing application and workspace utilities

Managing Pages

• Adding pages to an application
• Creating dialog pages
• Implementing branching with dialog pages
• Duplicating database application pages
• Removing database application pages
• Locking and unlocking pages

Using Page Designer

• Navigating the Page Designer UI
• Managing page attributes
• Running a page directly from Page Designer
• Utilizing the runtime developer toolbar
• Duplicating and deleting an application page

Building Reports and Forms

• Creating a report via the wizard
• Managing cards on a page
• Creating and editing faceted search pages
• Customizing interactive grids and reports
• Managing classic reports
• Viewing and printing reports
• Understanding different form types
• Creating a form using the wizard
• Building master-detail forms
• Validating user inputs
• Working with BLOBs

Customizing Application Controls and Navigation

• Managing page-level items
• Adding dynamic actions, buttons, and trees
• Creating navigation menus, breadcrumbs, and tabs
• Using computations, validations, and processes
• Working with shared components
• Extending application functions (e-mail, plug-ins, globalization, etc.)

Managing Application Security and Performance

• Security best practices
• Controlling access to applications, pages, and components
• Configuring user identity (authentication and authorization)
• Identifying performance issues
• Logging and reporting
• Creating custom reports
• Testing and debugging applications

Deploying Applications

• Understanding the deployment process
• Creating, managing, and upgrading custom applications
• Building the applications and components
• Publishing the database application URL
• Exporting applications and components
• Importing and installing exported files
• Deploying an application remotely

Troubleshooting

Summary and Next Steps