Category Archives: SQL / Database Design

SQL / Database Design

Effective SQL

      Comments Off on Effective SQL

Effective SQLJohn L. Viescas, Douglas Steele, Ben ClothierISBN 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, 4th Edition

      Comments Off on SQL Queries for Mere Mortals, 4th Edition

SQL Queries for Mere Mortals, 4th Edition John L. ViescasISBN No. 978-0134858333 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… Read more »

Database Design for Mere Mortals, Third Edition

      Comments Off on Database Design for Mere Mortals, Third Edition

Database Design for Mere Mortals, Third Edition Michael J. Hernandez ISBN No. 978-0321884497 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… Read more »

Joe Celko’s SQL for Smarties: Advanced SQL Programming

      Comments Off on 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… Read more »

Joe Celko’s SQL Puzzles and Answers

      Comments Off on Joe Celko’s SQL Puzzles and Answers

Joe Celko’s SQL Puzzles and Answers Joe CelkoISBN 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

      Comments Off on Joe Celko’s Trees and Hierarchies in SQL for Smarties

Joe Celko’s Trees and Hierarchies in SQL for Smarties Joe CelkoISBN 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… Read more »

Relational Database Design Clearly Explained

      Comments Off on Relational Database Design Clearly Explained

Relational Database Design Clearly Explained Jan L. HarringtonISBN 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

      Comments Off on Handbook of Relational Database Design

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