Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems)

By Joe Celko

Book Overview

Joe Celko challenges you with his trickiest puzzles and then helps you conquer them with a variety of solutions and explanations. The puzzles are a compilation from Joe's columns in DBMS and Database Programming & Design magazines. They include new, never-before-published puzzles plus new solutions and extra background for previously published puzzles. In his usual entertaining and informative style, Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective. Through the practical, enjoyable puzzles, he introduces immediately useful new techniques and applications for SQL programming, and shows the database programmer how to write and use non-procedural programs.

• Format: Paperback
• Language: English
• ISBN: 1558604537
• ISBN13: 9781558604537
• Release Date: March 1997
• Publisher: Morgan Kaufmann Publishers
• Length: 200 Pages
• Weight: 1.10 lbs.
• Dimensions: 0.6" x 7.1" x 9.0"

Customer Reviews

Rompecabezas!

Buen libro. Presenta retos difíciles de vencer. Ideas ingeniosas, útiles en el campo laboral. Requiere alto nivel técnico para su comprensión, pero al igual que los otros libros de Celko, es excelente.

I had a ball!

Great problems and amazing solutions. I'll probably never have to use a cursor again. I'm not lending my copy to anyone. They'll have to get their own.

Good puzzles, answers could be better

This is a very nice book! I used it to increase the SQL level of my employees. We did two puzzles a week, and compared our answers. And it sure helped. But there are some buts in this story. First, the puzzles are not always defined well, so you do not know what to do before you see the discussion in the answer part. Second, a lot of the solutions are not very good. Whenever I found a better one, I mailed Joe Celko. Every time he replied to me (very nice!) that somebody else also pointed it out and that there were even better solutions that mine. This means that the solutions are not always that good in the book. But still, it has alo of good brainteasers. But try them first yourself before looking to the answers as your answer could be better.

A very good tutorial to gain more SQL experience

This book gives you the opportunity to improve you SQL skills by solving the tricky puzzles. Celko's insightful solutions will provide you with a SQL gurus approaches.You should have some SQL experience before trying this book.

The practical application of the SQL for Smarties concepts

The hidden jewel of the Celko trilogy, this is one of my favorite SQL books. It takes the concepts in Celko's seminal work, SQL for Smarties, and illustrates how to apply them to solve real-world problems. As always, the book is rife with tales from Celko's long and varied career in the SQL trenches, as well as the subtle witticism for which he is famous. Like all great technical books - it's timeless - the techniques you learn today will work tomorrow because Celko follows the ANSI/ISO standard to the letter. As a fellow author, I can appreciate the work that went into writing this book - real examples require real work, especially by the author. This book belongs in the library of every would-be SQL practitioner.