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.
Duration 21 hours
Course Outline
Introduction
- Key features and architectural overview of Oracle APEX
- Concepts behind database applications
Initial Setup
- Installing Oracle APEX
- Gaining access to the development workspace
- Familiarizing oneself with the UI and available tools
Application Creation
- Configuring the development workspace
- Leveraging the Create Application wizard
- Adding or removing specific application features
- Generating a database app from an existing file
- Applying an application blueprint
- Duplicating a pre-existing database application
- Developing applications tailored for mobile devices
- Adjusting application-specific attributes
- Organizing application groups
- Utilizing application and workspace management utilities
Page Administration
- Integrating new pages into an application
- Constructing dialog-based pages
- Implementing branching logic with dialog pages
- Duplicating pages from a database application
- Removing pages from a database application
- Toggling page lock states
Page Designer Utilization
- Navigating the Page Designer interface
- Modifying page properties
- Executing a page directly from Page Designer
- Utilizing the runtime developer toolbar
- Duplicating or removing application pages
Reports and Forms Development
- Generating reports via the wizard
- Organizing cards within a page layout
- Building and refining faceted search pages
- Personalizing interactive grids and report displays
- Administering classic report structures
- Displaying and generating print-ready reports
- Distinguishing between various form types
- Building forms using the wizard
- Designing master-detail form structures
- Implementing user input validation
- Handling BLOB data types
Control and Navigation Customization
- Managing items at the page level
- Introducing dynamic actions, buttons, and tree structures
- Designing navigation menus, breadcrumb trails, and tab sets
- Applying computations, validation rules, and business processes
- Leveraging shared components
- Expanding application capabilities (e.g., email integration, plug-ins, globalization)
Security and Performance Management
- Adhering to security best practices
- Restricting access to applications, specific pages, and components
- Setting up user identification (authentication and authorization)
- Diagnosing performance bottlenecks
- Implementing logging and reporting mechanisms
- Generating custom reports
- Testing and troubleshooting application logic
Application Deployment
- Understanding the deployment workflow
- Creating, maintaining, and updating custom applications
- Compiling applications and their constituent components
- Publicizing the database application URL
- Exporting applications and related components
- Importing and installing exported content
- Executing remote application deployments
Troubleshooting
Conclusion and Future Pathways
Requirements
- Prior experience in application development
- Working 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
