Oracle Application Express 5 (APEX)

Course Introduction

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

• 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

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

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

• 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

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

• 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

• 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
• Format a Form
• Locking in APEX Forms

• 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

• Understand the Different Types of Items
• Create Items
• Understand and Edit Item Attributes in Page Designer
• Use Javascript with Item
• Manipulate Items in Tabular Forms
• Add Dynamic Items to a Report
• Create and Edit Buttons

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

• Overview of Application Express Navigation Components
• Manage Parent and Standard Tabs
• Create Navigation Bar Entries
• Create and Use Lists and List Items
• Manage Breadcrumbs
• Shared Component Subscription
• User Interface defaults

• Filter Reports with Dynamic Queries
• Create Charts with a Wizard
• Format Charts
• Create Calendars
• Add Links to Calendars
• Create Hierarchical Trees

• 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

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

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

• 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

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

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