Oracle Application Express: Developing Web Applications

What you will learn:

Audience:

• Application Developers
• Developer
• Forms Developer
• PL/SQL Developer
• Reports Developer
• Business Analysts

Prerequisites:

Required Prerequisites:

• Basic knowledge of SQL, PL/SQL, and HTML
• Oracle Database 11g: SQL Fundamentals I
• Oracle Database 11g: PL/SQL Fundamentals

Course Objectives:

• Login to Oracle Application Express
• Identify the Components of an Application
• Develop a database-centric Web application
• Manage database objects
• Build queries of database objects and incorporate in an application
• Build and Customize Interactive Reports
• Create Forms
• Utilize and Manage Shared Components in an Application
• Add Page Processing Components
• Deploy the Application as a Packaged Application
• Manage users and groups
• Manage Access Control by authorizing and authenticating users
• Administer Oracle Application Express Workspaces
• Load and Unload data or application components

Course Topics:

Introducing Oracle Application Express

• Explaining Oracle Application Express Concepts
• Identifying the Components of Oracle Application Express
• Explaining the Oracle Application Express architecture
• Creating a Workspace and a Workspace administrator user
• Installing and Running a Sample Application provided with Oracle Application Express
• Installing a Packaged Application
• Logging in to an Oracle Application Express Workspace

Interacting with the Database by Using SQL Workshop

• Browsing, Creating, and Modifying Objects
• Processing Ad Hoc SQL Statements
• Managing SQL Scripts
• Creating, Running, and Saving SQL Queries

Building an Application

• Identifying the Components of an Application
• Creating an Application from Scratch
• Creating an Application from a Spreadsheet

Creating Reports

• Identifying Report Types
• Creating Interactive Reports
• Generating Reports Using Wizards
• Manipulating your Interactive Report
• Customizing your Interactive Report

Creating Forms

• Identifying the types of Forms
• Creating a Form on a Table with Report
• Creating a Tabular Form
• Creating a Master Detail Form
• Editing Form Attributes

Working with Pages and Regions

• Viewing Page Definitions
• Editing Page Attributes
• Creating a New Region
• Viewing Region Attributes
• Adding Comments

Adding Items and Buttons

• Creating Items
• Editing Item Attributes
• Creating Buttons
• Editing Button Attributes

Understanding Session State and Debugging

• Implementing Session State
• Setting a Session State Value
• Clearing the Session State
• Reviewing the Session State
• Reviewing the Messages in Session State

Including Page Processing

• Explaining the Difference Between Page Rendering and Page Processing
• Creating Computations for your Application
• Validating Input Data
• Process Data
• Creating Application Branching

Adding Shared Components That Aid Navigation

• Providing an Overview of Shared Components
• Managing Parent and Standard Tabs
• Managing Navigation Bars
• Managing Lists
• Managing Breadcrumbs

Adding Other Shared Components

• Including List of Values in your Application
• Creating Trees
• Accessing Shared Component Reports
• Setting User Interface Defaults

Displaying Dynamic Content

• Filtering Reports Using Dynamic Queries
• Creating Charts Using a Wizard
• Creating a Calendar

Working with Themes and Templates

• Explaining Themes and Templates
• Switching to a Different Theme
• Creating a Custom Theme
• Viewing Existing Templates
• Creating and Editing a Template
• Referencing a Cascading Style Sheet
• Changing a Filed to Use a Class in the Referencing style sheet

Administering Oracle Application Express Workspaces

• Managing Users
• Requesting a Schema or Storage
• Purging Session State
• Monitoring Developer Activity Log
• Monitoring Workspace Activity
• Viewing Activity Reports

Implementing Security

• Differentiating Between Authentication and Authorization
• Providing an Authentication Scheme
• Creating an Authorization Scheme Using Access Control
• Enabling and Configuring Session State Protection

Deploying Your Application

• Defining Supporting Objects
• Exporting Your Application
• Importing Your Application
• Installing Supporting Objects

Using Utilities

• Importing and Exporting Data
• Generating Data Definition Language (DDL) Statements
• Viewing Object Reports
• Viewing the Data Dictionary
• Monitoring the Database