SQL / Database Design

SQL Queries for Mere Mortals, 2nd Edition

SQL Queries for Mere Mortals, 2nd Edition
John L. Viescas
Michael J. Hernandez
ISBN No. 0-321-44443-4
CD Included with sample databases
Anyone who has to use a database system that supports SQL can use this book. As a beginning database user who has just discovered that the data you need is fetched using SQL, this book will teach you all the basics and more. For an expert user who is suddenly faced with solving complex problems or integrating multiple systems that support SQL, this book provides insights into leveraging the complex abilities of the SQL database language.

This second edition has been thoroughly revised, with new chapters on UPDATE, INSERT, and DELETE. The sample databases are provided as SQL scripts, SQL Server 2000 databases, Microsoft Access 2000 databases, and MySQL databases and scripts.

Posted in Books, SQL / Database Design | Comment

Database Design for Mere Mortals, Second Edition

Database Design for Mere Mortals, Second Edition
Michael J. Hernandez
ISBN No. 0-201-75284-0
An astonishing fresh approach to the ‘nasty’ task of relational database design. Mike uses a straightforward, no-nonsense technique that doesn’t get bogged down in incomprehensible mathematical rules or scientific jargon. Anyone who has anything to do with creating applications using a database product should buy this book and read it cover to cover. For novice readers, it will save hours of frustration trying to build something without a workable design. Even the most advanced database developers will find a new way to look at database design methodology — and perhaps find many of Mike’s ideas useful to make the task more interesting and palatable for others on their project teams.

The Second Edition has many new topics and has several major sections rewritten based on reader feedback.

Posted in Books, SQL / Database Design | Comment

Joe Celko’s SQL for Smarties: Advanced SQL Programming

Joe Celko’s SQL for Smarties: Advanced SQL Programming
Joe Celko
ISBN No. 1-558-60576-2
After you have moved beyond SQL for Mere Mortals, Joe Celko is the unquestioned expert to go to for advanced techniques. Be forewarned that the problems he presents are brain-twisters, and the solutions might not work in all “relational” database systems. Like Mere Mortals, all the solutions adhere to the adopted ANSI-SQL standard.

Posted in Books, SQL / Database Design | Comment

Joe Celko’s SQL Puzzles and Answers

Joe Celko’s SQL Puzzles and Answers
Joe Celko
ISBN No. 1-558-60453-7
Similar to SQL for Smarties, this book presents even more complex problems, a problem-solving approach, and the final solution. More of a “cookbook” and less of a “tutorial” than Smarties.

Posted in Books, SQL / Database Design | Comment

Joe Celko’s Trees and Hierarchies in SQL for Smarties

Joe Celko’s Trees and Hierarchies in SQL for Smarties
Joe Celko
ISBN No. 1558609202
The next step beyond SQL for Smarties

Joe Celko’s Trees and Hierarchies in SQL is an intermediate to advanced-level practitioners guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to representing trees and hierarchies and related topics that should be of interest to the working database programmer. These topics include hierarchical encoding schemes, graphs, IMS, binary trees, and more.

Posted in Books, SQL / Database Design | Comment

Relational Database Design Clearly Explained

Relational Database Design Clearly Explained
Jan L. Harrington
ISBN No. 0-12326-425-1
Another relatively simple and readable approach to database design. It’s a bit more academic than Mike’s book.

Posted in Books, SQL / Database Design | Comment

Handbook of Relational Database Design

Handbook of Relational Database Design
Candace C. Fleming, Barbara Vonhalle
ISBN No. 0-2011-1434-8
This is an old classic published in 1988. It’s not for the novice reader.

Posted in Books, SQL / Database Design | Comment