SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers)

$7.49
1 in stock

Pickup available at Bookstore (Hours: Open Everyday, 8 am to 4 pm)

Usually ready in 24 hours


About this item

Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he’s sharing his collection of antipatterns—the most common errors he’s identified in those thousands of requests for help. Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. The four parts of the book group the antipatterns in terms of logical database design, physical database design, queries, and application development. The chances are good that your application’s database layer already contains problems such as Index Shotgun, Keyless Entry, Fear of the Unknown, and Spaghetti Query. This book will help you and your team find them. Even better, it will also show you how to fix them, and how to avoid these and other problems in the future. SQL Antipatterns gives you a rare glimpse into an SQL expert’s playbook. Now you can stamp out these common database errors once and for all. Whatever platform or programming language you use, whether you’re a junior programmer or a Ph.D., SQL Antipatterns will show you how to design and build databases, how to write better database queries, and how to integrate SQL programming with your application like an expert. You’ll also learn the best and most current technology for full-text search, how to design code that is resistant to SQL injection attacks, and other techniques for success. Most developers aren’t SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong. This book shows you all the common mistakes, and then leads you through the best fixes. What’s more, it shows you what’s behind these fixes, so you’ll learn a lot about relational databases along the way.
ASIN: 1934356557
VSKU: DBV.1934356557.A
Condition: Acceptable
Author/Artist:Karwin, Bill
Binding: Paperback
Note: Any images shown are stock photographs and product may differ from what is shown.
Condition Notes: This copy has clearly been enjoyed—expect noticeable shelf wear and some minor creases to the cover. Binding is strong, and all pages are legible. May contain previous library markings or stamps.
Note on Condition

Most of the items in our store are used. The item's condition grade is indicated near the bottom of the product description. If you have any questions regarding specific details of an item, please contact us. We use the following rating scale:

Books:

  • Used - Very Good: Item may have minor cosmetic defects (marks, wears, cuts, bends, crushes) on the cover, spine, pages or dust cover. Shrink wrap, dust covers, or boxed set case may be missing. Item may contain remainder marks on outside edges, which should be noted in listing comments. Item may be missing bundled media. 
  • Used - Good: All pages and cover are intact (including the dust cover, if applicable). Spine may show signs of wear. Pages may include limited notes and highlighting. Gently used ex-library books with library stickers and markings may be classified as good. Shrink wrap, dust covers, or boxed set case may be missing. Item may be missing bundled media. 
  • Used - Acceptable: All pages and the cover are intact, but shrink wrap, dust covers, or boxed set case may be missing. Pages may include limited notes, highlighting, or minor water damage but the text is readable. Item may but the dust cover may be missing. Pages may include limited notes and highlighting, but the text cannot be obscured or unreadable.

CDs/DVDs/Discs:

  • Used - Good: Case may be damaged or come repackaged. Disc may have up to 1.5cm marking but is in great working condition. 
  • Used - Acceptable: A product with extensive external signs of wear, but is in great working condition. The case may be damaged. The cover art, liner, notes, or other inclusion may be marked, or one or all of these items may be missing.
Shipping & Returns

Shipping: Most orders are shipped within 2 business days.

Returns: We want you to be completely satisfied with your purchase. If you're not, you can return your order within 30 days of purchase for a refund.

Fast Shipping

Orders are typically processed and shipped within 2 days

Competitive Pricing

We've streamlined our processes to provide competitive prices on all our titles

Exceptional Customer Service

Our dedicated team is committed to providing outstanding customer support