SQL in a Nutshell

by Kline, Kevin E.

• ISBN13: 9780596518844
• ISBN10: 0596518846
• Edition: 3rd
• Format: Paperback
• Copyright: 2008-11-01
• Publisher: Oreilly & Associates Inc

Summary

SQL in a Nutshell applies the eminently useful Nutshell format to Structured Query Language (SQL), the elegant-- but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is focused, and thoroughly comprehensive reference for those who live in a deadline- driven world. This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses.

Author Biography

Kevin Kline is the Director of SQL Server Solutions at Quest Software, a leading provider of award winning tools for database management and application monitoring on the SQL Server platform. Kevin is also the President of the international Professional Association for SQL Server (PASS) and frequently contributes to database technology magazines, web sites, and discussion forums. Kevin's most popular book is SQL in a Nutshell published by O'Reilly Media. Kevin is also the author of Transact-SQL Programming and three other books on database technologies. Kevin is a top rated speaker, appearing at international conferences like Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, and SQL Connections. When he's not working, Kevin likes to romance his wife, play to his four kids, write, and garden.

Table of Contents

Preface	p. v
SQL History and Implementations	p. 1
The Relational Model and ANSI SQL	p. 2
History of the SQL Standard	p. 10
SQL Dialects	p. 14
Foundational Concepts	p. 16
Database Platforms Described in This Book	p. 16
Categories of Syntax	p. 17
SQL2003 and Platform-Specific Datatypes	p. 29
Constraints	p. 50
SQL Statement Command Reference	p. 59
How to Use This Chapter	p. 59
SQL Platform Support	p. 60
SQL Command Reference	p. 63
SQL Functions	p. 437
Types of Functions	p. 437
ANSI SQL Aggregate Functions	p. 438
ANSI SQL Window Functions	p. 455
ANSI SQL Scalar Functions	p. 463
Platform-Specific Extensions	p. 483
Shared and Platform-Specific Keywords	p. 547
Index	p. 555
Table of Contents provided by Ingram. All Rights Reserved.