SQL Antipatterns PDF ePub eBook

Books Info:

SQL Antipatterns free pdf Your 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.

About Bill Karwin

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.

Details Book

Author : Bill Karwin
Publisher : The Pragmatic Programmers
Data Published : 13 July 2010
ISBN : 1934356557
EAN : 9781934356555
Format Book : PDF, Epub, DOCx, TXT
Number of Pages : 333 pages
Age + : 15 years
Language : English
Rating :

Reviews SQL Antipatterns



17 Comments Add a comment




Related eBooks Download


  • Inside Microsoft SQL Server 2005 free pdfInside Microsoft SQL Server 2005

    Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices. expert techniques. and code samples to master the intricacies of the programming language solving complex problems with real-world solutions..


  • Pro SQL Server 2008 Relational Database Design and Implementation free pdfPro SQL Server 2008 Relational Database Design and Implementation

    Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand all the way to the physical implementation of the design in a SQL Server database..


  • Next Generation Databases free pdfNext Generation Databases

    Next Generation Databases is a book for enterprise architects. database administrators. and developers who need to understand the latest developments in database technologies..


  • Pro LINQ Object Relational Mapping in C# 2008 free pdfPro LINQ Object Relational Mapping in C# 2008

    It is nearly impossible today to write enterprise software without the use of one or more relational databases. Granted. there are cases when the data is transient and not stored in a database..


  • Cross-Platform UI Development with Xamarin Forms free pdfCross-Platform UI Development with Xamarin Forms

    Create a fully operating application and deploy it to major mobile platforms using Xamarin.Forms About This Book* Create standard user interfaces on Windows Mobile. Android. and iOS and then make those interfaces look good with ease* Design a full-blown application in very little time with just about the entire code being shared* Learn how to access platform-specific features and still have the same core code with this handy guideWho This Book Is For This book is intended for mobile software developers who are fed up with having three different code sets for the same application..


  • SQL Antipatterns free pdfSQL Antipatterns

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