Oracle Databases on
the Web
Training Class
© 2007-2009
by Burleson Consulting
* 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.
|
|
This is an intense two-day overview of Oracle databases on
the web. Topics center on HTML delivery and
Oracle9iAS.
 |
|
Oracle Application Server 10g Administration
Handbook
Donald K. Burleson & John
Garmany
Oracle Press -
2007
ISBN: 0072229586
|
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.
|
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-2009 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.
|
