Cider - Shop now
Buy new:
-61% $19.10
FREE delivery May 16 - 21 to Nashville 37217
Ships from: PRIME-BOOKS
Sold by: PRIME-BOOKS
$19.10 with 61 percent savings
List Price: $48.95
FREE delivery May 16 - 21 to Nashville 37217. Details
Or fastest delivery May 15 - 19. Details
In stock
Usually ships within 3 to 4 days.
$$19.10 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$19.10
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
PRIME-BOOKS
PRIME-BOOKS
Ships from
PRIME-BOOKS
Returns
30-day refund/replacement
30-day refund/replacement
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt. You may receive a partial or no refund on used, damaged or materially different returns.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
$3.16
$3.99 delivery Thursday, May 15 to Nashville 37217. Details
Only 1 left in stock - order soon.
$$19.10 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$19.10
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Ships from and sold by Valleys Books & More.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the author

Joe Celko
Follow
Something went wrong. Please try your request again later.

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

by Joe Celko (Author)
2.4 out of 5 stars 8 ratings
{"desktop_buybox_group_1":[{"displayPrice":"$19.10","priceAmount":19.10,"currencySymbol":"$","integerValue":"19","decimalSeparator":".","fractionalValue":"10","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"jjRNf2gUJg7jpEO9ohPqm4XSLrEfJfksLj%2B2A68H807Q7gM1Olt5VguE255kSKNQ5YzHQEsRCc78Ra41bcb40TdZb7gIVIG3iBmvxeDjkDQMfNqDgG9%2BZRsLQ%2Fpia39jZtxJAHtcrEwu9kNLvrLbTrrOMDHo9ZV9EZBKdbXwlJO3SArX0aTnqcOiIEJDk3t5","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$3.16","priceAmount":3.16,"currencySymbol":"$","integerValue":"3","decimalSeparator":".","fractionalValue":"16","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"jjRNf2gUJg7jpEO9ohPqm4XSLrEfJfksS2tyRarXFsXyOg3AyFL4RhYHszCcNUy%2FdILEVb44sJ40ovv99Q0gtB0dvEqXLW%2F1F%2B%2Bbo3Aeva3m8Ij7TkKT%2FJ8JLVZgEvSPBM%2Bzd0OAoVwmYuGcriu%2FXWpscMZTWJgDAm1u74NyMBALaFvg0h%2B3XYEN8QVofG%2Bg","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

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.

Read more
Previous slide of product details
  1. ISBN-10
    9781558604537
  2. ISBN-13
    978-1558604537
  3. Edition
    1st
  4. Publisher
    Morgan Kaufmann
  5. Publication date
    March 15, 1997
  6. Language
    English
  7. Dimensions
    0.75 x 7.25 x 9.25 inches
  8. Print length
    200 pages
Next slide of product details

There is a newer edition of this item:

Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems)
Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems)
$40.65
(36)
Only 6 left in stock (more on the way).

Editorial Reviews

Review

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

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.

Product details

  • ASIN ‏ : ‎ 1558604537
  • Publisher ‏ : ‎ Morgan Kaufmann; 1st edition (March 15, 1997)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 200 pages
  • ISBN-10 ‏ : ‎ 9781558604537
  • ISBN-13 ‏ : ‎ 978-1558604537
  • Item Weight ‏ : ‎ 14.5 ounces
  • Dimensions ‏ : ‎ 0.75 x 7.25 x 9.25 inches
  • Customer Reviews:
    2.4 out of 5 stars 8 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.
Joe Celko

Joe Celko

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

I was a member of the ANSI X3H2 Database Standards Committee from 1987 to 1997 and helped write the ANSI/ISO SQL-89 and SQL-92 Standards. I have nine books and have written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

I live in Austin,TX. When I am not writing, I am consulting, speaking at conferences, teaching SQL training classes anywhere on Earth or beating up newbies in SQL Newsgroups.

The rumor that I own only one black suit that I have worn for 30 years is false; I own six identical black suits that I have worn for 30 years.

Customer reviews

2.4 out of 5 stars
8 global ratings

Review this product

Share your thoughts with other customers
Write a customer review

Top reviews from the United States

  • EKT from NYC
    2.0 out of 5 stars Interesting book, but how hard would it have been to include the source code?
    Reviewed in the United States on March 9, 2011
    Verified Purchase
    I just started reading this book and the puzzles are challenging and interesting. However, it would have been nice if someone would have taken the trouble to create sample database scripts, with sample data. That would make solving the puzzles much more fun and less labour intensive. A model for this would be the excellent websites where SQL problems are presented with table variables and a small script to create the table in both TSQL and Oracle.

    This omission drops my grade a full 2 stars from 4-star to 2-star.
    4 people found this helpful
    Helpful
     Report
  • online shopper
    1.0 out of 5 stars Who said "puzzles"? ;-)
    Reviewed in the United States on February 17, 2006
    Verified Purchase
    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". A little bit too promising.

    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.
    14 people found this helpful
    Helpful
     Report
  • LAnd
    4.0 out of 5 stars Good material but where is the source code?
    Reviewed in the United States on July 10, 2003
    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.
    13 people found this helpful
    Helpful
     Report
  • Kenneth W. Henderson
    5.0 out of 5 stars The practical application of the SQL for Smarties concepts
    Reviewed in the United States on 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.
    29 people found this helpful
    Helpful
     Report
  • Lex van de Pol
    4.0 out of 5 stars Good puzzles, answers could be better
    Reviewed in the United States on July 11, 2000
    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.
    29 people found this helpful
    Helpful
     Report
  • Örjan Lundberg
    4.0 out of 5 stars A very good tutorial to gain more SQL experience
    Reviewed in the United States on January 6, 2000
    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.
    You should have some SQL experience before trying this book.
    4 people found this helpful
    Helpful
     Report
  • Paul Pope
    5.0 out of 5 stars I had a ball!
    Reviewed in the United States on January 6, 2001
    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.
    8 people found this helpful
    Helpful
     Report
  • Amazon Customer
    4.0 out of 5 stars An excellent mind bending collection of SQL problems
    Reviewed in the United States on December 2, 1999
    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 in procedural techniques.
    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.
    6 people found this helpful
    Helpful
     Report