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. No matter which platform framework
or language you use the database is the foundation of your application and the SQL database
language is the standard for working with it. Antipatterns are solutions that look simple at
the surface but soon mire you down with needless work. Learn to identify these traps and
craft better solutions for the often-asked questions in this book. Avoid the mistakes that lead
to poor performance and quality and master the principles that make SQL a powerful and
flexible tool for handling data and logic. Dive deep into SQL and database design and learn to
recognize the most common missteps made by software developers in database modeling SQL query
logic and code design of data-driven applications. See practical examples of misconceptions
about SQL that can lure software projects astray. Find the greatest value in each group of
data. Understand why an intersection table may be your new best friend. Store passwords
securely and don't reinvent the wheel. Handle NULL values like a pro. Defend your web
applications against the security weakness of SQL injection. Use SQL the right way - it can
save you from headaches and needless work and let your application really shine! What You
Need: The SQL examples use the MySQL 8.0 flavor but other popular brands of RDBMS are
mentioned. Other code examples use Python 3.9+ or Ruby 2.7+.
