Course Outline
Introduction
- Overview of Oracle APEX capabilities and architectural design
- Concepts behind database applications
- Introduction to APEXlang: The human-readable language for application definitions
Getting Started
- Installation of Oracle APEX
- Gaining access to the development workspace
- Exploring the interface and available tools
- Configuring external tools: Oracle SQL Developer for VS Code and SQLcl for APEXlang
Creating an Application
- Configuring the workspace
- Utilizing the Create Application wizard
- Incorporating and removing application features
- Generating a database app from a source file
- Applying an application blueprint
- Duplicating an existing database application
- Developing an application optimized for mobile devices
- Generative AI Development: Constructing apps from structured APEXlang specifications
- Adjusting application properties
- Oversight of application groups
- Utilizing application and workspace utilities
Managing Pages
- Incorporating pages into an application
- Constructing dialog pages
- Implementing branching logic with dialog pages
- Duplicating pages from database applications
- Removing pages from database applications
- Locking and releasing page versions
- Programmatic team collaboration: Leveraging APEXlang locking and working copy APIs
Using Page Designer
- Navigating the Page Designer interface
- Overseeing page properties
- Executing a page directly from Page Designer
- Utilizing the runtime developer toolbar
- Duplicating and deleting application pages
- Collaborative UI Development: Aligning App Builder workflows with APEXlang text files (.apx)
Building Reports and Forms
- Creating reports via the wizard
- Managing cards within a page
- Creating and modifying faceted search pages
- Tailoring interactive grids and reports
- Administering classic reports
- Displaying and printing reports
- Exploring various form types
- Constructing forms using the wizard
- Building master-detail forms
- Validating user inputs
- Handling BLOB data
Customizing Application Controls and Navigation
- Overseeing page-level items
- Incorporating dynamic actions, buttons, and trees
- Designing navigation menus, breadcrumbs, and tabs
- Applying computations, validations, and processes
- Utilizing shared components
- Enhancing application features (such as e-mail, plug-ins, and globalization)
Managing Application Security and Performance
- Adhering to security best practices
- Regulating access to applications, pages, and components
- Setting up user identity (authentication and authorization)
- Diagnosing performance bottlenecks
- Implementing logging and reporting mechanisms
- Generating custom reports
- Testing and debugging application logic
Deploying Applications
- Understanding the deployment lifecycle
- Creating, maintaining, and upgrading custom applications
- Compiling applications and components
- Publishing the database application URL
- Exporting applications as APEXlang packages (structured .apx files, native SQL, and assets vs. monolithic SQL scripts)
- Source Control integration: Managing APEXlang in Git and automating CI/CD pipelines
- Importing and installing exported files
- Targeted updates: Executing File-Level Imports from an APEXlang package
- Managing environment configurations using APEXlang Deployment Files
- Remotely deploying an application
Troubleshooting
Summary and Next Steps
Requirements
- Background in application development
- Proficiency with Oracle SQL Database
Target Audience
- Software Developers
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