SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques you need to transform yourself into an expert SQL programmer Now, in this fully updated second edition, SQL mastermind Joe Celko keeps you moving forward, using his entertaining, conversational style to teach you the best solutions to old and new challenges and to convey the way you need to think if you really want to get the most out of your SQL programming efforts.Inside, logic and set based analyses replace the traditional, procedural approach to problem solving, helping you make the conceptual leap that separates an SQL guru from the rest of the pack As you catch on to Celko s approach, you ll devour what he has to say about some of SQL s toughest topics how aggregate functions really work, the best way to work with NULLs, how and why to fake array structures, and much .This book gives special emphasis to SQL 92 and product independent techniques that let you optimize performance or achieve highly specialized behavior, regardless of the RDBMS with which you work If you re serious about SQL, you won t let SQL for Smarties out of your sight Presents all new war stories that give you insight into real world SQL programming challenges Continues to cover SQL 89 but focuses heavily on the SQL 92 standard Offers still undocumented tips for working around system deficiencies Teaches scores of advanced techniques that can be used with any product, in any SQL environment Offers expert advice from a noted SQL authority and award winning columnist....
|Title||:||Joe Celko's SQL for Smarties: Advanced SQL Programming Second Edition (The Morgan Kaufmann Series in Data Management Systems)|
|Publisher||:||Morgan Kaufmann 1 edition October 25, 1999|
|Number of Pages||:||550 pages|
|File Size||:||864 KB|
|Status||:||Available For Download|
|Last checked||:||21 Minutes ago!|
Joe Celko's SQL for Smarties: Advanced SQL Programming Second Edition (The Morgan Kaufmann Series in Data Management Systems) Reviews
I cannot work without this book. Stuck with a poor database structure and huge volumes of data, I have had to explore every trick of the trade. Few computer books in general provide information that is accurate, helpful, and not repetitive of manuals and online material that is already available to you. This book is of exceptional value. Someone swiped mine and believe me, I must have another copy. How many of the computer books you have purchased get that kind of respect?
My usual approach to CS books is to read them from cover to cover. I don't try the examples, don't run the code, don't do the exercises.
I needed to link to this book for a blog entry, and I was looking for my review of this book when I realized I never wrote one. I can't believe it, since I use this book nearly once a week to jog my memory on some of the more esoteric SQL problems I need to solve.
I read this book a year ago, so I do not remember much. It's the only book I've seen out there that deals with advanced queries. The book is very insightful and stimulates ideas in one to try out, but many of the examples, however complicated they might be, are trivial in nature. Examples that nobody out there in the real world would want to do unless they want to satisfy some silly curiosity. The examples that come to mind are his organizational trees. Who cares about that? That's going a bit overboard I think. Another thing I remember is how authoritative Joe Celko tries to sound in his presentation of SQL and then he down plays it when he instructs his readers to check with their specific SQL implementation. Other than that the book seems to be expensive. If you must buy it try finding a used copy.