Table Of ContentPreface; Why This Book?; Who Should Read This Book?; How This Book Is Organized; Conventions Used in This Book; How to Use This Book; How to Contact Us; Safari Enabled; Resources; Changes in the Second Edition; Acknowledgments;Chapter 1: SQL History and Implementations; 1.1 The Relational Model and ANSI SQL; 1.2 History of the SQL Standard; 1.3 SQL Dialects;Chapter 2: Foundational Concepts; 2.1 Database Platforms Described in This Book; 2.2 Categories of Syntax; 2.3 SQL2003 and Platform-Specific Datatypes; 2.4 Constraints;Chapter 3: SQL Statement Command Reference; 3.1 How to Use This Chapter; 3.2 SQL Platform Support; 3.3 SQL Command Reference;Chapter 4: SQL Functions; 4.1 Types of Functions; 4.2 ANSI SQL Aggregate Functions; 4.3 ANSI SQL Window Functions; 4.4 ANSI SQL Scalar Functions; 4.5 Platform-Specific Extensions;Chapter 5: Database Programming; 5.1 Database Programming Overview; 5.2 Opening a Database Connection; 5.3 Closing a Database Connection; 5.4 Managing Transactions; 5.5 Executing Statements; 5.6 Retrieving Data; 5.7 Bound Parameters; 5.8 Error Handling; 5.9 Examples;Appendix A: Sybase Adaptive Server; A.1 Sybase Adaptive Server Datatypes; A.2 Sybase Adaptive Server SQL Statements; A.3 Sybase Adaptive Server SQL Functions; A.4 Sybase Adaptive Server Keywords;Appendix B: Shared and Platform-Specific Keywords;Colophon;
Synopsis"SQL in a Nutshell" applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of "SQL in a Nutshell" is the essential date language reference for the world's top SQL database products. "SQL in a Nutshell" is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world.This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases.When you need fast, accurate, detailed, and up-to-date SQL information, "SQL in a Nutshell," Second Edition will be the quick reference you'll reach for every time. "SQL in a Nutshell" is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it., "SQL in a Nutshell" applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of "SQL in a Nutshell" is the essential date language reference for the world's top SQL database products. "SQL in a Nutshell" is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world. This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases. When you need fast, accurate, detailed, and up-to-date SQL information, "SQL in a Nutshell," Second Edition will be the quick reference you'll reach for every time. "SQL in a Nutshell" is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it., SQL in a Nutshell applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world.This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases.When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell , Second Edition will be the quick reference you'll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it.