Reference
Books
Database System Concepts by Abraham Silberschatz, Henry F. Korth and S. Sudarshan
Relational Database Design Clearly Explained by Jan L. Harrington
Database Systems: A Practical Approach to Design, Implementation and Management by Thomas M. Connolly and Carolyn E. Begg
Head First SQL: Your Brain on SQL - A Learner's Guide by Lynn Beighley
Database Design for Mere Mortals by Michael J. Hernandez
Beginning Database Design: From Novice to Professional by Clare Churcher
Manuals
Web Tutorials
- Herong's Tutorial Notes on SQL
This free book is an excellent tutorial book for beginners. It is a collection of notes and sample codes written by the author while he was learning SQL himself. Topics include CREATE, cursor, data type, DATE, DBD, DBI, DELETE, deadlock, export, etc.
- A Gentle Introduction to SQL
Interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite and Access.
- SQL for Web Nerds
The well known SQL for web nerds book.
- Database Design
Database design with UML and SQL, 3rd edition
- An introduction to SQL
An under construction - but good enough - tutorial about database.
- Database Design and Modeling Fundamentals
This article covers the basics of database design including normalization, relationships and cardinality. A great tutorial on database design.
- Relational Database Design
This tutorial teaches the basics of relational database design. Along the way, SQL tips and best practices will also be shown and explained. In addition, you will be introduced to important database terminology.
- Fundamentals of Relational Database Design
This paper was part of a presentation at a Microsoft TechEd conference in the mid 1990s. While the paper uses Microsoft Access (version 2) for the examples, the vast majority of the discussion applies to any database and holds up pretty well over 11 years after it was written.
