Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

Oracle Databases on the Web
Training Class

© 2007-2016 by Burleson Corporation

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

 

 

Key Features

* Learn fundamentals of the Web.

* Understand Oracle WebServer 1 Architecture.

* Create a home-page with HTML.

* Build the database interface.

* See new features of Web front-ends.

* Understand the role of replication.

* Learn about disk issues with distributed database performance.

  

Course Description

This is an intense two-day overview of Oracle databases on the web.  Topics center on HTML delivery and Oracle9iAS.

Book Recommended

  Oracle Application Server 10g Administration Handbook

Donald K. Burleson & John Garmany

Oracle Press - 2007

ISBN: 0072229586

Audience

This course is designed for the working Oracle professional and the amount of previous experience with Oracle is incidental.
Previous experience with relational database management and SQL is helpful, but this class is self-contained and has no formal prerequisites.

Curriculum Design

This course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Author of more than 20 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning.  Burleson has over a decade of real-world DBA experience in Oracle features and shares his Oracle secrets in this intense Oracle web  training.



Using Oracle databases on the Web
Syllabus

© 2007-2016 by Donald K. Burleson

 

DAY 1

Internet Basics / Fundamentals of WWW

How we got here.

What is it ?

Fundamentals of the Web.

Object technology - Database Evolution

Oracle WebServer Architecture

Oracle WebServer 1 Architecture

- What are the pieces ?

- How do they fit together ?

Oracle WebServer 2 Architecture

- What are the pieces ?

- How do they fit together ?

Developing Web Pages Using HTML

An overview of HTML with illustrative examples

Creating a home-page with HTML

The effective use of hypertext

Oracle’s WebServer Installation

Installation and Configuration

- Oracle Webserver 1

- Oracle Webserver 2

Getting started

Building the database interface

Web Listener

Construction of the listener

Managing WebServer Applications

New features of Web front-ends

The addition of windows constructs:

The new Web features include:

Using Frames

Using Tables

Hypertext links

Dynamic page generation

Hypertext linking

Clickable images and image maps (ISMAP)

Dynamic page generation

WebServer design

Designing organizational framework

Designing information groups

Organizing groups into hierarchies

Designing navigational pathways

Common Design flaws

Misuse of hypertext links and push buttons

Avioding the "lost in hyperspace" problem

Tracking Web pages access using WebServer logs

 

 

Oracle’s Common Gateway Interface

Communication Issues - Common Gateway Interface (CGI)

- Oracle Web Request Broker (WRB)

Oracle’s HTP Utilities

Introduction and overview

htp and htf calls

Oracle’s OWA Utilities

Introduction and overview

owa examples

 

DAY 2

Oracle and PL/SQL

Introduction and overview

htp and htf calls

Overview of htp functions

Overview of OWA utilities

Managing WebServer Forms

Retrieving individual rows

Retrieving lists from Oracle

Using check boxes

Using radio buttons

Using list of values (pop-up lists)

Updating Oracle

Using Image maps

Validating input data

WebServer/Oracle Application Navigation

Mapping the application flow

Using push buttons for flow control

Automatic return functions

Managing Oracle locks

Using SQL*Net for distributed communication

Using distributed Oracle queries

 

Oracle Database Design for Web Access

An overview of normalization theory

Where theory meets reality - real-world database design

Denormalizing for performance

Star schema techniques for warehouse Web databases

Proper index usage

Referential integrity and performance

Using database triggers

Using stored procedures

Database design for Distributed Web applications

Introduction

The economics of distributed databases

Human factors in distributed database design

Distributed design example

 

Performance and tuning for distributed Web databases

Introduction

Overview of distributed data

The role of replication

Multi-tasking and multi-threading

I/O-based tuning

Memory-based tuning

System-based tuning

Tuning distributed SQL

Planning for growth

Disk issues with distributed database performance

Summary

 

Tuning Web-based Oracle SQL

ANSI SQL overview

An overview of Oracle SQL

OLTP Web databases

Oracle's SQL extensions and their effect on performance

The SQL Optimizers - Cost vs. Rule based optimization

Using the EXPLAIN plan

Using "hints" to improve performance

Dealing with outer joins

Complex joins

Dealing with nullable foreign keys

Using the IN clause

Correlated and non-correlated subqueries

Data Warehouse queries on the Web

The data warehouse evolution

Multidimensional databases and the Web

Relational warehouses

STAR schema design and query

Tuning techniques for relational warehouses.

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational