SQL (Structured Query Language) is a standardized query language for maintaining and querying database information. Historically, SQL has been the choice for database management systems running on minicomputers and mainframes. Increasingly, however, SQL is being adapted to PC systems that support distributed databases and allow users on a local-area network to access the same data 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 standard (SQL 99), which assists readers in learning 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 8i) 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.
ABOUT THE AUTHOR
|
| Daniel Kline | Daniel Kline is an assistant professor of English at the University of Alaska, Anchorage, where he specializes in medieval architecture, literary and cultural theory, and computer-assisted pedagogy. He completed his Ph.D. at Indiana University, Bloomington, and in addition to numerous scholarly presentations, Dan recently has published academic essays in Literary and Linguistic Computing, Philological Quarterly, Chaucer Review, and Essays in Medieval Studies. When he's not spending time with his wife and two ways, Dan frets over his pet project, the Electronic Canterbury Tales (http://cwolf.uaa.alaska.edu/~afdtk/ext_main.htm). Dan can be reached afdtk@uaa.alaska.edu. |
| Kevin E. Kline | Kevin Kline is the team leader for Information Architecture within Shared Information Services at Deloitte & Touche LLP. Kevin and his team perform data and infrastructure architecture in support of major knowledge management and transaction processing systems for Deloitte's Client Service Technology organization. Kevin is also the author of Transact-SQL Programming (0'Reilly, 1999) (http://www.oreilly.com/catalog/wintrnssql/) and numerous magazine articles on Microsoft SQL Server. When he's not pulling his hair out over work issues, Kevin likes to romance his wife, play with his three kids, tinker with his '66 Chevy pickup, and garden. |
