Sql In A Nutshell

In a Nutshell

by Kevin E. Kline, Daniel Kline (With)

SQL (Structured Query Language) is a standardized query language for requesting information from a database. Historically, SQL has been the choice for database management systems running on minicomputers and mainframes. Increasingly, however, SQL is being adapted to PC database systems because it supports distributed databases--databases that are spread out over several computer systems, so that several users on a local-area network can access the same database simultaneously. Although there are different dialects of SQL, it is the closest thing to a standard query language that currently exists. SQL in a Nutshell is a practical and useful command reference to the latest release of the Structured Query Language (SQL99), helping readers learn how their favorite database product supports any standard SQL command. This book presents each of the SQL commands and describes its use in both commercial (Microsoft SQL Server 2000 and Oracle 8 i ) and open source (MySQL, PostgreSQL 7.0) implementations. Each command reference includes the command syntax (by vendor, if the syntax differs across implementations), a description, and informative examples that illustrate important concepts and uses.SQL in a Nutshell is more than a convenient reference guide for experienced SQL programmers, analysts, and database administrators. It's also a great learning resource for novice and auxiliary SQL users such as system administrators, users of packaged client/server products, and consultants who need to be familiar with the various SQL dialects across many platforms.

Genres: Reference, Programming, Computers, Nonfiction, Computer Science, Technical, Technology

224 pages, Paperback

First published January 1, 2000

Reviews

[Austin Craver]

The author clearly states in the preface what this book is, and is not. The book is primarily a command reference. It is intended as a reference tool, not a tutorial. Nor is it expository.

[Warren Owen]

Useful compact reference book for someone who occasionally uses SQL.

[Christophe Gesché]

Usefull

SQL has so many possibilities.

So easy to start to use.
So easy to became complex and hard :)

[Daniel]

This is useful ONLY as a reference. Its organization is utterly useless unless you already know SQL top to bottom and just need a refresh on the fiddly bits. That said, if the above is what you're looking for, it is good at that job.

[Talia]

A great reference to have on hand if you're working with SQL databases

[Ivy]

mainly for reference

[Natasha]

Quite helpful, and lot to learn.