I recently had the chance to read in preview Bill Karwin‘s new book: SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming.
This book is a rework of Bill’s best seller from 2010. The new book can be considered as the second edition and is updated with Bill’s latest observations about common mistakes.
The author took in consideration the feedback about the first edition.
This new edition is full of information for beginners but also for experts who will appreciate to see how antipatterns are solved and most of the time surely propose different approaches.
Each antipatterns are identified by their names like “jaywalking“, “spaghetti query“, … and this is very interesting. I highly recommend that they be taught in SQL learning courses.
The book covers the most common errors in database design and in data query and compared to the second edition, this book also contains a number of “mini-antipatterns” and how to avoid them.
Bill illustrates all the cases with practical examples very easy to understand and follow.
If you have a friend learning SQL this book is the perfect gift !