Introduction to Databases for the Web | Table of Contents

Basic URL: http://www.wdvl.com/Authoring/DB/Intro/toc.html

Selena Sol

• 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
• Retrieving Data
• Wildcards
• Where
• And, Or, and Not
• Between
• In
• Like
• Null
• Order by
• Performing math
• Maximums and Minimums
• Counting Records
• Distinct
• Averages
• Joins
• Subqueries
• Adding Data
• Modifying Data
• Deleting 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
• Intro to JDBC
• JDBC Application Environment Setup
• Using JDBC to Connect to a Database
• Using JDBC to Query a Database
• Using JDBC to Modify a Database
• More on JDBC
• JDBC by Example