Get in Touch

Course Outline

Introduction

  • Overview of Oracle APEX capabilities and architectural framework
  • Foundations of database application development

Getting Started

  • Installation procedures for Oracle APEX
  • Accessing the development environment
  • Familiarization with user interface and tools

Creating an Application

  • Establishing workspace configuration
  • Utilizing the Create Application wizard
  • Modifying application features as needed
  • Deriving a database application from external files
  • Implementing application blueprints
  • Cloning existing database applications
  • Developing mobile-responsive applications
  • Adjusting application attributes
  • Administering application groups
  • Leveraging application and workspace utilities for government workflows

Managing Pages

  • Integrating pages into existing applications
  • Developing dialog page components
  • Configuring branching logic with dialog pages
  • Replicating database application pages
  • Removing database application pages
  • Locking and unlocking page configurations

Using Page Designer

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

Building Reports and Forms

  • Generating reports via wizard tools
  • Administering card views on pages
  • Developing and editing faceted search interfaces
  • Customizing interactive grids and standard reports
  • Managing classic report formats
  • Accessing and printing report outputs
  • Analyzing various form structures
  • Constructing forms using wizard assistance
  • Designing master-detail form relationships
  • Implementing input validation protocols
  • Managing Binary Large Object (BLOB) data

Customizing Application Controls and Navigation

  • Administering page-level items
  • Integrating dynamic actions, buttons, and tree structures
  • Constructing navigation menus, breadcrumbs, and tabs
  • Implementing computations, validations, and processes
  • Managing shared component libraries
  • Extending application functionality (e-mail integration, plug-ins, globalization, etc.) for government services

Managing Application Security and Performance

  • Adhering to security best practices
  • Governing access controls for applications, pages, and components
  • Configuring user identity management (authentication and authorization)
  • Identifying potential performance bottlenecks
  • Monitoring logs and generating reports
  • Developing custom analytical reports
  • Executing application testing and debugging procedures

Deploying Applications

  • Comprehending the deployment lifecycle
  • Creating, managing, and upgrading custom applications
  • Compiling applications and associated components
  • Establishing database application URLs
  • Exporting applications and component files
  • Importing and installing exported archives for government systems
  • Executing remote application deployment

Troubleshooting

Summary and Next Steps

Requirements

  • Professional experience in application development
  • Competency in Oracle SQL database management

Audience

  • Software developers engaged in government projects for government entities
 21 Hours

Number of participants


Price per participant

Testimonials (4)

Upcoming Courses

Related Categories