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

    Wikipedia on normalisation
SQL tutorial - good for newbies 
Database design summary from Wikipedia       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

   

Joins
for the mathematically minded


Join basics  from Wikipedia
Primer on normalisation  

Data models - huge collection

  Common Queries
from Artful Software Development

 

 


 

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 & Up