Joe Celko's SQL Puzzles and Answers, Second Edition, Seco... and over one million other books are available for Amazon Kindle . Learn more

Have one to sell? Sell yours here
Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems)
 
 
Start reading Joe Celko's SQL Puzzles and Answers, Second Edition, Seco... on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

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

Joe Celko


Available from these sellers.


Formats

Amazon Price New from Used from
Kindle Edition £27.78  
Paperback £37.04  
Paperback, 5 Aug 1997 --  
Amazon.co.uk Trade-In Store
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:
Joe Celko's SQL Puzzles and Answers, Second Edition (The Morgan Kaufmann Series in Data Management Systems) Joe Celko's SQL Puzzles and Answers, Second Edition (The Morgan Kaufmann Series in Data Management Systems)
£37.04
In stock.


Product details


More About the Author

Joe Celko
Discover books, learn about writers, and more.

Visit Amazon's Joe Celko Page

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
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

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)
 
(5)
(1)

Your tags: Add your first tag
 


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
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
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
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.


Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!

Create a Listmania! list

Look for similar items by category


Look for similar items by subject


Feedback