Course Description

This course will teach you how to develop database-centric web applications quickly using Oracle Application Express.

You will learn to:

  • Create a database application for both desktop and mobile interfaces.
  • Add various components to enhance an application.
  • Create processes and validations within an application.
  • Create shared components for an application.
  • Implement security in an application.
  • Manage application navigation in an application.
  • Extend application.

Prerequisites

Required: Basic computer skills, internet access, basic analytic or programming skills.

Number of Days & Format

Number of Days: Five training days.

Format: Instructor lead (in person), remote, or training-on-demand.

Course curriculum

  • 1
    Course Overview
    • Order Management Database Application
    • Course Environment
    • Accessing the labs Directory
  • 2
    Introducing Oracle Application Express
    • Oracle Application Express Overview
    • Oracle Application Express Concepts
    • Using Oracle Application Express
    • Using Oracle Application Express in Oracle Database Cloud Service
    • Practices for Lesson 2: Overview
    • Practice 2-1: Using Oracle Application Express as a Workspace Administrator
    • Solution 2-1: Using Oracle Application Express as a Workspace Administrator
    • Practice 2-2: Using Oracle Application Express as a Developer
    • Solution 2-2: Using Oracle Application Express as a Developer
  • 3
    Creating a Database Application
    • Application Builder Overview
    • Introducing Database Applications
    • Creating a Database Application
    • Practice 3-1: Creating Database Applications
    • Solution 3-1: Creating Database Applications
  • 4
    Using and Creating Interactive Reports
    • Overview
    • Using Interactive Reports Part 1
    • Using Interactive Reports Part 2
    • Creating and Customizing an Interactive Report
    • Practices for Lesson 4: Overview
    • Practice 4-1: Building and Manipulating an Interactive Report
    • Solution 4-1: Building and Manipulating an Interactive Report
    • Practice 4-2: Customizing an Interactive Report
    • Solution 4-2: Customizing an Interactive Report
  • 5
    Creating Classic Reports, Wizard Reports, and Reports for Mobile Applications
    • Creating Classic Reports
    • Creating Wizard Reports
    • Creating List View for Mobile Applications
    • Practices for Lesson 5: Overview
    • Practice 5-1: Creating Classic and Wizard Reports
    • Solution 5-1: Creating Classic and Wizard Reports
    • Practice 5-2: Creating a List View
    • Solution 5-2: Creating a List View
  • 6
    Creating Forms
    • Using Forms
    • Creating Forms
    • Modifying Forms
    • Creating Forms in a Mobile Application
    • Practices for Lesson 6: Overview
    • Practice 6-1: Creating a Form on a Table
    • Solution 6-1: Creating a Form on a Table
    • Practice 6-2: Creating a Master Detail Form
    • Solution 6-2: Creating a Master Detail Form
    • Practice 6-3: Creating a Tabular Form
    • Solution 6-3: Creating a Tabular Form
    • Practice 6-4: Create a Form on a Table for Mobile Applications
    • Solution 6-4: Create a Form on a Table for Mobile Applications
  • 7
    Working with Pages and Regions
    • Introducing Page Definition
    • Working with Page Regions
    • Working with Pages
    • Practices for Lesson 7: Overview
    • Practice 7-1: Creating and Modifying Pages and Regions
    • Solution 7-1: Creating and Modifying Pages and Regions
    • Practice 7-2: Creating a Global Page and Adding a Region
    • Solution 7-2: Creating a Global Page and Adding a Region
    • Practice 7-3: Modify the Mobile Home Page
    • Solution 7-3: Modify the Mobile Home Page
  • 8
    Adding Items and Buttons
    • Introducing Items
    • Using Items
    • Creating List of Value (LOV) Type Items
    • Using Buttons
    • Practices for Lesson 8: Overview
    • Practice 8-1: Adding Items and Buttons
    • Solution 8-1: Adding Items and Buttons
    • Practice 8-2: Manipulating Items
    • Solution 8-2: Manipulating Items
  • 9
    Understanding Session State
    • Understanding Session State in Oracle Application Express
    • Using Session State in Oracle Application Express
    • Practices for Lesson 9: Overview
    • Practice 9-1: Understanding Session State
    • Solution 9-1: Understanding Session State
  • 10
    Adding Page Processing
    • Introducing Page Processing
    • Including Computations
    • Including Processes
    • Including Validations
    • Including Branches
    • Practices for Lesson 10: Overview
    • Practice 10-1: Creating and Manipulating Computations, Processes, and Validations
    • Solution 10-1: Creating and Manipulating Computations, Processes, and Validations
  • 11
    Validating and Debugging Your Application
    • Using the Advisor
    • Managing Your Attribute Dictionary
    • Using the Debug Option
    • Practices for Lesson 11: Overview
    • Practice 11-1: Using the Advisor
    • Solution 11-1: Using the Advisor
    • Practice 11-2: Managing Your Attribute Dictionary
    • Solution 11-2: Managing Your Attribute Dictionary
    • Practice 11-3: Debugging and Troubleshooting Common Issues in Your Application
    • Solution 11-3: Debugging and Troubleshooting Common Issues in Your Application
  • 12
    Adding Shared Components That Aid Navigation
    • Introducing Shared Components
    • Creating Tabs
    • Creating Lists
    • Creating Breadcrumbs
    • Creating a Navigation Bar
    • Practices for Lesson 12: Overview
    • Practice 12-1: Creating Lists and List Regions
    • Solution 12-1: Creating Lists and List Regions
    • Practice 12-2: Creating and Editing Standard Tabs
    • Solution 12-2: Creating and Editing Standard Tabs
    • Practice 12-3: Adding Navigation Bar Entries
    • Solution 12-3: Adding Navigation Bar Entries
    • Practice 12-4: Adding Breadcrumbs and Tabs to an Existing Page
    • Solution 12-4: Adding Breadcrumbs and Tabs to an Existing Page
  • 13
    Working with Themes, Templates, and Files
    • Using Themes
    • Using Templates
    • Working with Files
    • Practices for Lesson 13: Overview
    • Practice 13-1: Working with Themes, Templates, and Files
    • Solution 13-1: Working with Themes, Templates, and Files
  • 14
    Implementing Security
    • Securing an Application
    • Using Authentication Schemes
    • Using Authorization Schemes
    • Using Session State Protection
    • Practices for Lesson 14: Overview
    • Practice 14-1: Creating an Authentication Scheme
    • Solution 14-1: Creating an Authentication Scheme
    • Practice 14-2: Restricting Users by Using Access Control
    • Solution 14-2: Restricting Users by Using Access Control
    • Practice 14-3: Using Session State Protection
    • Solution 14-3: Using Session State Protection
  • 15
    Managing Application Navigation
    • Building a hierarchical list with images
    • Building a database-driven navigation report
    • Building a site map
    • Enforcing authorization on your site map
    • Practices for Lesson 15: Overview
    • Practice 15-1: Building a Hierarchical List with Images
    • Solution 15-1: Building a Hierarchical List with Images
    • Practice 15-2: Building a Database-Driven Report
    • Solution 15-2: Building a Database-Driven Navigation Report
    • Practice 15-3: Building a Site Map
    • Solution 15-3: Building a Site Map
    • Practice 15-4: Enforcing Authorization in Site Map
    • Solution 15-4: Enforcing Authorization in Site Map
  • 16
    Extending Your Application
    • Creating Data Load Wizard Pages
    • Creating an Upload and Download Page
    • Adding BLOB Data to an Existing Application
    • Sending Email from an Application
    • Practices for Lesson 16: Overview
    • Practice 16-1: Adding a Data Upload Wizard
    • Solution 16-1: Adding a Data Upload Wizard
    • Practice 16-2: Creating an Upload and Download Page
    • Solution 16-2: Creating an Upload and Download Page
    • Practice 16-3: Using BLOB Data in a Report and Form
    • Solution 16-3: Using BLOB Data in a Report and Form
  • 17
    Creating and Editing Charts
    • Creating and Using Charts
    • Reviewing Additional Charting Examples
    • Practices for Lesson 17: Overview
    • Practice 17-1: Creating and Editing Charts
    • Solution 17-1: Creating and Editing Charts
    • Practice 17-2: Creating an HTML5 Chart for Mobile Applications
    • Solution 17-2: Creating an HTML5 Chart for Mobile Applications
    • Practice 17-3: Creating Additional Charts
    • Solution 17-3: Creating Additional Charts
  • 18
    Adding Calendars and Trees
    • Using Calendars
    • Using Trees
    • Practices for Lesson 18: Overview
    • Practice 18-1: Creating a Calendar
    • Solution 18-1: Creating a Calendar
    • Practice 18-2: Creating a Tree Whose Nodes Link to a Different Page
    • Solution 18-2: Creating a Tree Whose Nodes Link to a Different Page
  • 19
    Using Dynamic Actions and Plug-Ins
    • Using Dynamic Actions
    • Using Plug-Ins Part 1
    • Using Plug-Ins Part 2
    • Practices for Lesson 19: Overview
    • Practice 19-1: Using Dynamic Actions on Your Page
    • Solution 19-1: Using Dynamic Actions on Your Page
    • Practice 19-2: Importing and Using Plug-ins
    • Solution 19-2: Importing and Using Plug-Ins
  • 20
    Using Application Express Printing
    • Understanding Application Express printing architecture
    • Customizing and Printing a Standard Report
    • Creating a Customized Report
    • Practices for Lesson 20: Overview
    • Practice 20-1: Printing a Standard Report with Derived Output
    • Solution 20-1: Printing a Standard Report with Derived Output
    • Practice 20-1: Printing a Standard Report with Derived Output
    • Practice 20-2: Creating a PDF Report with Multiple Queries
    • Solution 20-2: Creating a PDF Report with Multiple Queries
  • 21
    Managing Application Feedback
    • Understanding Team Development
    • Reviewing the Progress of your Milestones and Features
    • Practices for Lesson 21: Overview
    • Practice 21-1: Adding and Monitoring Feedback in Your Application
    • Solution 21-1: Adding and Monitoring Feedback in Your Application
  • 22
    Additional Resources
    • Additional Resources
  • 23
    More Information About Application Development
    • Create a Websheet Application
    • Working with Pages and Sections
    • Creating Data Grids
    • Manipulating Data Grids
    • Create a Websheet Application
    • Interacting with the Database
    • Enhancing Websheet Applications
    • Administering Websheet Applications
    • Manipulate and Administer a Websheet Application
  • 24
    Developing Applications in Oracle Application Express for Oracle Database Cloud Service
    • Oracle Cloud Overview
    • Oracle Cloud Overview
    • Types of Services offered by Oracle Cloud
    • Types of Services offered by Oracle Cloud
    • Creating a Database Cloud Service
    • Creating a Database Cloud Service
    • Accessing the Database Cloud Service APEX environment
    • Accessing the Database Cloud Service Oracle Application Express Environment
    • Adding Applications to a Database Cloud Service
    • Adding Applications to a Database Cloud Service
    • Administering a Database Cloud Service
    • Administering a Database Cloud Service
  • 25
    About Deploying an Application
    • Overview
    • Overview
    • Creating a Packaged Application
    • Creating a Packaged Application
    • Installing a Packaged Application
    • Installing a Packaged Application
  • 26
    Resources
    • Resources

Instructor(s)