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 |
|
|
|
Transact SQL guide
|
| Introduction to relational databases by Tore Bastrup |
|
Relational theory
for the mathematically minded |
|
Join basics from Wikipedia |
| Primer on normalisation from the MySQL site |
|
Joins
for the mathematically minded |
|
Common Queries
from Artful Software Development |
|
Some database design rules of thumb |
|
|
|
Excellent
5-part tutorial on MySQL joins from Dev Shed |
|
|
|
Data models - huge collection |
|
Tutorial
on joins
from the MySQL manual |