Database Tutorials on the Web

Database Basics

 

Database design and Normalisation

 

SQL Guides

Introduction to databases
from Artful Software Development
  Ten steps to design a database
from Artful Software Development
 
 

Gentle introduction to SQL
very clear SQL step-by-step

Interactive introduction
from McMaster University
 
  Wikipedia on normalisation
SQL tutorial - good for newbies 
Database design summary from Wikipedia   Introduction to normalisation
from TechRepublic
  SQL statement syntax in MySQL

  Normalisation and decomposition
by Oscar Zaiane at SFU

SQL Articles at ONLamp
Database basics in 5 parts by Joe Burns   Relational theory
for the mathematically minded
 

Transact SQL guide

Introduction to relational databases by Tore Bastrup  

Joins
for the mathematically minded


Join basics  from Wikipedia
Primer on normalisation  

Data models - huge collection

  Common Queries
from Artful Software Development

 

 


Excellent 5-part tutorial on MySQL joins
from Dev Shed

Some database design rules of thumb


RDBMS genealogy   Tutorial on joins from the MySQL manual

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