SQL in a nutshell / Kevin E. Kline, with Daniel Kline and Brand Hunt.

Format:

Book

Author/Creator:

Kline, Kevin, 1966-

Contributor:

Hunt, Brand.

Kline, Daniel.

Series:

In a nutshell (O'Reilly & Associates)

Safari electronic books.

In a nutshell series

Language:

English

Subjects (All):

SQL server.

Client/server computing.

SQL (Computer program language).

Physical Description:

1 online resource (712 p.)

Edition:

Second edition.

Place of Publication:

Beijing ; Sebastopol, California : O'Reilly, 2004.

Language Note:

English

System Details:

text file

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 a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world. This invaluable desktop quick reference dri

Contents:

Table of Contents; Preface; Why This Book?; Who Should Read This Book?; How This Book Is Organized; Conventions Used in This Book; How to Use This Book; How to Contact Us; Safari Enabled; Resources; Changes in the Second Edition; Acknowledgments; Brand Hunt's Acknowledgments; Daniel Kline's Acknowledgments; Kevin E. Kline's Acknowledgments; SQL History and Implementations; The Relational Model and ANSI SQL; Codd's Rules for Relational Database Systems; Data structures (rules 1, 2, and 8); 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; Levels of Conformance; Supplemental Features Packages in the SQL2003 Standard; SQL2003 Statement Classes; SQL Dialects; Foundational Concepts; Database Platforms Described in This Book; Categories of Syntax; Identifiers; Naming conventions; Identifier rules; Literals; Operators; Arithmetic operators; Assignment operators; Bitwise operators; Comparison operators; Logical operators; Unary operators; Operator precedence; System delimiters and operators

Keywords and Reserved WordsSQL2003 and Platform-Specific Datatypes; DB2 Datatypes; MySQL Datatypes; Oracle Datatypes; PostgreSQL Datatypes; SQL Server Datatypes; Constraints; Scope; Syntax; PRIMARY KEY Constraints; FOREIGN KEY Constraints; UNIQUE Constraints; CHECK Constraints; SQL Statement Command Reference; How to Use This Chapter; SQL Platform Support; SQL Command Reference; ALL/ANY/SOME Operators; BETWEEN Operator; CALL Statement; CLOSE CURSOR Statement; COMMIT Statement; CONNECT; CREATE/ALTER DATABASE Statement; CREATE/ALTER FUNCTION/PROCEDURE Statements; CREATE/ALTER INDEX Statement

CREATE/ALTER METHOD StatementCREATE ROLE Statement; CREATE SCHEMA Statement; CREATE/ALTER TABLE Statement; CREATE/ALTER TRIGGER Statement; CREATE/ALTER TYPE Statement; CREATE/ALTER VIEW Statement; DECLARE CURSOR Command; DELETE Statement; DISCONNECT Statement; DROP Statements; EXCEPT Set Operator; EXISTS Operator; FETCH Statement; GRANT Statement; IN Operator; INSERT Statement; INTERSECT Set Operator; IS Operator; JOIN Subclause; LIKE Operator; MERGE Statement; OPEN Statement; ORDER BY Clause; RELEASE SAVEPOINT Statement; RETURN Statement; REVOKE Statement; ROLLBACK Statement

SAVEPOINT StatementSELECT Statement; SET Statement; SET CONNECTION Statement; SET CONSTRAINT Statement; SET PATH Statement; SET ROLE Statement; SET SCHEMA Statement; SET SESSION AUTHORIZATION Statement; SET TIME ZONE Statement; SET TRANSACTION Statement; START TRANSACTION Statement; SUBQUERY Substatement; TRUNCATE TABLE Statement; UNION Set Operator; UPDATE Statement; WHERE Clause; SQL Functions; Types of Functions; Deterministic and Nondeterministic Functions; Aggregate and Scalar Functions; Window Functions; ANSI SQL Aggregate Functions; AVG and SUM; CORR; COUNT; COVAR_POP; COVAR_SAMP

CUME_DIST

Notes:

Includes index.

Description based on print version record.

ISBN:

9781449378936

1449378935

9780596523442

0596523440