Developing Applications with Oracle Application Express (APEX) Training Course

Introduction

• Overview of Oracle APEX features and architecture.
• Understanding database applications.

Getting Started

• Installing Oracle APEX.
• Accessing the development environment.
• Exploring the UI and tools.

Creating an Application

• Setting up the workspace.
• Using the Create Application wizard.
• Adding and removing application features.
• Creating a database app from a file.
• Using an application blueprint.
• Copying an existing database application.
• Creating an application for mobile devices.
• Configuring application attributes.
• Managing application groups.
• Using application and workspace utilities.

Managing Pages

• Adding pages to an application.
• Creating dialog pages.
• Branching with dialog pages.
• Copying database application pages.
• Deleting database application pages.
• Locking and unlocking pages.

Using Page Designer

• Navigating the Page Designer UI.
• Managing page attributes.
• Running a page from Page Designer.
• Using the runtime developer toolbar.
• Copying and deleting an application page.

Building Reports and Forms

• Creating a report using the wizard.
• Managing cards in a page.
• Creating and editing faceted search pages.
• Customizing interactive grids and reports.
• Managing classic reports.
• Viewing and printing reports.
• Understanding form types.
• Creating a form using the wizard.
• Creating master details 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