Table of Contents Next Section

SQL in a Nutshell, 2nd Edition

This essential desktop 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 includes the command syntax (by vendor, if the syntax differs across implementations), a description, and practical examples. 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.

    Preface
      Why This Book?
      Who Should Read This Book?
      How This Book Is Organized
      Conventions Used in This Book
      How to Use This Book
      Resources
      Changes in the Second Edition
      Acknowledgments
      Chapter 1.  SQL History and Implementations
      Section 1.1.  The Relational Model and ANSI SQL
      Section 1.2.  History of the SQL Standard
      Section 1.3.  SQL Dialects
      Chapter 2.  Foundational Concepts
      Section 2.1.  Database Platforms Described in This Book
      Section 2.2.  Categories of Syntax
      Section 2.3.  SQL2003 and Platform-Specific Datatypes
      Section 2.4.  Constraints
      Chapter 3.  SQL Statement Command Reference
      Section 3.1.  How to Use This Chapter
      Section 3.2.  SQL Platform Support
      Section 3.3.  SQL Command Reference
      Chapter 4.  SQL Functions
      Section 4.1.  Types of Functions
      Section 4.2.  ANSI SQL Aggregate Functions
      Section 4.3.  ANSI SQL Window Functions
      Section 4.4.  ANSI SQL Scalar Functions
      Section 4.5.  Platform-Specific Extensions
      Chapter 5.  Database Programming
      Section 5.1.  Database Programming Overview
      Section 5.2.  Opening a Database Connection
      Section 5.3.  Closing a Database Connection
      Section 5.4.  Managing Transactions
      Section 5.5.  Executing Statements
      Section 5.6.  Retrieving Data
      Section 5.7.  Bound Parameters
      Section 5.8.  Error Handling
      Section 5.9.  Examples
      Appendix A.  Sybase Adaptive Server
      Section A.1.  Sybase Adaptive Server Datatypes
      Section A.2.  Sybase Adaptive Server SQL Statements
      Section A.3.  Sybase Adaptive Server SQL Functions
      Section A.4.  Sybase Adaptive Server Keywords
      Appendix B.  Shared and Platform-Specific Keywords
    Index

  Table of Contents Next Section