Download Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems)
Thanks for visiting one of the most finished and also updated site that bring numerous publication checklists. This is what you can consider obtaining guide as the recommendation for you in doing the discussion to really feel much better. The book that becomes recommendation to check out now is Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) This is just one of guides that we list as one part of the terrific numerous publications from around the world. So, when you discover and look the book titles below, it will certainly be from many nations on the planet. So, it's so finished, right?
Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems)
Download Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems)
An option to obtain the problem off, have you discovered it? Actually? What kind of option do you deal with the problem? From what sources? Well, there are a lot of inquiries that we utter on a daily basis. Regardless of how you will certainly get the remedy, it will certainly indicate better. You can take the recommendation from some books. And also the Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) is one book that we truly advise you to check out, to obtain more services in resolving this issue.
Spare time becomes a very precious time for many people. This is the time to lose all weary, tired, as well as bored works or responsibilities. Nonetheless, having too very long time will make you really feel bored. In addition, you will certainly feel that so when you have no activities. To deal with the little issue, we reveal a book Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) that can be a way to accompany you while remaining in the free time. It can be checking out product, not as the pillow naturally.
One of motivating reasons that you could preferred to get this publication is since this is extremely appropriate to the problem that you deal with currently. The condition is not just for you that are not afraid to obtain brand-new thing, for you who always feel that you require brand-new sources to earn better life. And this book is very appropriate to review also in just short leisure time. Yeah, with the soft documents of Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems), you could take easy to continuously check out as well as read this book again.
Really, this is not a force for you to love this book as well as review until finish this publication. We reveal you the excellent book. It will certainly be so pity if you miss it. This is not the correct time for you to miss the Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) not to read. It could help you not only fulfilling this vacation times. After vacations, you will obtain something new. Yeah, this book will actually lead you to life much better. This is why; this recommended book is much said for you who wish to move on constantly.
Review
"This little collection of puzzles is something to bash your head against while awaiting your SQL epiphany." —Joe Celko
Read more
From the Back Cover
"This little collection of puzzles is something to bash your head against while awaiting your SQL epiphany." --Joe CelkoJoe 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
See all Editorial Reviews
Product details
Series: The Morgan Kaufmann Series in Data Management Systems
Paperback: 200 pages
Publisher: Morgan Kaufmann; 1 edition (March 15, 1997)
Language: English
ISBN-10: 9781558604537
ISBN-13: 978-1558604537
ASIN: 1558604537
Product Dimensions:
0.8 x 7.2 x 9.2 inches
Shipping Weight: 15.2 ounces (View shipping rates and policies)
Average Customer Review:
3.3 out of 5 stars
15 customer reviews
Amazon Best Sellers Rank:
#3,076,533 in Books (See Top 100 in Books)
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 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.
I expected the SQL Puzzels to be database queries.
Great Book
Short Review: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.Detail Review:This book for all the SQL programmers regardless of database language you prefer. Book contains examples in different languages (SQL Server, Oracle, Sybase, Informix etc). 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 way and reading them gives broader idea of database programming.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 simple - "Think out of the box". The problems are 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 is 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.Rating: 4 StarsSummary: I think this book should be there available for every database developer who has reached advanced level. 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 DavePrincipal Database Administrator(blog.sqlauthority.com)
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.
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.
Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems) PDF
Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems) EPub
Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems) Doc
Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems) iBooks
Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems) rtf
Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems) Mobipocket
Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems) Kindle
