SQL in a nutshell
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 se...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing ; Sebastopol, California :
O'Reilly
2004.
|
| Edición: | Second edition |
| Colección: | Safari electronic books.
In a nutshell (O'Reilly & Associates) |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626907906719 |
Tabla de Contenidos:
- 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
