August 18, 2021
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 on 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 available in beta from pragprog.com/titles/bksap1.
The Pragmatic Hero’s Journey Podcast: Ken Kousen
Ken Kousen is a Java Champion and Oracle Developer Champion. He's also the author of Help Your Boss Help You and co-host of the Groovy Podcast.
On this episode, Ken talks about how he got interested in writing books and how his latest book, Help Your Boss Help You, got its start. He also explains the concept of the prisoner's dilemma, and how it relates to managing people.
Listen to the rest of Ken's story on this episode of the Pragmatic Hero's Journey podcast.
You can stream the episode here: https://pragprog.libsyn.com/ or subscribe to the RSS feed at https://pragprog.libsyn.com/rss.
You Could Be a Published Author
Is there a tech topic you are deeply passionate about and want to share with the rest of us? You could become a published Pragmatic Bookshelf author! Take a look at our pragprog.com/become-an-author page for details, including our 50% royalty (yes, for real!) and world-class development editors.
Remember, the best way to tell the future is to create it.
Upcoming Author Appearances2021-08-25 Johanna Rothman,
Product Management Today
2021-09-21 Kenneth Kousen,
ApacheCon 2021, online
2021-09-24 Kenneth Kousen,
New England Software Symposium, Boston, MA
Don't Get Left Out
Are your friends jealous that you get these spiffy email newsletters and they don't? Clue them in that all they need to do is sign up at pragprog.com.
Tell your friends! Tweet this
Follow us on Twitter for the latest news, commentary, and occasional discounts: @pragprog, Andy Hunt @PragmaticAndy.
By Professional Developers, for Professional Developers
Sent by the Pragmatic Programmers, LLC. • 9650 Strickland Rd Ste 103-255• Raleigh NC 27615