Share
Create bookmark
SQL in a Nutshell
Notes
Please login to add notes
- Table of Contents
- + Preface
-
+
SQL History and Implementations
-
+
Foundational Concepts
-
+
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 Statement
- CREATE/ALTER DATABASE Statement
- CREATE/ALTER FUNCTION/PROCEDURE Statements
- CREATE/ALTER INDEX Statement
- CREATE/ALTER METHOD Statement
- CREATE 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 Statement
- SELECT 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
- Shared and Platform-Specific Keywords
- Index
For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides:
Background on the Relational Database Model, including current and previous SQL standards
Fundamental concepts necessary for understanding relational databases and SQL commands
An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard
The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server
An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations
Platform-specific functions unique to each implementation
Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.
Test the closed alpha on paperc.com
Book Details
Authors
Kevin Kline, Daniel Kline, and Brand Hunt
Categories
Computers > Programming Languages > SQL
Publishers
Publication year : 2009
License: All rights reserved ©
Times read: 1,495
