- Series: The Morgan Kaufmann Series in Data Management Systems
- Paperback: 200 pages
- Publisher: Morgan Kaufmann; 1 edition (March 15, 1997)
- Language: English
- ISBN-10: 1558604537
- ISBN-13: 978-1558604537
- Product Dimensions: 0.8 x 7.2 x 9.2 inches
- Shipping Weight: 15.2 ounces (View shipping rates and policies)
- Average Customer Review: 14 customer reviews
- Amazon Best Sellers Rank: #2,103,354 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
There is a newer edition of this item:
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
Customers who bought this item also bought
"This little collection of puzzles is something to bash your head against while awaiting your SQL epiphany."
From the Back Cover
"This little collection of puzzles is something to bash your head against while awaiting your SQL epiphany." --Joe Celko
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
This omission drops my grade a full 2 stars from 4-star to 2-star.
The problems in the book look very much like typical problems that I have to solve at work every day. Any mid-level SQL developer could probably write a book of the same kind and usefullness by just logging every problem they solved at work for a period of a year. For this reason, if you did a lot of SQL work, you won't find anything useful in this book.
If I am presented a puzzle, I expect it to look impossible to solve at first, and once you get on track of finding a solution, solving it would turn out to be a lot of fun. The "puzzles" in this book are not like that.
As other reviewers already noted, the answers are a bit disappointing, too. I sent the book back to Amazon within a day. I'd rather spend $5 on return shipping than $30 on a worthless book.
This book is for all of them who enjoy little puzzles or just something which gives them challenge. Some puzzles took hours to solve and some were straight forward. This book teaches you some basic principles and patterns as well satisfy your need for brain teasers.
This book for all the SQL programmers regardless of database language you prefer. Book contains examples in different languages (SQL Server, Oracle, Sybase, Informix etc). If reader is absolute beginner this book is not what reader needs to start. This book is perfect for someone who has industry experience or has deep understanding of different SQL concepts.
This book contains 75 different puzzles. Each puzzle starts with puzzle definition or question and follows by multiple answers. Answers vary by either techniques or programming languages, in many cases both. Puzzles contained in this book are like typical day to day work problems, many time any developer can find the solution if they spend some time on it. However, some problems are quite unique in their own way and reading them gives broader idea of database programming.
One thing I will note about book is the quality of the puzzle, as other reviewer has noted some puzzles are just not puzzle but simple problems which can be solved easily by experienced developer. Not all developers are on same level and I am sure every reader has their own opinion and choice.
The idea on which the book is written is very simple - "Think out of the box". The problems are real, the solutions are real and multiple answers from wide verity of participants - this makes this book worth the time. Every solution has its own flair and taste. If any problem is attempted with right technique and sound theory it is always easy to reach resolution.
There is no source code available to download for this book so reader will have to write everything by their own. It is good in one way as ideally all readers should try to solve each puzzles by their own, however, source code will sure help many ways.
Rating: 4 Stars
Summary: I think this book should be there available for every database developer who has reached advanced level. If developer can solve most of the puzzles from this book he sure is advanced level developer, if not while trying to solve them he will reach advanced level.
Principal Database Administrator
The book essentially introduces the reader to the "thinking out of the box" approach to solving difficult SQL problems. The author walks us through the logic behind solutions of a collection of SQL puzzles that were submitted by readers of his magazine columns over the years. He demonstrates that there are numerous ways to solve SQL problems and that sometimes the solution lies right in the design of the base tables. But more importantly he helps the reader see that you can often solve seemingly unsolvable sql problems if you approach the problem with the right technique.
My one complaint is that the book does not come with turnkey source code files and they are not available for download. So the reader will have to type everything to test the solutions solutions that are presented.
Short of this there is plenty to learn here for the SQL programmer that wishes to pick up a few tricks of the trade from a pro.
A stellar book for instruction is SQL, as not only do the problems teach about how to solve SQL problems correctly, but many of the problems are quite difficult, providing for major mind expanding opportunities.
Definitely worth the money if you have an SQL package to attempt to solve the problems with.