Rate this book

SQL Antipatterns (2010)

by Bill Karwin(Favorite Author)

3.85 of 5 Votes: 3

ISBN

1934356557 (ISBN13: 9781934356555)

languge

English

genre

Nonfiction

publisher

Pragmatic Bookshelf

review 1: SQL Antipatterns: Avoiding the Pitfalls of Database Programming reads a heck of a lot like it sounds it would. This book is full of good examples of bad practices (including some that SEEM like they would help you out) and ways that you can avoid them. As a few examples, multi-valued columns, multi-column attributes, too many indexes, replacing null values with a different known value, etc.I'd say that this book is best read by a junior / mid-level DBA or developer as it will provide a lot of good information on things to avoid, and why it is that you want to avoid them. The chapters are very cohesive and are easy to consume in a single sitting. As a matter of fact, I sat down and read about 5 chapters at a time (As opposed to some books that would take me five session... mores to read one chapter).
review 2: A very good book for younger developers, but I've learned most of these solutions already so I wanted a bit more out of this book. I picked it up because of its premise (common mistakes) and the chapter on trees, which while interesting (and useful to others I've recommended the book to) wasn't as insightful as I'd hoped. Having a strong background in this topic, I was able to skim through it easily in one afternoon. The book is well-written, and I will likely require it of my students if I ever teach a database/SQL class. less

Download links for: SQL Antipatterns

Advertising