SQL In A Nutshell, 2/e

Description:

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.

 

Table of Contents:

Preface

1. SQL History and Implementations
      The Relational Model and ANSI SQL
      History of the SQL Standard
      SQL Dialects

2. Foundational Concepts
      Database Platforms Described in This Book
      Categories of Syntax
      SQL2003 and Vendor-Specific Datatypes
      Constraints

3. SQL Statement Command Reference
      How to Use This Chapter
      SQL Platform Support
      SQL Command Reference

4. SQL Functions
      Types of Functions
      ANSI SQL Aggregate Functions
      ANSI SQL Window Functions
      ANSI SQL Scalar Functions
      Platform-Specific Extensions

5. Database Programming
      Database Programming Overview
      Opening a Database Connection
      Closing a Database Connection
      Managing Transactions
      Executing Statements
      Retrieving Data
      Bound Parameters
      Error Handling
      Examples
A. Sybase Adaptive Server
B. Shared and Platform-Specific Keywords
Index