SQL Success - Database Programming Proficiency

England & Wales: Rough Sea, 2013. - 592 p. - ISBN 978-1-909765-00-9 Preface Introduction to databases Introduction to SQL Retrieving Data From One Table Retrieving Data From Several Tables Ordering and Reporting Fuzzy Searches - Method Changing Data Functions, Procedures and Triggers Speeding Up Queries Views, Privileges and Security Using SQL in Programs Project Launchpad Conclusion SQL Success is about problem-solving in SQL . It bridges the gap between dry and dull database theory books, and developer books that focus on giving recipes without explaining sufficiently the reasons behind the recipes or discussing alternative solutions. Many developers struggle with SQL due to the contrast between the top-down logic of most programming languages and SQL's set-based approach. SQL Success aims to be different. This book is more than syntax examples. SQL Success explains how to use SQL to solve problems, and covers syntax in the process-not as the focus, but as a tool toward accomplishing the objective. SQL Success also shows something that most other books do the pitfalls and traps of SQL, a deceptively simple language, and how easy it is to get a query wrong. Written in a conversational way, SQL Success talks about logic more than theory, avoids jargon, and refers to common-sense more than rules. It ignores features that are rarely used and tries to avoid information overload. The intention of SQL Success is not to cover every aspect of all variants of SQL. The goal is to cover everything that is of practical use. That goal is informed by the author's many years of practical experience leading an understanding of what professional developers need to know, the common mistakes that are made, and how those mistakes can be avoided.