Oracle HTML DB 2.0: Develop Web Applications

What you will learn:

• 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:

Required 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