Developing Applications with Oracle Application Express (APEX)...
Certificate ID:
767323
Authentication Code:
2b44c
Certified Person Name:
Sylwester Gorczyca
Trainer Name:
Dominik Haczek
Duration Days:
2
Duration Hours:
14
Course Name:
Developing Applications with Oracle Application Express (APEX)
Course Date:
18 June 2024 09:00 to 19 June 2024 16:00
Course Outline:
Introduction
- Overview of Oracle APEX features and architecture
- Understanding database applications
Getting Started
- Installing Oracle APEX
- Accessing the development environment
- Exploring the UI and tools
Creating an Application
- Setting up the workspace
- Using the Create Application wizard
- Adding and removing application features
- Creating a database app from a file
- Using an application blueprint
- Copying an existing database application
- Creating an application for mobile devices
- Configuring application attributes
- Managing application groups
- Using application and workspace utilities
Managing Pages
- Adding pages to an application
- Creating dialog pages
- Branching with dialog pages
- Copying database application pages
- Deleting database application pages
- Locking and unlocking pages
Using Page Designer
- Navigating the Page Designer UI
- Managing page attributes
- Running a page from Page Designer
- Using the runtime developer toolbar
- Copying and deleting an application page
Building Reports and Forms
- Creating a report using the wizard
- Managing cards in a page
- Creating and editing faceted search pages
- Customizing interactive grids and reports
- Managing classic reports
- Viewing and printing reports
- Understanding form types
- Creating a form using the wizard
- Creating master details forms
- Validating user inputs
- Working with BLOBs
Customizing Application Controls and Navigation
- Managing page-level items
- Adding dynamic actions, buttons, and trees
- Creating navigation menus, breadcrumbs, and tabs
- Using computations, validations, and processes
- Working with shared components
- Extending application functions (e-mail, plug-ins, globalization, etc.)
Managing Application Security and Performance
- Security best practices
- Controlling access to applications, pages, and components
- Configuring user identity (authentication and authorization)
- Identifying performance issues
- Logging and reporting
- Creating custom reports
- Testing and debugging applications
Deploying Applications
- Understanding the deployment process
- Creating, managing, and upgrading custom applications
- Building the applications and components
- Publishing the database application URL
- Exporting applications and components
- Importing and installing exported files
- Deploying an application remotely
Troubleshooting
Summary and Next Steps