Introduction to Databases for the Web | Table of Contents
November 23, 1998
- Part One: Basics
- What is a Database
- Types of Databases
- Analytic Databases
- Operational Databases
- Databases Models
- Hierarchical Databases
- Network Databases
- Relational Databases
- Client Server Databases
- Good Database Design
- Talking to a Database
- The Basics of the SQL Database
- Tables
- The Data Dictionary
- Views
- Basics of an SQL Query
- Data Types
- Logging on to the Database
- A Sample Database
- Creating Databases
- Creating Tables
- Deleting Databases and Dropping Tables
- Altering a Table
- Part Two: Retrieving and Manipulating Data
- Part Three: CGI Interfaces to SQL Databases
- Server Side Database Communication With CGI
- Chains of Communication
- Using Perl 5 and the DBI Module to Communicate With Databases
- The DBI Module
- The DBI API
- Getting the Pieces
- Installing Perl
- Installing a Web Server : Sambar
- Running CGI Applications on a Single Station Local Area Network
- Setting up a Sample Database
- Putting it all together with a DBI-Aware CGI Script
- Part Four: Java Database Connectivity
