SQL Antipatterns, Vol. 1 »

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. This shortcut to wisdom shows you how to avoid “easy” solutions that don’t work, and how to be a better database developer in any language. Updated for the current versions of MySQL and Python, this new edition adds a dozen brand-new mini-antipatterns for quick wins.

Recently Released:

• Creating Software with Modern Diagramming Techniques 
• Programming Ruby 3.2 (5th Edition) 
• Cruising Along with Java 
• Effective Remote Work (audio book) 

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming

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!

Now in print: Use coupon code "BKSAP1COMPLETE" for 40% off the ebook at pragprog.com/titles/bksap1. For the paperback edition, please support your local independent bookstore.

Do More with What You Know

From paperbacks and ebooks to online courses and beyond, if you want to create technical content, we may be your perfect partner.

Leverage our 20+ years of experience, our global distribution network, our massive fan base, our relationships with industry leaders, our editorial, production, and marketing prowess, and even our reputation for excellence. Sure, you could go it alone, but with some of the highest royalties in all of traditional publishing and your own personal team, why would you bother?

Shoot us an email at proposals@pragprog.com or visit pragprog.com/publish-with-us for more details today.

Let's publish something together!

Upcoming Author Appearances

Be the First

Sign up for this newsletter at https://pragprog.com/newsletter/ and be the first to hear about our newest content, best promotions, and upcoming events.

Want even more? Follow @pragprog on Twitter and The Pragmatic Programmers on LinkedIn for commentary, news, job openings, and even puzzles.

And while you're here, remember to look up Andy Hunt @PragmaticAndy and Dave Thomas @pragdave, too.

Thanks for your continued support,

By Professional Developers, for Professional Developers
PragProg.com

Sent by the Pragmatic Programmers, LLC. • 9650 Strickland Rd Ste 103-255• Raleigh NC 27615