Joe Celko's SQL Puzzles and Answers, Second Edition, Seco... and over 360,000 other books are available for Amazon Kindle – Amazon’s new wireless reading device. Learn more

31 used & new from $5.07

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.
 
  

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

~ (Author) "WHEN SOMEONE GETS an SQL problem, the first thing they do is try to think of a query to answer it..." (more)
Key Phrases: first working table, instantaneous count, assistant mechanic, Richard Romley, Friends of Pepperoni, Gupta Forum (more...)
3.6 out of 5 stars  See all reviews (13 customer reviews)


Available from these sellers.


11 new from $8.88 20 used from $5.07

Formats

Amazon Price New from Used from
  Kindle Edition, March 1, 1997 $31.29 -- --
  Paperback, October 4, 2006 $39.11 $29.00 $34.00
  Paperback, March 15, 1997 -- $8.88 $5.07
What Do Customers Ultimately Buy After Viewing This Item?

Customers Who Bought This Item Also Bought

Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko
4.1 out of 5 stars (49)  $38.40
Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's Trees and Hierarchies in SQL for Smarties, (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko
3.5 out of 5 stars (6)  $31.68
Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko
2.7 out of 5 stars (7)  $23.36
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems)

by Joe Celko
3.9 out of 5 stars (8)  $28.11
Joe Celko's Analytics and OLAP in SQL (The Morgan Kaufmann Series in Data Management Systems)

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

by Joe Celko
4.0 out of 5 stars (3)  $35.68
Explore similar items

Editorial Reviews

Review

“This little collection of puzzles is something to bash your head against while awaiting your SQL epiphany.”
—Joe Celko -- Review


Review

"This little collection of puzzles is something to bash your head against while awaiting your SQL epiphany."
—Joe Celko

Product Details

  • Paperback: 200 pages
  • Publisher: Morgan Kaufmann; 1st edition (March 15, 1997)
  • Language: English
  • ISBN-10: 1558604537
  • ISBN-13: 978-1558604537
  • Product Dimensions: 8.9 x 7.1 x 0.6 inches
  • Shipping Weight: 15.2 ounces
  • Average Customer Review: 3.6 out of 5 stars  See all reviews (13 customer reviews)
  • Amazon.com Sales Rank: #997,642 in Books (See Bestsellers in Books)

More About the Author

Joe Celko
Discover books, learn about writers, read author blogs, and more.

Visit Amazon's Joe Celko Page

Inside This Book (learn more)




Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(1)

Your tags: Add your first tag
 

 

Customer Reviews

13 Reviews
5 star:
 (3)
4 star:
 (6)
3 star:
 (2)
2 star:    (0)
1 star:
 (2)
 
 
 
 
 
Average Customer Review
3.6 out of 5 stars (13 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
23 of 23 people found the following review helpful:
4.0 out of 5 stars Good puzzles, answers could be better, July 11, 2000
By Lex van de Pol (Tilburg Netherlands) - See all my reviews
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
26 of 28 people found the following review helpful:
5.0 out of 5 stars The practical application of the SQL for Smarties concepts, September 20, 1999
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.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
17 of 18 people found the following review helpful:
3.0 out of 5 stars I love the puzzle approach to this topic., February 28, 2001
One of the few puzzle books for IRM types. Joe's book is based on his columns in the now defunct Database Programming and Design magazine. Overall this is an excellent book if you work with SQL on a daily basis. I'd give it a 5 rating, but it's overdue for an update due to the fact that many, including Joe himself, have developed even better answers for the puzzles.

This is not an introductory text -- you should have not only a knowlege of SQL but some real world experience developing and deploying SQL based applications.

To get the most out of this book, make sure you make an attempt to solve the puzzles before reading the 'answers'.

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

4.0 out of 5 stars A Book for Advanced Database Developer - Review of Database Administrator SQLAuthority.com
Short Review:
This book is for all of them who enjoy little puzzles or just something which gives them challenge. Read more
Published 20 months ago by Pinalkumar Dave

5.0 out of 5 stars 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... Read more
Published on October 16, 2007 by Olinto Rodriguez

1.0 out of 5 stars SQL Noise
I agree with "online shopper"; these puzzles do not present anything out of the ordinary for a day-to-day SQL programmer. Read more
Published on May 16, 2007 by Edward L. Bunt

4.0 out of 5 stars Will reinforce your knowledge of SQL.
This book is for a typical sql programmer. Some puzzles took me hours of fun trying to solve them on my own. Read more
Published on November 12, 2006 by A. Gaspar

1.0 out of 5 stars Who said "puzzles"? ;-)
A marketing slogan at the back of the cover says "This little collection of puzzles is something to bash your head against while waiting your SQL epiphany". Read more
Published on February 16, 2006 by online shopper

4.0 out of 5 stars Good material but where is the source code?
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. Read more
Published on July 10, 2003 by appletizer

3.0 out of 5 stars I love the puzzle approach to this topic.
One of the few puzzle books for IRM types. Joe's book is based on his columns in the now defunct Database Programming and Design magazine. Read more
Published on February 28, 2001 by Karen Lopez - infoadvisors.com

5.0 out of 5 stars 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.
Published on January 6, 2001 by Paul Pope

4.0 out of 5 stars 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. Read more
Published on January 6, 2000 by Örjan Lundberg

4.0 out of 5 stars An excellent mind bending collection of SQL problems
This book contains a set of problems to be solved using SQL, and the problems are such that they make the reader think of SQL and use it in a set based manner as opposed to mixing... Read more
Published on December 2, 1999 by indanthrene

Only search this product's reviews



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
   



So You'd Like to...


Create a guide

Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Look for Similar Items by Subject

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.



Your Recent History

 (What's this?)

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.