SQL Anti-patterns. How to Avoid Traps When Working with Databases
The SQL language is necessary for working with structured data. Programmers who are well-versed in their favorite languages (Java, Python, or Go) cannot understand everything, and often are not experts in SQL. This leads to the emergence of anti-patterns, –...
solutions that initially seem correct, but over time create increasing problems. Learn to identify and avoid many of these common traps! Refactor the inherited nightmare and turn it into a viable data model! Examples of SQL code are based on MySQL 8.0, but other popular RDBMS are also mentioned in the text. The code examples use Python 3.9+ or Ruby 2.7+.
The SQL language is necessary for working with structured data. Programmers who are well-versed in their favorite languages (Java, Python, or Go) cannot understand everything, and often are not experts in SQL. This leads to the emergence of anti-patterns, – solutions that initially seem correct, but over time create increasing problems. Learn to identify and avoid many of these common traps! Refactor the inherited nightmare and turn it into a viable data model! Examples of SQL code are based on MySQL 8.0, but other popular RDBMS are also mentioned in the text. The code examples use Python 3.9+ or Ruby 2.7+.
In stock
€ 31.99
Will be delivered to United States on 10 March (Tu):
By courier
from
€ 38.94
In stock
€ 31.99
Will be delivered to United States on 10 March (Tu):
Be the first to know about our current discounts, offers and new products!
Check icon
You have added to your basket
Check icon
You have added to favourites
Sold out
The item is currently out of stock.
In stock
Available in warehouse. You will receive the exact delivery date from the operator after the order confirmation.
To order
The product is delivered directly from the publisher. The order processing time is up to 14 days, you will receive the exact delivery date from the operator after the order confirmation.