Database Tutorials on the Web

Basics of database design

 

Relational theory, database design and normalisation

 

SQL Guides

Interactive introduction
from McMaster University
 
  Ten steps to design a database
from Artful Software Development
 
  Gentle introduction to SQL - very clear SQL step-by-step
  Primer on Codd's 12 Rules from ITWorld SQL tutorial - good for newbies
 
Introduction to databases
from Artful Software Development
  Introduction to normalisation
from TechRepublic
  SQL statement syntax in MySQL
  Normalisation and decomposition
by Oscar Zaiane at SFU
SQL Articles at ONLamp
5-part primer on databases and SQL by Joe Burns   Join basics  from Wikipedia   Transact SQL guide - Microsoft Transact SQL guide
 

Relational theory - account of relational theory for the mathematically minded

Introduction to relational databases by Tore Bastrup  

Joins - join basics for the mathematically minded

  Common Queries
from Artful Software Development
 

Data models - huge collection

Excellent 5-part tutorial on MySQL joins
from Dev Shed

Primer on normalisation from the MySQL site

  Tutorial on joins from the MySQL manual

Return to the home of Get It Done with MySQL 5