Developing Applications with Oracle Application Express (APEX) Training Course

Introduction

• Examination of Oracle APEX capabilities and system architecture
• Foundational understanding of database-driven applications

Initial Configuration

• Installation procedures for Oracle APEX
• Establishing access to the development environment
• Review of the user interface and available tools

Application Development

• Initialization of the development workspace
• Utilization of the application creation wizard
• Incorporation and removal of specific application capabilities
• Generation of a database application from a source file
• Implementation of an application blueprint
• Replication of an existing database application
• Construction of an application optimized for mobile devices
• Definition and adjustment of application attributes
• Oversight of application grouping structures
• Application of application and workspace administrative utilities

Page Administration

• Inclusion of new pages within an application
• Construction of modal dialog pages
• Implementation of branching logic involving dialog pages
• Replication of existing database application pages
• Removal of database application pages
• Management of page locking mechanisms

Page Designer Utilization

• Navigation through the Page Designer interface
• Administration of page-specific attributes
• Execution of a page directly from the Page Designer
• Deployment of the runtime developer toolbar
• Replication and deletion of application pages

Development of Reports and Forms

• Generation of reports via the guided wizard
• Management of card components within a page
• Creation and modification of faceted search interfaces
• Tailoring of interactive grids and report views
• Oversight of classic report configurations
• Review and output of report data
• Analysis of various form typologies
• Construction of forms using the guided wizard
• Implementation of master-detail form structures
• Implementation of user input validation rules
• Handling of Binary Large Object (BLOB) data

Customization of Application Controls and Navigation

• Oversight of page-level input items
• Implementation of dynamic actions, buttons, and tree structures
• Construction of navigation menus, breadcrumb trails, and tab structures
• Utilization of computations, validation logic, and processes
• Management of shared components
• Expansion of application functions, including e-mail, plug-ins, and globalization features

Management of Application Security and Performance

• Adherence to security best practices
• Regulation of access rights to applications, pages, and components
• Configuration of user identity, encompassing authentication and authorization
• Identification and assessment of performance bottlenecks
• Implementation of logging and reporting protocols
• Generation of custom reports
• Execution of application testing and debugging procedures

Application Deployment

• Comprehension of the deployment lifecycle
• Creation, administration, and versioning of custom applications
• Assembly of application structures and components
• Publication of the database application URL
• Exportation of applications and related components
• Importation and installation of exported artifacts
• Remote deployment of application instances

Troubleshooting

Summary and Subsequent Actions