O'Reilly logo

SQL in a Nutshell by Kevin Kline

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Databases Described in This Book

SQL in a Nutshell describes the SQL standard and the vendor implementations of four leading RDBMSs — two that are from leading commercial vendors (Microsoft SQL Server and Oracle) and two that are from the chief open source database projects (MySQL and PostgreSQL):

Microsoft SQL Server

Microsoft SQL Server is a popular RDBMS that runs only on the Windows platform. Its features include ease of use, low cost, and high performance. This book covers Microsoft SQL Server 2000.

MySQL

MySQL is a popular open source Database Management System (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 do many other DBMSs. Its critics point out that it is not a fully relational DBMS since it does not support many key features of relational databases, particularly in how it processes transactions. This book covers MySQL 3.22.9.

Oracle

Oracle is a leading RDBMS in the commercial sector. It runs on a multitude of operating systems and hardware platforms. Its scalable and reliable architecture have made it the platform of choice for many users. Because of their highly tunable nature, Oracle RDBMSs require a well-trained database administrator (DBA). SQL in a Nutshell covers Oracle Release 8.1.

PostgreSQL

PostgreSQL is one of the most feature-rich RDBMSs of the open source world. Its compliance with SQL standards is unmatched by other open source RDBMSs. In addition to its rich set of features, PostgreSQL runs on a wide variety of operating systems and hardware platforms. This book covers PostgreSQL 6.5.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required