PDF Ebook Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems)
Checking out a book can help you to open the new globe. From knowing nothing to understanding whatever can be reached when checking out books sometimes. As many people state, more books you review, more things you want to know, however few points you will really feel. Yeah, reading guide will certainly lead your mind to open up minded as well as constantly aim to seek for the other understanding, even from lots of resources. Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) as a method of just how guide is advised will certainly be available for you to obtain it.
Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems)
PDF Ebook Joe Celko's SQL Puzzles and Answers (The Morgan Kaufmann Series in Data Management Systems)
Introducing a new hobby for other people may inspire them to join with you. Reading, as one of mutual hobby, is considered as the very easy hobby to do. But, many people are not interested in this hobby. Why? Boring is the reason of why. However, this feel actually can deal with the book and time of you reading. Yeah, one that we will refer to break the boredom in reading is choosing Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) as the reading material.
When some individuals considering you while reading Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems), you may really feel so proud. But, as opposed to other people feels you have to instil in on your own that you are reading Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) not because of that reasons. Reading this Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) will offer you more than individuals appreciate. It will guide to recognize greater than individuals looking at you. Even now, there are lots of sources to understanding, checking out a publication Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) still becomes the front runner as a terrific method.
Don't bother if you don't have enough time to go to the publication store and also search for the favourite e-book to check out. Nowadays, the on the internet e-book Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) is involving offer ease of checking out behavior. You could not have to go outdoors to search the publication Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) Searching and downloading and install the publication entitle Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) in this short article will certainly provide you better option. Yeah, online book Joe Celko's SQL Puzzles And Answers (The Morgan Kaufmann Series In Data Management Systems) is a sort of digital publication that you could enter the link download provided.
When you have reviewed it much more web pages, you will certainly know an increasing number of again. In addition when you have actually read all completed. That's your time to constantly bear in mind and also do exactly what the lesson and also experience of this publication offered to you. By this condition, you need to recognize that every publication ahs different means to present the impression to any kind of readers. Yet they will be and also have to be. This is exactly what the DDD always offers you lesson regarding it.
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
