SQL in a Nutshell

✍ Scribed by Kline, Kevin;Kline, Daniel;Hunt, Brand

• Publisher: O'Reilly Media, Inc
• Year: 2008
• Tongue: English
• Leaves: 593
• Edition: 3rd ed
• Category: Library

✦ Synopsis

The essential reference to the SQL language used in today's most popular database products, this new edition of SQL in a Nutshell clearly documents every SQL command according to the latest ANSI standard. It also details how these commands are implemented in the Microsoft SQL Server 2008 and Oracle 11g commercial database packages, and the MySQL 5.1 and PostgreSQL 8.3 open source database products.;SQL in a Nutshell; Who Should Read This Book?; How This Book Is Organized; How to Use This Book; Resources; Changes in the Third Edition; Conventions Used in This Book; Using Code Examples; How to Contact Us; Safari® Books Online; Acknowledgments; Daniel Kline & s Acknowledgments; Brand Hunt & s Acknowledgments; 1. SQL History and Implementations; NULLs (rule 3); Metadata (rules 4 and 10); The language (rules 5 and 11); Views (rule 6); Set operations (rules 7 and 12); Codd & s Rules in Action: Simple SELECT Examples; History of the SQL Standard; What & s New in SQL2003 (SQL3); Levels of Conformance.

✦ Table of Contents

SQL in a Nutshell
Who Should Read This Book?
How This Book Is Organized
How to Use This Book
Resources
Changes in the Third Edition
Conventions Used in This Book
Using Code Examples
How to Contact Us
Safari® Books Online
Acknowledgments
Daniel Kline & s Acknowledgments
Brand Hunt & s Acknowledgments
1. SQL History and Implementations
NULLs (rule 3)
Metadata (rules 4 and 10)
The language (rules 5 and 11)
Views (rule 6)
Set operations (rules 7 and 12)
Codd & s Rules in Action: Simple SELECT Examples
History of the SQL Standard
What & s New in SQL2003 (SQL3)
Levels of Conformance. Supplemental Features Packages in the SQL3 StandardSQL3 Statement Classes
SQL Dialects
2. Foundational Concepts
Naming conventions
Identifier rules
Literals
Operators
Assignment operators
Bitwise operators
Comparison operators
Logical operators
Unary operators
Operator precedence
System delimiters and operators
Keywords and Reserved Words
SQL2003 and Platform-Specific Datatypes
Oracle Datatypes
PostgreSQL Datatypes
SQL.

✦ Subjects

Computer science;Electronic books