SQL / Database Design

Effective SQL

Posted April 29, 2016 By jviescas
Effective SQL
John L. Viescas
Douglas Steele
Ben Clothier
ISBN No. 0-134-57889-9
This advanced book teaches you 61 ways to write Effective SQL. The chapters cover everything from an overview of database design to dealing with hierarchical data.

Available NOW!

SQL Queries for Mere Mortals, 2nd Edition

Posted April 22, 2011 By Mike
SQL Queries for Mere Mortals, 3nd Edition
John L. Viescas
Michael J. Hernandez
ISBN No. 0-321-99247-4
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 third edition has been thoroughly revised, with three new “advanced” chapters on “NOT” and “AND” Problems, Condition Testing, and Unlinked and “Driver” Tables. The sample databases are provided as SQL scripts, SQL Server 2012 databases, Microsoft Access 2007 databases, and MySQL databases and scripts. You can download the sample files from: http://www.informit.com/store/sql-queries-for-mere-mortals-a-hands-on-guide-to-data-9780321992475.

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.

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.

Joe Celko’s SQL Puzzles and Answers

Posted April 10, 2011 By Mike

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.

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.

Relational Database Design Clearly Explained

Posted April 6, 2011 By Mike

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.

Handbook of Relational Database Design

Posted April 5, 2011 By Mike

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.