Oracle Application Express 5 (APEX)

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

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

Session 5: USING FILES

• Uploading Images
• Creating Cascading Stylesheet Files
• Uploading Static Files
• Adding an Image as an Application Logo
• Adding a Reference to a Javascript File

Session 6: PAGES AND REGIONS

• View Page Attributes in Page Designer
• Edit Page Attributes in Page Designer
• Create a Global Page
• Create a New Region
• View Region Attributes
• Add Comments
• Add a Title
• Add a logo

Session 7: CREATE FORMS

• Web Form Behaviour in APEX
• Create a Form Based on a Table
• Create a Form Based on a Procedure
• Create a Form with a Report
• Create a Tabular Form
• Create an Editable Interactive Grid
• Format a Form
• Locking in APEX Forms

Session 8: CREATING LISTS OF VALUES

• Overview of Application Express Shared Components
• 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 9: ITEMS AND BUTTONS

• Understand the Different Types of Items
• Create Page Items
• Create Application Items
• Understand and Edit Item Attributes in Page Designer
• Use Javascript with Item
• Create and Edit Buttons

Session 10: PAGE PROCESSING

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

Session 11: SHARED COMPONENTS

• Overview of Application Express Navigation Components
• Manage the Navigation Menu
• Create Navigation Bar Entries
• Manage Breadcrumbs
• Create and Use Lists and List Items
• Creating and using Shortcuts

Session 12: DISPLAY DYNAMIC CONTENT

• Create Hierarchical Trees
• Creating and editing Charts
• Creating and editing Calendars

Session 13: 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
• Enabling Feedback
• Managing Feedback and Team Development

Session 14: THEMES AND TEMPLATES

• Switch to a Different Theme
• View Existing Templates
• Understand and Manage Templates
• Create a new Template
• Add References to Cascading Stylesheet and Javascript Files

Session 15: DYNAMIC ACTIONS AND PLUG-IN COMPONENTS

• Identify Plug-in Components and their Types
• Plug In a Component
• Create Dynamic Actions
• Use a Plug-in in a Dynamic Action

Session 16: BUILDING WEBSHEET APPLICATIONS

• Websheet Applications and their Components
• Create a Websheet Application
• Enable SQL and PL/SQL in a Websheet Application
• Add Sections and Pages to a Websheet Application
• Add Links on a Websheet Page
• Add a Data Grid to a Websheet Application
• Create SQL Reports ion Websheet Applications
• Add Annotations to a Websheet Application

Session 17: IMPLEMENTING SECURITY

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

Session 18: DEPLOY AN APPLICATION

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