- Paperback: 200 pages
- Publisher: Morgan Kaufmann Publishers In (5 Aug 1997)
- Language English
- ISBN-10: 1558604537
- ISBN-13: 978-1558604537
- Product Dimensions: 22.6 x 18 x 1.5 cm
-
Amazon Bestsellers Rank:
1,215,551 in Books (See Top 100 in Books)
- #21 in Books > Computers & Internet > Computer Science > Programming > Languages > Fortran
- See Complete Table of Contents
Joe Celko's SQL Puzzles and Answers, Second Edition, Seco...
and over one 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? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
|
There is a newer edition of this item:
|
Product details |
More About the Author
Product Description
Review
"This little collection of puzzles is something to bash your head against while awaiting your SQL epiphany." - Joe Celko
Product Description
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.
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
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
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:
12 reviews
26 of 27 people found the following review helpful
Good puzzles, answers could be better
11 July 2000
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
The practical application of the SQL for Smarties concepts
20 Sep 1999
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
Good material but where is the source code?
10 July 2003
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.
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
Look for similar items by subject
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.
