Oracle Application Express Workshop I Ed 2

Suggested Prerequisite

• Basic knowledge of SQL, PL/SQL, and HTML

Required Prerequisite

• Oracle Database: SQL Workshop I
• Oracle Database: SQL and PL/SQL Fundamentals

Audience

• Application Developers
• Database Administrators
• System Analysts
• Project Manager
• Forms Developer
• Business Intelligence Developer
• Web Administrator

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