November 03, 2022
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 Appearances2022-11-03 Johanna Rothman,
Modern Management: Position Yourself to Take Advantage of Complexity
2022-11-04 Craig Walls,
Lone Star Software Symposium - Austin, TX
2022-11-10 Gene Gotimer,
All Day DevOps
2022-12-02 Ben Cotton,
OLF (Columbus, OH, US)
2022-12-04 Craig Walls,
Progressive Web Experience, Clearwater, FL
2022-12-08 Johanna Rothman,
How to Lead a Feedback Lab Workshop
2022-12-08 Johanna Rothman,
Become an Excellent Technical Leader by Managing Yourself
2022-12-08 Johanna Rothman,
Extend your Technical Leadership to Lead an Innovative Organization
2022-12-09 Johanna Rothman,
Lead and Serve Others as an Excellent Technical Leader
2022-12-09 Johanna Rothman,
Want Innovative Products? Create Short Feedback Loops at All Levels
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
|