introduction to Databases for web developers
Table of Contents
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
  • 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
  • Subquerries
  • 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
  •