Developing Applications with Oracle Application Express (APEX) Training Course

Introduction

• Overview of Oracle APEX features and architecture for government use
• Understanding database applications in a public sector context

Getting Started

• Installing Oracle APEX for government operations
• Accessing the development environment for government users
• Exploring the user interface and tools for government applications

Creating an Application

• Setting up the workspace for government projects
• Using the Create Application wizard for government applications
• Adding and removing application features for government needs
• Creating a database app from a file for government use
• Using an application blueprint for government projects
• Copying an existing database application for government purposes
• Creating an application for mobile devices in the public sector
• Configuring application attributes for government operations
• Managing application groups for government use
• Using application and workspace utilities for government applications

Managing Pages

• Adding pages to an application for government use
• Creating dialog pages for government applications
• Branching with dialog pages in government applications
• Copying database application pages for government projects
• Deleting database application pages for government needs
• Locking and unlocking pages for government security

Using Page Designer

• Navigating the Page Designer user interface for government applications
• Managing page attributes in government applications
• Running a page from Page Designer for government use
• Using the runtime developer toolbar for government applications
• Copying and deleting an application page for government projects

Building Reports and Forms

• Creating a report using the wizard for government operations
• Managing cards in a page for government use
• Creating and editing faceted search pages for government applications
• Customizing interactive grids and reports for government needs
• Managing classic reports for government use
• Viewing and printing reports for government operations
• Understanding form types for government applications
• Creating a form using the wizard for government projects
• Creating master detail forms for government use
• Validating user inputs in government applications
• Working with BLOBs for government data management

Customizing Application Controls and Navigation

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

Managing Application Security and Performance

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

Deploying Applications

• Understanding the deployment process for government applications
• Creating, managing, and upgrading custom applications for government projects
• Building the applications and components for government use
• Publishing the database application URL for government access
• Exporting applications and components for government operations
• Importing and installing exported files for government use
• Deploying an application remotely for government needs

Troubleshooting

Summary and Next Steps