• SQL Antipatterns: Avoiding the Pitfalls of Database Programming See large image

    SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers) (Paperback) By (author) Bill Karwin

    Hard to find title available from Book Depository

    $23.76 - Save $12.73 34% off - RRP $36.49 Free delivery worldwide Available
    Dispatched in 3 business days
    When will my order arrive?
    Add to basket | Add to wishlist |

    DescriptionYour database is the foundation of your application. Many programmers assume it's also the bottleneck of productive software development, but with the right techniques, this doesn't have to be true. SQL Antipatterns illustrates some of the most common misconceptions and pitfalls software developers face using relational databases. This book helps you to use a database to produce the most efficient results, and turn sluggish, inflexible code and thankless late-night hours into high-quality, reliable solutions and a job well done. The SQL database programming language is the core of most software in the world, but if you're like most software developers, you're self-taught in SQL, and you know just enough to get by. As a result, you might design fragile databases that cannot scale as the business grows, write queries that produce incorrect results and not know why, or deploy applications that are vulnerable to hackers. Don't reinvent the wheel to solve problems SQL was designed to solve--this book will teach you new SQL techniques for getting your job done. 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.

Other books

Other people who viewed this bought | Other books in this category
Showing items 1 to 10 of 10


Reviews | Bibliographic data
  • Full bibliographic data for SQL Antipatterns

    SQL Antipatterns
    Avoiding the Pitfalls of Database Programming
    Authors and contributors
    By (author) Bill Karwin
    Physical properties
    Format: Paperback
    Number of pages: 300
    Width: 191 mm
    Height: 229 mm
    Thickness: 27 mm
    Weight: 706 g
    ISBN 13: 9781934356555
    ISBN 10: 1934356557

    BIC E4L: COM
    Nielsen BookScan Product Class 3: S10.2
    B&T Book Type: NF
    B&T Modifier: Region of Publication: 01
    B&T Modifier: Subject Development: 20
    B&T Modifier: Academic Level: 05
    B&T Modifier: Text Format: 01
    B&T General Subject: 227
    LC subject heading:
    DC22: 005.1
    B&T Merchandise Category: COM
    DC22: 005.7565
    Ingram Subject Code: XL
    BIC subject category V2: UMT, UNSJ
    Warengruppen-Systematik des deutschen Buchhandels: 16330
    LC subject heading:
    B&T Approval Code: A93603281
    BISAC V2.8: COM051170, COM021000
    DC22: 005.7585
    B&T Approval Code: A93662400
    Libri: SQLA5000
    LC subject heading:
    LC classification: QA76.73.S67 K37 2010
    Thema V1.0: UNS, UMT
    The Pragmatic Programmers
    Imprint name
    The Pragmatic Programmers
    Publication date
    13 July 2010
    Publication City/Country
    Author Information
    Bill Karwin has been a software engineer for over twenty years, developing and supporting applications, libraries, and servers such as Zend Framework for PHP 5, the InterBase relational database, and the Enhydra Java application server. Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.
    Review quote
    ""This book is obviously the product of many years of practical experience with SQL databases. Each topic is covered in great depth, and the attention to detail in the book was beyond my expectations. Although it's not a beginner's book, any developer with a reasonable amount of SQL experience should find it to be a valuable reference and would be hard-pressed not to learn something new.""--Mike Naberezny, Partner at Maintainable Software; Coauthor of "Rails for PHP Developers"""Bill has written an engaging, useful, important, and unique book. Software developers will certainly benefit from reading the antipatterns and solutions described here. I immediately applied techniques from this book and improved my applications. Fantastic work!""--Frederic Daoud, Author of "Stripes: ...And Java Web Development Is Fun Again" and "Getting Started with Apache Click"