Developing Applications with Oracle Application Express (APEX) Training Course

Introduction

• Overview of Oracle APEX capabilities and architectural design
• Concepts of database-driven applications

Getting Started

• Installation procedures for Oracle APEX
• Accessing the development workspace
• Familiarizing yourself with the user interface and toolset

Creating an Application

• Workspace setup and configuration
• Utilizing the Create Application wizard
• Adding and removing specific application features
• Generating a database application from a file source
• Implementing application blueprints
• Duplicating existing database applications
• Developing applications optimized for mobile devices
• Adjusting application attributes
• Managing application groups
• Using utilities for applications and workspaces

Managing Pages

• Incorporating new pages into an application
• Designing dialog pages
• Implementing branching logic with dialog pages
• Copying pages from other database applications
• Deleting pages from database applications
• Locking and unlocking page structures

Using Page Designer

• Navigating the Page Designer interface
• Configuring page attributes
• Executing pages directly from Page Designer
• Utilizing the runtime developer toolbar
• Copying and removing application pages

Building Reports and Forms

• Generating reports via the wizard
• Managing card components within a page
• Creating and editing faceted search interfaces
• Customizing interactive grids and report views
• Managing classic report types
• Viewing and printing report outputs
• Understanding different form types
• Building forms using the wizard
• Constructing master-detail form relationships
• Validating user inputs
• Handling BLOB data types

Customizing Application Controls and Navigation

• Managing items at the page level
• Adding dynamic actions, buttons, and tree structures
• Creating navigation menus, breadcrumbs, and tab sets
• Implementing computations, validations, and processing steps
• Working with shared components
• Extending application features (including e-mail, plug-ins, and globalization support)

Managing Application Security and Performance

• Adhering to security best practices
• Restricting access to applications, pages, and components
• Configuring user identity management (authentication and authorization)
• Diagnosing performance bottlenecks
• Implementing logging and reporting mechanisms
• Creating custom report views
• Testing and debugging application logic

Deploying Applications

• Understanding the deployment workflow
• Creating, managing, and upgrading custom applications
• Building application structures and components
• Publishing the database application URL
• Exporting application definitions and components
• Importing and installing exported application files
• Remote deployment procedures

Troubleshooting

Summary and Next Steps