Start reading Joe Celko's SQL Puzzles and Answers, Second Edition on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

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) [Kindle Edition]

Joe Celko

Print List Price: £40.99
Kindle Price: £34.86 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £6.13 (15%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition £34.86  
Paperback £36.70  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.


Product Description

Review

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

Product Description

In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzles—and then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but help develop the mindset needed to solve the many difficult SQL puzzles you face every day. Of course, part of the fun is to see whether or not you can write better solutions than Joe’s.

* A great collection of tricky SQL puzzles with a variety of solutions and explanations.

* Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems.

* New edition features:
— Many new puzzles added!
— Dozens of new solutions to puzzles, and using features in SQL-99
— Code is edited to conform to SQL STYLE rules
— New chapter on temporal query puzzles
— New chapter on common misconceptions about SQL and RDBMS that leads to problems

Product details

  • Format: Kindle Edition
  • File Size: 2085 KB
  • Print Length: 352 pages
  • Publisher: Morgan Kaufmann; 2 edition (9 Oct 2006)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B0014AG7S4
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Amazon Bestsellers Rank: #662,195 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Author

Discover books, learn about writers, and more.

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.
11 of 11 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.
5 of 5 people found the following review helpful
2.0 out of 5 stars Interesting book, but how hard would it have been to include the source code? 9 Mar 2011
By Earl K. Takasaki - Published on Amazon.com
Format:Paperback|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.
6 of 7 people found the following review helpful
4.0 out of 5 stars An excellent mind bending collection of SQL problems 2 Dec 1999
By Amazon Customer - Published on Amazon.com
Format:Paperback
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.
Were these reviews helpful?   Let us know

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
   


Look for similar items by category