SQL in a Nutshell, 3rd Edition

Preface

Since its first incarnation in the 1970s, the Structured Query Language (SQL) has been developed hand in hand with the information boom, and as a result, it is the most widely used database manipulation language in business and industry. A number of different software companies and program developers, including those in the open source movement (http://www.opensource.org), have concurrently developed their own SQL dialects in response to specific professional needs. All the while, standards bodies have developed a growing list of common features.

SQL in a Nutshell, Third Edition, describes the latest ANSI standard, SQL2003 (SQL3) version of each SQL command, and then documents each platform’s implementation of that command. In this book, you will find a concise explanation of the relational database management system (RDBMS) model, a clear-cut explanation of foundational RDBMS concepts, and thorough coverage of SQL syntax and commands.

Most importantly, at least if you’re a programmer or developer, SQL in a Nutshell, Third Edition, provides a concise guide both to the most popular commercial database packages on the market (Microsoft SQL Server and Oracle). It is also the guide for two of the best-known open source database products (MySQL and PostgreSQL). The attention this book pays to open source SQL platforms recognizes the growing importance of the open source movement within the computing community.

The SQL syntax covered in this book includes:

• ANSI SQL2003 (also known ...