SQL / Database Design

Effective SQL

Posted April 29, 2016 By jviescas
icon
icon

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, 4th Edition

Posted April 22, 2011 By Mike
icon
icon

SQL Queries for Mere Mortals, 4th Edition
John L. Viescas
ISBN 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 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 fourth edition has been thoroughly revised, with two new “advanced” chapters on grouping (using ROLLUP, CUBE, and GROUPING SETS) and partitioning your data into Windows. The sample databases are provided as SQL scripts, SQL Server 2016 databases, Microsoft Access 2016 databases, and MySQL and PostgreSQL scripts. You can download the sample files from: http://www.informit.com/title/9780134858333.

icon
icon

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 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 Third 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
icon
icon

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