Oracle HTML DB 2.0: Develop Web Applications

What you will learn

This course is centred around building an Order-Entry application using HTML DB 2.0 now known as Oracle Application Express.

This course provides an overview of the architecture and the various features in Oracle HTML DB 2.0. Become skilled in developing database-centric Web application-using features such as reports, forms, items and buttons including page processing. You also learn about workspace administration and security implementation through authorization and authentication schemes. In addition, you learn how to set and clear session state. Give yourself and your organization a competitive edge.

  • Discuss the Oracle HTML DB architecture
  • Build a database-centric Web application using the Application Builder
  • Set and clear session states
  • Import and export data using SQL Workshop
  • Manage database objects using SQL Workshop
  • Authorize and authenticate users
Audience
 Database Administrators
PL/SQL Developer

Prerequisites
 Basic knowledge of SQL, PL/SQL, and HTML

Course Objectives
 Discuss the Oracle HTML DB architecture
Build a database-centric Web application using the Application Builder
Set and clear session states
Import and export data using SQL Workshop
Manage database objects using SQL Workshop
Authorize and authenticate users
Administer the Oracle HTML DB Workspace

Course Topics
Introducing Oracle HTML DB
 Understand HTML DB architecture
Identify the advantages of using Oracle HTML DB to build applications
List the key features of Oracle HTML DB
Login to their workspace
Install and run a sample application

Building an Application
 Navigate through the common User Interface components
Understand the Application Builder terminology and components
Create applications from scratch
Create a table and an application using Spreadsheet data

Creating Forms and Reports
 Create a Report Using a Wizard
Edit Report Attributes
Export a Report as a CSV or XML file
Create a Report Linked to a Form
Create a Tabular Form
Build a Master Detail Form

Adding Pages and Regions
 View page definition
Edit page attributes
Create a new region
View region attributes
Use the Developer Toolbar

Adding Items and Buttons
 Create a new Item
Edit the attributes of items
Create buttons
Edit the attributes of a button

Understanding Session State
 Assign Session ID
View Session State
Reference Item values and getting Session State
Set the Session State
Clear Session State Values from the URL
Clear the Cache

Including Page Processing
 Create an "on Page Rendering" Computation
Associate a Condition with Computation
Create an "on Submit" Computation
Create an "on Submit" Process
Create a New Validation
Create New Branching

Adding Shared Components That Aid Navigation
 Create Parent and Standard Tabs
Add Parent and Standard Tabs
Create a Navigation Bar
Create Lists
Create a List Region
Create Breadcrumbs

Adding Other Shared Components
 Create Static LOVs
Create Dynamic LOVs
Associate LOVs with Items
Create Trees

Displaying Dynamic Content
 Filter Reports by Using Dynamic Queries
Create an SVG Chart
View Chart Attributes
Create a Calendar

Working with Themes and Templates
 View existing templates
Edit templates
Create template
Create a New Theme

Administering Oracle HTML DB Workspaces
 Request a Workspace
Define Roles
Create a New User
Manage Environment Settings
Manage Session State
Purge Preferences for a User
View Database Privileges Granted to Workspace Schemas

Implementing Security and Deploying the Application
 Session state authentication
Establish User Identity Through Authentication
Create a New Authentication Scheme
Create a New Authorization Scheme
Deploy Your Application by Using Oracle HTML DB Utilities
Export Your Application
Import Your Application
Install the Application

Interacting With The Database Using SQL Workshop
 Use Object Browser to browse, create, and edit objects in the schema
Use Query Builder to build SQL queries, search and filter database objects, select objects and columns, create relationships between objects, view formatted query results and save them
Use SQL Script Repository to list all SQL scripts in the SQL Script repository
Use Utilities to import and export data
Generate DDL
Browse the Data Dictionary
Query Data Dictionary

New features in HTML DB 2.0
Advanced Features of Oracle HTML DB
How to Create a Feedback Application