SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming by Bill Karwin
English | November 29th, 2022 | ISBN: 1680508989 | 379 pages | True PDF | 10.22 MB
SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but they're not experts in SQL. They often depend on antipatterns - solutions that look right but become increasingly painful to work with as you uncover their hidden costs. Learn to identify and avoid many of these common blunders. Refactor an inherited nightmare into a data model that really works. Updated for the current versions of MySQL and Python, this new edition adds a dozen brand new mini-antipatterns for quick wins.