SQL in a Nutshell, 3rd Edition

Database Platforms Described in This Book

SQL in a Nutshell, Third Edition describes the SQL standard and the platform-specific implementations of several leading RDBMSs:

MySQL

MySQL is a popular open source DBMS that is known for its blistering performance. It runs on numerous operating systems, including most Linux variants. To improve performance, it has a slimmer feature set than many other DBMSs. This book covers MySQL 5.1.

Oracle

Oracle is a leading RDBMS in the commercial sector. It runs on a multitude of operating systems and hardware platforms. Its scalable, reliable architecture has made it the platform of choice for many users. In this edition, we cover Oracle Database 11g.

PostgreSQL

PostgreSQL is the most feature-rich open source database platform available. Whereas MySQL is best known for its high-speed performance, PostgreSQL is best known for its excellent support for ANSI standards and robust transaction processing capabilities, as well as its rich datatype and database object support. In addition to its full set of features, PostgreSQL runs on a wide variety of operating systems and hardware platforms. This book covers PostgreSQL 8.2.1.

SQL Server

Microsoft SQL Server is a popular RDBMS that runs only on the Windows platform. Its features include ease of use, an all-inclusive feature set, low cost, and high performance. This book covers Microsoft SQL Server 2008.