SQL Antipatterns, Volume 1

SQL Antipatterns, Volume 1
Author :
Publisher : Pragmatic Bookshelf
Total Pages : 531
Release :
ISBN-10 : 9798888650028
ISBN-13 :
Rating : 4/5 (28 Downloads)

Book Synopsis SQL Antipatterns, Volume 1 by : Bill Karwin

Download or read book SQL Antipatterns, Volume 1 written by Bill Karwin and published by Pragmatic Bookshelf. This book was released on 2022-10-24 with total page 531 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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+.


SQL Antipatterns, Volume 1 Related Books

SQL Antipatterns, Volume 1
Language: en
Pages: 531
Authors: Bill Karwin
Categories: Computers
Type: BOOK - Published: 2022-10-24 - Publisher: Pragmatic Bookshelf

DOWNLOAD EBOOK

SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (suc
The Pragmatic Programmer
Language: en
Pages: 346
Authors: Andrew Hunt
Categories: Computers
Type: BOOK - Published: 1999-10-20 - Publisher: Addison-Wesley Professional

DOWNLOAD EBOOK

What others in the trenches say about The Pragmatic Programmer... “The cool thing about this book is that it’s great for keeping the programming process fre
Rails AntiPatterns
Language: en
Pages: 347
Authors: Chad Pytel
Categories: Computers
Type: BOOK - Published: 2010-11-09 - Publisher: Addison-Wesley Professional

DOWNLOAD EBOOK

The Complete Guide to Avoiding and Fixing Common Rails 3 Code and Design Problems As developers worldwide have adopted the powerful Ruby on Rails web framework,
Retrospectives Antipatterns
Language: en
Pages: 418
Authors: Aino Vonge Corry
Categories: Business & Economics
Type: BOOK - Published: 2020-10-02 - Publisher: Addison-Wesley Professional

DOWNLOAD EBOOK

Improve Every Retrospective! Real Solutions for Every Team Leader, Facilitator, and Participant “. . . Aino has shared a robust, curated list of antipatterns
Learn T-SQL Querying
Language: en
Pages: 474
Authors: Pedro Lopes
Categories: Computers
Type: BOOK - Published: 2019-05-03 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Troubleshoot query performance issues, identify anti-patterns in code, and write efficient T-SQL queries Key Features Discover T-SQL functionalities and service