Course Outline
Introduction
- Overview of Oracle APEX features and underlying architecture
- Concepts behind database applications
Getting Started
- Installation of Oracle APEX
- Gaining access to the development environment
- Familiarizing oneself with the UI and available tools
Building an Application
- Initializing the workspace
- Utilizing the Create Application wizard
- Adding or removing specific application features
- Generating a database application from a file
- Implementing an application blueprint
- Duplicating an existing database application
- Developing applications for mobile platforms
- Setting application attributes
- Organizing application groups
- Utilizing application and workspace utilities
Page Management
- Inserting pages into an application
- Constructing dialog pages
- Implementing branching logic with dialog pages
- Duplicating pages from database applications
- Removing pages from database applications
- Controlling page locks and unlocks
Utilizing Page Designer
- Navigating the Page Designer interface
- Administering page attributes
- Executing a page directly from Page Designer
- Using the runtime developer toolbar
- Duplicating and removing application pages
Constructing Reports and Forms
- Generating reports via the wizard
- Administering page cards
- Developing and modifying faceted search pages
- Personalizing interactive grids and reports
- Maintaining classic reports
- Displaying and printing reports
- Reviewing various form types
- Generating forms via the wizard
- Building master-detail forms
- Implementing user input validation
- Handling BLOBs
Tailoring Application Controls and Navigation
- Administering page-level items
- Incorporating dynamic actions, buttons, and trees
- Designing navigation menus, breadcrumbs, and tabs
- Applying computations, validations, and processes
- Managing shared components
- Extending application capabilities (e.g., e-mail, plug-ins, globalization)
Application Security and Performance Management
- Best practices for security
- Regulating access to applications, pages, and components
- Configuring user identity, including authentication and authorization
- Detecting performance bottlenecks
- Implementing logging and reporting mechanisms
- Generating custom reports
- Testing and debugging applications
Application Deployment
- Grasping the deployment workflow
- Creating, administering, and upgrading custom applications
- Assembling applications and components
- Publishing the database application URL
- Exporting applications and components
- Importing and installing exported files
- Remote application deployment
Diagnosis and Resolution
Concluding Remarks and Future Directions
Requirements
- Practical experience in application development
- Knowledge of 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
