[PDF] SQL Antipatterns: Avoiding the Pitfalls of Database Programming Free Download

[message] Brief Description [PDF] SQL Antipatterns: Avoiding the Pitfalls of Database Programming Free Download by Bill Karwin | Publisher :...

  • [message]
    • Brief Description
      • [PDF] SQL Antipatterns: Avoiding the Pitfalls of Database Programming Free Download by Bill Karwin | Publisher : Pragmatic Bookshelf | Category : Computers & Internet | Tags : Patterns, Database, Programming Language, Programming, Search, Database Design | ISBN-10 : 1934356557 | ISBN-13 : 9781934356555
  • [message]
    • Book Image
      • SQL Antipatterns: Avoiding the Pitfalls of Database Programming by Bill Karwin, Publisher : Pragmatic Bookshelf
  • [message]
    • Complete Book Description
      • Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. The four parts of the book group the anti?patterns 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.

        Table of Contents

        Chapter 1 Introduction

        Part 1 Logical Database Design Antipatterns
        Chapter 2 Jaywalking
        Chapter 3 Naive Trees
        Chapter 4 Id Required
        Chapter 5 Keyless Entry
        Chapter 6 Entity-Attribute-Value
        Chapter 7 Polymorphic Associations
        Chapter 8 Multicolumn Attributes
        Chapter 9 Metadata Tribbles

        Part 2 Physical Database Design Antipatterns
        Chapter 10 Rounding Errors
        Chapter 11 31 Flavors
        Chapter 12 Phantom Files
        Chapter 13 Index Shotgun

        Part 3 Query Antipatterns
        Chapter 14 Fear Of The Unknown
        Chapter 15 Ambiguous Groups
        Chapter 16 Random Selection
        Chapter 17 Poor Man’S Search Engine
        Chapter 18 Spaghetti Query
        Chapter 19 Implicit Columns

        Part 4 Application Development Antipatterns
        Chapter 20 Readable Passwords
        Chapter 21 Sql Injection
        Chapter 22 Pseudokey Neat-Freak
        Chapter 23 See No Evil
        Chapter 24 Diplomatic Immunity
        Chapter 25 Magic Beans

        Part 5 Appendixes
        Appendix.A Rules Of Normalization
        Appendix.B Bibliography

  • [message]
    • Book Details
      • Book Name : SQL Antipatterns: Avoiding the Pitfalls of Database Programming

        Edition : 1

        Author : Bill Karwin

        Publisher : Pragmatic Bookshelf

        Category : Computers & Internet

        ISBN-10 : 1934356557

        ISBN-13 : 9781934356555

        ASIN : 1934356557

        Pages : 300

        Language : English

        Publish Date : July 2, 2010
  • [message]
    • Purchase on Amazon

These study materials are for information purposes and completely free. If you find these study material useful please write to us in a comment box.

Disclaimer : We are not the original publisher of this Book/Material on net. This eBook/Material had been collected from other sources of net.

Thank You
The Free Study Team

COMMENTS