Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: INTRODUCTION TO ORACLE APPLICATION EXPRESS

• APEX Concepts
• APEX Main Components
• Workspaces, Database Applications and Websheet Applications
• Creating a Workspace
• The Workspace Administrator
• Upgrading APEX
• Logging into APEX
• Running an Application

Session 2: SQL WORKSHOP

• Use APEX to Browse, Create and Modify Objects
• Process Ad Hoc SQL Statements
• Manage Scripts in APEX
• Create, Run and Save SQL Queries

Session 3: BUILD A DATABASE APPLICATION

• Application Components
• Create an Application
• Create an Application from a Spreadsheet

Session 4: CREATE REPORTS

• Create Reports Using Wizards
• Edit Report Attributes
• Add Links to Reports
• Create a Link to a Printer-Friendly version of a Report
• Save and Print Reports in Different Formats

Session 5: PAGES AND REGIONS

• View Page Definitions
• Edit Page Definitions
• Create a Page Zero
• Create a New Region
• View Region Attributes
• Add Comments
• Add a Title
• Add a logo

Session 6: INTRODUCTION TO SHARED COMPONENTS

• Overview of Application Express Shared Components
• Standard Tabs
• Dynamic and Static Lists of Values
• Create a Dynamic List of Values
• Create a Static List of Values
• Use a List of values to Control Data in a Report
• Create a Cascading List of Values

Session 7: CREATE FORMS

• Web Form Behaviour in APEX
• Create Forms of Different Types
• Format a Form
• Add a List of Values to a Form
• Locking in APEX Forms

Session 8: ITEMS AND BUTTONS

• Create Items
• Edit Item Attributes
• Create Buttons
• Edit Button Attributes

Session 9: PAGE PROCESSING

• Page Rendering and Page Processing
• Create Computations
• Validate Input Data
• Process Data
• Create Application Branching

Session 10: ADD SHARED NAVIGATION COMPONENTS

• Overview of Application Express Shared Components
• Parent and Standard Tabs
• Navigation Bars
• Lists
• Breadcrumbs

Session 11: OTHER SHARED COMPONENTS

• Text Messages
• Trees
• Shared Component Reports
• User Interface Defaults

Session 12: DISPLAY DYNAMIC CONTENT

• Filter Reports with Dynamic Queries
• Create Charts with a Wizard
• Format Charts
• Create a Calendar

Session 13: DYNAMIC ACTIONS AND PLUG-IN COMPONENTS

• Understand Dynamic Actions
• Understand Plug-in Components
• Plug In a Component
• Create a Dynamic Action
• Use a Plug-in in a Dynamic Action

Session 14: Session STATE AND DEBUGGING

• Understand Session State
• Set a Session State Value
• Clear the Session State
• Review the Session State
• Review the Messages in Debug Mode

Session 15: THEMES AND TEMPLATES

• Switch to a Different Theme
• View Existing Templates
• Manage Templates
• Create a new Template
• Template subscription
• Add a Reference to a Cascading Style Sheet
• Add a reference to a Javascript file

Session 16: BUILD A WEBSHEET APPLICATION

• Websheet Components
• Create a Websheet Application
• Run a Websheet
• Add a Section to a Websheet
• Add a Page to a Websheet

Session 17: WEBSHEET DATA GRIDS AND LINKS

• Add a Data Grid to a Websheet using Copy & Paste
• Add a Data Grid from Scratch
• Link a Data Grid to a Websheet Page
• Link a File to a Websheet Page

Session 18: ADMINISTER APEX WORKSPACES

• Manage Users
• Request a Schema or Storage
• Purge Session State
• Monitor Developer Activity Log
• Monitor Workspace Activity
• View Activity reports
• Import a Workspace

Session 19: IMPLEMENT SECURITY

• Authentication and Authorization
• Provide an Authentication Scheme
• Create an Authorization Scheme Using Access Control
• Enable and Configure Session State Protection

Session 20: DEPLOY AN APPLICATION

• Define Supporting Objects
• Package an Application
• Export an Application
• Import an Application
• Install Supporting Objects

Session 21: UTILITY PROGRAMS

• Import and Export Data
• Generate DDL Statements
• View Objects Reports
• Monitor the Database