Course Topics
1. Course Overview
- Course Environment: Products Installed
- Introducing Course Persona: Jack
- Course Goals
- Course Outline
- Course Environment: Workspace Details
- Order Management Database Application (OMDA)
- Accessing the Labs Directory
2. Introducing Oracle Application Express
- Application Express Overview
- Using Application Express
- Application Express Terms and Concepts
3. Creating a Desktop and Mobile Database Application
- Application Builder Overview
- Creating Mobile Application
- Introducing Database Applications
- Creating Database Applications
4. Working with Reports for Desktop Application
- Using Interactive Reports
- Using Classic Reports
- Introducing Reports
- Creating and Customizing an Interactive Report
5. Working with Reports for Mobile Application
- Creating a Reflow Report
- Creating Reports for a Mobile Application
- Creating Column Toggle Report
6. Creating Forms
- Creating Forms
- Creating a Form in a Mobile Application
- Modifying Forms
- Using Forms
7. Working with Pages and Regions
- Working with Page Regions
- Introducing Page Definition
- Working with Pages
8. Adding Items and Buttons
- Creating List of Value (LOV) Type of Items
- Using Buttons
- Introducing Items
- Using Items
9. Understanding Session State
- Using Session State in Oracle Application Express
- Understanding Session State in Oracle Application Express
10. Including Page Processing
- Introducing Page Processing
- Including Computations
- Including Branches
- Including Processes
- Including Validations
11. Validating and Debugging Your Application
- Using the Advisor
- Managing Your Attribute Dictionary
- Debugging Your Application
12. Adding Shared Components That Aid Navigation
- Introducing Shared Components
- Creating a Navigational Bar
- Creating Lists
- Creating Tabs
- Creating Breadcrumbs
13. Working with Themes, Templates and Files
- Using Templates
- Using Files
- Using Themes
14. Implementing Security
- Using Authorization Schemes
- Using Authentication Schemes
- Using Session State Protection
- Securing an Application
15. Managing Application Navigation
- Enforcing Authorization on Your Site Map
- Building a Site Map
- Building a Hierarchical List with Images
- Linking Interactive Reports using a Declarative Filter
16. Extending Your Application
- Sending Email from an Application
- Creating Data Load Wizard Pages
- Creating an Upload and Download Page
- Adding BLOB Data to an Existing Application
17. Creating and Editing Charts
- Creating and Using Charts
- Enhanced Charting Examples
18. Adding Calendars and Trees
- Using Calendars
- Using Trees
19. Using Dynamic Actions and Plug-Ins
- Using Dynamic Actions
- Using Plug-Ins
20. Utilizing Application Express Printing
- Printing a Standard Report with Derived Output
- Creating a PDF Report with Multiple Queries
21. Managing Application Feedback
- What is Team Development?
- Managing Feedback