SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers)
Blowout Sale! Save 52% on the SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers) by Brand: Pragmatic Bookshelf at Translate This Website. MPN: 978-1-934356-55-5. Hurry! Limited time offer. Offer valid only while supplies last. Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he's sharing his collection of
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.
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.
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.
|Brand:||Brand: Pragmatic Bookshelf|
|Item Weight:||1.28 pounds|
|Item Size:||1 x 9.25 x 9.25 inches|
|Package Weight:||1.15 pounds|
|Package Size:||7.5 x 1.1 x 1.1 inches|
Have questions about this item, or would like to inquire about a custom or bulk order?
If you have any questions about this product by Brand: Pragmatic Bookshelf, contact us by completing and submitting the form below. If you are looking for a specif part number, please include it with your message.
Related Best Sellers
By Brand: O'Reilly Media
ean: 9780596006327, isbn: 9780596006327,
The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation wi...
By Sams Publishing
mpn: 978-0-6723-2453-6, ean: 9780672324536, isbn: 0672324539,
Data Structures and Algorithms in Java, Second Edition is designed to be easy to read and understand although the topic itself is complicated. Algorithms are the procedures that software programs use to manipulate data structures. Besides clear and s...
By O'Reilly Media
mpn: black & white illustrations, ean: 9781491901427, isbn: 149190142X,
Data science libraries, frameworks, modules, and toolkits are great for doing data science, but they’re also a good way to dive into the discipline without actually understanding data science. In this book, you’ll learn how many of the most funda...
By Packt Publishing - ebooks Account
ean: 9781788626545, isbn: 9781788626545,
Exploring the major features and packages of Go, along with its types and data-structures, enabling the reader to write threadsafe, concurrent cloud, and network applicationsKey FeaturesNot your typical introduction to the Golang programming language...
By O'Reilly Media
mpn: black & white illustrations, ean: 9781491945285, isbn: 1491945281,
The financial industry has adopted Python at a tremendous rate recently, with some of the largest investment banks and hedge funds using it to build core trading and risk management systems. This hands-on guide helps both developers and quantitative ...
By Manning Publications
ean: 9781633430037, isbn: 9781633430037,
Summary Introducing Data Science teaches you how to accomplish the fundamental tasks that occupy data scientists. Using the Python language and common Python libraries, you'll experience firsthand the challenges of dealing with data at scale and gain...
By Academic Press
ean: 9780120885596, isbn: 012088559X,
In today’s information age, scientists and engineers must quickly and efficiently analyze extremely large sets of data. One of the best tools to accomplish this is Interactive Data Language (IDL®), a programming and visualization environment that ...
ean: 9783319693675, isbn: 3319693670,
This reader-friendly textbook presents a concise and easy to follow introduction to Scala. Scala is an ideal first programming language, which permits programming in multiple paradigms, and enables developers to be more productive with modern computi...
By CreateSpace Independent Publishing Platform
mpn: black & white illustrations, ean: 9781511820875, isbn: 9781511820875,
Excel 2013 Pivot Tables Including the "Data Model" A pivot table is a simple, yet powerful technique, that enables Excel's users to transform data overload into meaningful and organized knowledge. With pivot tables you can: * See the data in dozens o...
By O Reilly Media
mpn: 35561483, ean: 9781449316952, isbn: 9781449316952,
This practical guide provides more than 150 recipes to help you generate high-quality graphs quickly, without having to comb through all the details of R’s graphing systems. Each recipe tackles a specific problem with a solution you can apply to yo...