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

  Wikipedia on normalisation 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  

Normalisation rules
at DataModel.org

 

Transact SQL guide
Microsoft Transact SQL guide

 

Join basics  from Wikipedia

Introduction to relational databases by Tore Bastrup  

Relational theory - account of relational theory for the mathematically minded

  Common Queries
from Artful Software Development
 

Joins - join basics for the mathematically minded

Excellent 5-part tutorial on MySQL joins
from Dev Shed

Primer on normalisation from the MySQL site

Data models - huge collection   Tutorial on joins from the MySQL manual

Return to the home of Get It Done with MySQL 5&6