DMCA. Copyrighted Work that you can Claim.
Base have 250 515 books.
Search: 


📙 Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems) by Joe Celko — free download


This is one of those books that are perhaps nice to have IN ADDITION to something better. Btw, do NOT overestimate the "for smarties" part in the title: the book is not all that advanced: it's more like an extensive cookbook with a lot of personal opinion thrown in (not always consistent; for example, in one place he inveighs against the evils of using sequential-number sequences as primary keys -- 'cause a table is not a sequence, you see, we're talking about sets here, who, by definition, are unordered -- OK, fine. Ten pages later he blasts the GUID type -- why? Because it's not inherently sequential and it's hard to spot the gaps in the sequences. But hey, why do we care about gaps? All we care about is that the field values be unique, which they are, gaps or no gaps. Seems like GUIDs should be perfect from the set-theoretical point of view, but no, he doesn't like them -- precisely because of the presence of those aspects, the lack of which he bemoaned one chapter back in the IDENTITY type. It's like he wrote these two chapters one ten years after the other, and forgot what he was talking about in one when writing the other. The content (or rather the intent behind it) is very good. There's a logical progression from the overall-schema things, to tables, and so on, including such esoterica as hierarchies and graphs (which is good not only, or even not so much because of the topics themselves, but because nice recent SQL features like CTEs are used a lot in the sample code thus demonstrating their non-trivial use). The downsides: the main flaw in Celko's writing is that whatever he writes reads like a two-page journal article, by which I mean it's all a perfunctorily dashed-off collection of tidbits; the overall structure is very tenuous (for example, he starts the hierarchies' chapter by saying they're a sort of graphs -- but the graphs proper chapter comes afterwards: wouldn't it make more sense to switch their order in the book then?) Some chapters are borrowed from other writers: for example, the chapter on temporal databases is taken, or rather squeezed out of Snodgrass's book (which I happened to be reading in parallel and thus was able to notice that). I'm not hinting at plagiarism here: I'm sure Snodgrass was aware of this borrowing and had OK'ed it, but first it would be nice to mention the fact of borrowing (I think), and second, and most important, when you compress a book into a chapter, you gotta do it very carefully so as to keep the material connected, coherent, and clear. This is not the case here (go for the original: it's good, and can be downloaded for free; google on the name). In general, Celko's writing, while not abhorrent, is mostly (though not everywhere) very sloppy; everything reads like a first draft never touched again by either the author or an editor. A fair amount of typos, and a lot of unclear, careless pages that make you struggle for meaning (not always successfully). Mangled French again: Joseph, if there's an accent over the last 'e' in a masculine form of a participle, it's gotta be an accent aigu, not accent grave (feminine simply adds an extra 'e' w/o changing anything else); thus it's 'née' not 'nèe'. Maybe it's a typo, but it's consistently repeated thoughout the book (and actually present in his other books!). While we're here: "Borland (née Inprise)" is actually the other way around: Inprise (née Borland). There's no question that the author is a smart guy, but writing isn't his forte and he should be less casual about it -- and then, he should also insist that his publisher provide good editorial oversight. I think MK is a good publisher, and I think they ought to be able to do a better job helping their writers achieve readability. Bottom line: I don't regret having this book; it's friendly and chatty (in a good sense); the inherently dry material is livened up a bit by a sprinkling of curious trivia; it's been somewhat enlightening on the first read, and repeatedly useful as a reference afterwards. Otoh, it's written sloppily and I feel that, inasmuch as I benefitted from it, I did only because I happen to have enough foundation to compensate for its flaws on my own. But I'm not looking for this kind of effort when reading technical books though, so three stars. Could be more, but for that the book needs to be aggressively edited and restructured. It's the third edition, btw: it would seem that there's been plenty of time to do just that. All in all, I recommend it, but only half-heartedly: as long as the prospective reader understands that this is not a terribly advanced book, as well that the reading won't be easy. The book's OK, but not on par with what you get from writers like Gray or Date.

About book:

About file:

  • File size: 7 003 821
  • Format: pdf


Security code:
Download button

Similar books results


Joe Celko's SQL for Smarties: Advanced SQL Programming (4th edition)
Joe Celko's SQL for Smarties: Advanced SQL Programming (4th edition) download pdf by Joe Celko

In the SQL database community, Joe Celko is a well-known columnist and purveyor of valuable insights. In Joe Celkos SQL for Smarties: Advanced SQL Programming, he picks up where basic SQL training and experience leaves many database professionals and offe...

Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition
Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition free download by Joe Celko

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book writt...

Joe Celko's SQL for Smarties - Advanced SQL Programming
Joe Celko's SQL for Smarties - Advanced SQL Programming free download by Joe Celko

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book writt...

Joe Celko's SQL for Smarties, Fourth Edition: Advanced SQL Programming
Joe Celko's SQL for Smarties, Fourth Edition: Advanced SQL Programming pdf free by Joe Celko

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 15 years later and in its fourth edition, this classic reference still reigns supreme as the...

Joe Celko's SQL for Smarties, Fifth Edition: Advanced SQL Programming
Joe Celko's SQL for Smarties, Fifth Edition: Advanced SQL Programming pdf free by Joe Celko

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 20 years later and in its fifth edition, this classic reference still reigns supreme as the ...

Joe Celko's SQL for smarties : advanced sql programming
Joe Celko's SQL for smarties : advanced sql programming download pdf by

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 15 years later and in its fourth edition, this classic reference still reigns supreme as the...

Trees and Hierarchies in SQL for Smarties
Trees and Hierarchies in SQL for Smarties free download by Joe Celko

Joe Celko's Trees and Hierarchies in SQL is an intermediate to advanced-level practitioner's guide to mastering the two most challenging aspects of developing database applications in SQL. In this book, Celko illustrates several major approaches to repres...

Sound for Film and Television, Third Edition
Sound for Film and Television, Third Edition epub download by Tomlinson Holman

Sound for Film and Television, Third Edition provides a thorough introduction to the fascinating field of recording, editing, mixing, and exhibiting film and television sound. It strikes a fine balance between aesthetic and technical content, combining th...

Guidelines for Pulmonary Rehabilitation Programs-4th Edition
Guidelines for Pulmonary Rehabilitation Programs-4th Edition download pdf by AACVPR

In recent years, the climate surrounding the development and implementation of pulmonary rehabilitation programs has continued to evolve. Legal changes regarding program funding, compensation, and staffing are more dependent on effective certified pu...

Aquinas on Mind (Topics in Medieval Philosophy)
Aquinas on Mind (Topics in Medieval Philosophy) free download by Anthony Kenny

Aquinas' mature works, though theological in intent, contain much material which is philosophical in the sense that it is not in any way dependent on beliefs which are specifically Christian. His philosophical psychology, or philosophy of mind, was not ta...

Arabic-English Dictionary: The Hans Wehr Dictionary of Modern Written Arabic (English and Arabic Edition)
Arabic-English Dictionary: The Hans Wehr Dictionary of Modern Written Arabic (English and Arabic Edition) free pdf by Hans Wehr

Its scholarship, accuracy and reliability make it one of the most significant contributions to Arabic lexicography. It is hoped that this masterpiece will point the way ot wider use of modern lexicographical principles in the compilation of dictionaries f...

Arbuscular Mycorrhizas: Physiology and Function
Arbuscular Mycorrhizas: Physiology and Function epub download by Manuela Giovannetti, Luciano Avio, Cristiana Sbrana (auth.), Hinanit Koltai, Yoram Kapulnik (eds.)

In the years since the first edition of “Arbuscular Mycorrhizas: Physiology and Function” was published, an exceptional proliferation of interest in mycorrhizal biology has developed. This has been associated with advances in different research discipline...

Aqueous Solutions of Simple Electrolytes
Aqueous Solutions of Simple Electrolytes free download by H. L. Friedman, C. V. Krishnan (auth.), Felix Franks (eds.)

The chapters making up this volume had originally been planned to form part of a single volume covering solid hydrates and aqueous solutions of simple molecules and ions. However, during the preparation of the manu­ scripts it became apparent that such a ...

Arabia and the Arabs : from the Bronze Age to the coming of Islam
Arabia and the Arabs : from the Bronze Age to the coming of Islam download pdf by Robert G Hoyland

Using a wide range of sources - inscriptions, poetry, histories, and archeological evidence - Robert Hoyland explores the main cultural areas of Arabia, from ancient Sheba in the South, to the deserts and oases of the north....

Aquarium : the career and defection of a Soviet military spy

Aquinas and Natural Law
Aquinas and Natural Law pdf free by D. J. O’Connor (auth.)

Arabic
Arabic free pdf by Nadira Auty, Rachael Harris, Clive Holes (auth.)

Arab Nationalism: Between Islam and the Nation-State

Archaeological Landscape Evolution: The Mariana Islands in the Asia-Pacific Region
Archaeological Landscape Evolution: The Mariana Islands in the Asia-Pacific Region free download by Mike T. Carson (auth.)

Landscapes have been fundamental to the human experience world-wide and throughout time, yet how did we as human beings evolve or co-evolve with our landscapes? By answering this question, we can understand our place in the complex, ever-changing world th...