Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Testimonials (4)
It was one on one so I could show him my existing environment and discuss my real issues
Virendra Miglani - Westfraser Mills
Course - Developing Applications with Oracle Application Express (APEX)
Creating my own application and learning the foundations of oracle apex
Jamie - Northern Ireland Water
Course - Developing Applications with Oracle Application Express (APEX)
The topic was interesting, and the trainer was very friendly and has adept knowledge of the subject.
Jacqueline - Tribal Grou[
Course - Developing Applications with Oracle Application Express (APEX)
The way trainer demonstrated everything