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.
Joe Celko's SQL Puzzles and Answers, Second Edition, Seco...
and over 1.5 million other books are available for Amazon Kindle . Learn more
| ||||||||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details. Learn more. |
|
There is a newer edition of this item:
|
Book Description
Product details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, and more.
Product Description
Review
"This little collection of puzzles is something to bash your head against while awaiting your SQL epiphany." - Joe Celko
About the Author
Joe Celko is a noted consultant, lecturer, teacher, and one of the most-read SQL authors in the world. He is well known for his ten years of service on the ANSI SQL standards committee, his dependable help on assorted SQL newsgroups, his column in Intelligent Enterprise (which won several Reader's Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celko's SQL for Smarties: Advanced SQL Programming, Joe Celko's SQL Puzzles and Answers, Joe Celko's Trees and Hierarchies in SQL for Smarties, and Joe Celko's SQL Style, all published by Morgan Kaufmann.
Inside This Book
(Learn More)
First Sentence
"WHEN SOMEONE GETS an SQL problem, the first thing they do is try to think of a query to answer it." Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
"WHEN SOMEONE GETS an SQL problem, the first thing they do is try to think of a query to answer it." Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
3.6 out of 5 stars
12 reviews
27 of 28 people found the following review helpful
4.0 out of 5 stars
Good puzzles, answers could be better
11 July 2000
By Lex van de Pol
- Published on Amazon.com
Format:Paperback
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.
28 of 30 people found the following review helpful
5.0 out of 5 stars
The practical application of the SQL for Smarties concepts
20 Sep 1999
By Kenneth W. Henderson
- Published on Amazon.com
Format:Paperback
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.
10 of 10 people found the following review helpful
4.0 out of 5 stars
Good material but where is the source code?
10 July 2003
By appletizer
- Published on Amazon.com
Format:Paperback
I have been working with SQL professionally for about 5 years and I was looking for a collection of elegant SQL code tips and techniques from the pros to add to my arsenal. So I eagerly bought SQL Puzzles and Answers a few weeks ago and read it from cover to cover.
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.
›
Go to Amazon.com to see all 12 reviews
3.6 out of 5 stars
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Computer Science > Information Systems > Information Retrieval
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > SQL
- Books > Computing & Internet > Networking & Security > Security > Cryptography & Encryption
- Books > Computing & Internet > Programming > Languages > Fortran
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
