Oracle Application Express 4 (APEX)

Course Contents - DAY 1Course 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
• Add Links to Reports
• Create a Link to a Printer-Friendly version of a Report
• Save and Print Reports in Different Formats

• 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

• 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

• 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

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

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

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

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

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

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

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

• 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

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

• 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

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

• 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

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