SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming by Karwin, Bill
SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming by Karwin, Bill

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming

SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on...
HK$748.11
HK$748.11
SKU: 9781680508987
Product Type: Books
Please hurry! Only 588 left in stock
Author: Bill Karwin
Format: Paperback
Language: English
Subtotal: $748.11
10 customers are viewing this product
SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming by Karwin, Bill

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming

$748.11
SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming by Karwin, Bill

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming

$748.11
Author: Bill Karwin
Format: Paperback
Language: English
Description

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

Author: Bill Karwin
Publisher: Pragmatic Bookshelf
Published: 11/15/2022
Pages: 340
Binding Type: Paperback
Weight: 1.44lbs
Size: 9.25h x 7.50w x 0.78d
ISBN: 9781680508987

Shipping & Return

Returns Policy

You may return most new, unopened items within 30 days of delivery for a full refund. We'll also pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.).

You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).

If you need to return an item, simply login to your account, view the order using the "Complete Orders" link under the My Account menu and click the Return Item(s) button. We'll notify you via e-mail of your refund once we've received and processed the returned item.

Shipping

We can ship to virtually any address in the world. Note that there are restrictions on some products, and some products cannot be shipped to international destinations.

When you place an order, we will estimate shipping and delivery dates for you based on the availability of your items and the shipping options you choose. Depending on the shipping provider you choose, shipping date estimates may appear on the shipping quotes page.

Please also note that the shipping rates for many items we sell are weight-based. The weight of any such item can be found on its detail page. To reflect the policies of the shipping companies we use, all weights will be rounded up to the next full pound.

Review

Related Products

Example product title
HK$748.11
HK$748.11
Example product title
HK$748.11
HK$748.11
Example product title
HK$748.11
HK$748.11
Example product title
HK$748.11
HK$748.11
Example product title
HK$748.11
HK$748.11
Example product title
HK$748.11
HK$748.11
Example product title
HK$748.11
HK$748.11
Example product title
HK$748.11
HK$748.11
Example product title
HK$748.11
HK$748.11
Example product title
HK$748.11
HK$748.11

Recently Viewed Products