SQL Anti-patterns. How to Avoid Traps When Working with Databases

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+.

Author: Билл Карвин

Printhouse: piter

Series: Programmer's Library

Age restrictions: 16+

Year of publication: 2024

ISBN: 9785446121786

Number of pages: 368

Size: 165х233х19 mm

Cover type: soft

Weight: 584 g

ID: 1662536

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+.

€ 31.99

In stock

In-store availability

Prices in physical shops may differ.

In stock

In-store availability

Prices in physical shops may differ.

€ 31.99

Delivery methods

Choose the appropriate delivery method

Pick up yourself from the shop

0.00 €