See if you can solve them before checking on the answers. This article is excerpted from Joe Celko’s SQL Puzzles and Answers, Second. Joe Celko’s SQL Puzzles and Answers has 37 ratings and 1 review. Joe Celko challenges you with his trickiest puzzles and then helps you solve them with a. Publication: Cover Image. · Book. Joe Celko’s SQL Puzzles and Answers, Second Edition (The Morgan Kaufmann Series in Data Management Systems).
|Published (Last):||10 January 2005|
|PDF File Size:||15.76 Mb|
|ePub File Size:||8.44 Mb|
|Price:||Free* [*Free Regsitration Required]|
Joe Celko’s SQL Puzzles and Answers
Joe Celko’s SQL Puzzles and Answers, Second Editionchallenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations. Author Joe Celko 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 also help develop the mindset needed to solve the many difficult SQL puzzles you face every day. This updated edition features many new puzzles; dozens of new solutions to puzzles; and new chapters on temporal query puzzles and common misconceptions about SQL and RDBMS that leads to problems.
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.
In addition to updating the solutions for SQL Style and SQL and beyond standards, Joe has added many new puzzles, dozens of additional solutions, and new chapters. Joe Celko is a noted consultant, lecturer, teacher, and one of the most-read SQL authors in the world. Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support? This book is recommended for database programmers with a good knowledge of SQL. 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!
Read more Read less. Discover Prime Book Box for Kids. Add both to Cart Add both to List. These items are shipped from and sold by different sellers. Buy the selected items together This item: Ships from and sold by Amazon. Customers who bought this item also bought. Page 1 of 1 Start over Page 1 of 1. Elements of Programming Interviews in Python: Morgan Kaufmann; 2 edition October 5, Language: Try the Kindle edition and experience these great reading features: Share your thoughts with other customers.
Write a customer review. Read reviews that mention source code sql problems sql programmer puzzles solutions answers database celko puzzle solution collection solving techniques typical learn oracle presented solved.
Showing of 15 reviews. Top Reviews Most recent Top Reviews. There was a problem filtering reviews right now. Please try again later. There’s nothing else like this book on the market that I’ve seen. Great and interesting SQL challenges. 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. 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 aand 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. Kindle Edition Verified Purchase. I expected the SQL Puzzels to be database queries. This book is for all of them who enjoy little puzzles or just something which gives them challenge.
Some puzzles took hours to solve and some were straight forward. This book teaches you some basic principles and patterns as well satisfy your need for brain teasers. This book for all the SQL programmers regardless of database language you prefer.
If reader is absolute beginner this book is not what reader needs to start. This book is perfect for someone who has industry experience or has deep understanding of different SQL concepts. This book contains 75 different puzzles. Each puzzle starts with puzzle definition or question and follows by multiple answers. Answers vary by either techniques or programming languages, in many cases both. Puzzles contained in this book are like typical day to day work problems, many time any developer can find the solution if they spend some time on it.
However, some problems are quite unique in their own wnd and upzzles them gives broader idea of database programming.
There was a problem providing the content you requested
One thing I will note about book is the quality of the puzzle, as other reviewer has noted some puzzles are just not puzzle but simple problems which can be solved easily by experienced developer.
Not all developers are on same level and I am sure every reader has their own opinion and choice. The idea on which the book is written is very sq, – “Think out of the box”. The problems puzzlds real, the solutions are real and multiple answers from wide verity of participants – this makes this book worth the time.
Every solution has its own flair and taste. If any problem is attempted with right technique and sound theory it is always easy to reach resolution. There is no source code available to download for this book so reader will have to write everything by their own. It puzzes good in one way as ideally all readers should try to solve each puzzles by their own, however, source code will sure help many ways. I think this book should ;uzzles there available for every database developer who has reached advanced level.
Joe Celko’s SQL Puzzles and Answers : Joe Celko :
If developer can solve most of the puzzles from this book he sure is advanced level developer, if not while trying to solve them he will reach advanced level. Pinal Dave Principal Database Administrator blog. Nad 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.
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. 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! 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.
See all 15 reviews. Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway. Set up a giveaway. Customers who viewed this item also viewed. Joe Celko’s Thinking in Sets: Pages with related products. See and discover other items: