SQL in a Nutshell 4th Edition by Kevin Kline, Regina O Obe, Leo S Hsu ISBN 9781492088868 149208879X

SQL in a Nutshell 4th Edition by Kevin Kline, Regina O Obe, Leo S Hsu – Ebook PDF Instant Download/Delivery: 9781492088868 ,149208879X
Full download SQL in a Nutshell 4th Edition after payment

Product details:

ISBN 10: 149208879X
ISBN 13: 9781492088868
Author: Kevin Kline, Regina O Obe, Leo S Hsu

“SQL (Structured Query Language) is a standardized query language for maintaining and querying database information. Historically, SQL has been the choice for database management systems running on minicomputers and mainframes. Increasingly, however, SQL is being adapted to PC systems that support distributed databases and allow users on a local-area network to access the same data simultaneously. Although there are different dialects of SQL, it is the closest thing to a standard query language that currently exists.” “SQL in a Nutshell is a practical and useful command reference to the latest release of the Structured Query Language standard (SQL99), which assists readers in learning how their favorite database product supports any standard SQL command. This book presents each of the SQL commands and describes its use in both commercial (Microsoft SQL Server 2000 and Oracle 8i) and open source (MySQL, PostgreSQL 7.0) implementations. Each command reference includes the command syntax (by vendor, if the syntax differs across implementations), a description, and informative examples that illustrate important concepts and uses.” “SQL in a Nutshell is more than a convenient reference guide for experienced SQL programmers, analysts, and database administrators. It’s also a great learning resource for novice and auxiliary SQL users, such as system administrators, users of packaged client/server products, and consultants who need to be familiar with the various SQL dialects across many platforms.”–Jacket.

SQL in a Nutshell 4th Edition Table of contents:

1. SQL History and Implementations

The Relational Model and ANSI SQL

Codd’s Rules for Relational Database Systems

Codd’s Rules in Action: Simple SELECT Examples

History of the SQL Standard

Levels of Conformance

Parts of the SQL Standard

SQL Statement Classes

SQL Dialects

NoSQL

2. Foundational Concepts

Database Platforms Described in This Book

Categories of Syntax

Identifiers

Literals

Operators

Keywords and Reserved Words

SQL and Platform-Specific Data Types

MySQL Data Types

Oracle Data Types

PostgreSQL Data Types

SQL Server Data Types

Constraints

Scope

Syntax

PRIMARY KEY Constraints

FOREIGN KEY Constraints

UNIQUE Constraints

CHECK Constraints

3. Structuring Your Data

How to Use This Chapter

SQL Platform Support

SQL Command Reference

CREATE/ALTER DATABASE Statement

CREATE DOMAIN Statement

CREATE/ALTER INDEX Statement

CREATE/ALTER SCHEMA Statement

CREATE/ALTER TABLE Statement

CREATE/ALTER TYPE Statement

CREATE/ALTER VIEW Statement

DROP Statements

4. Reading Your Data

How to Use This Chapter

SQL Platform Support

SQL Command Reference

ALL/ANY/SOME Operators

BETWEEN Operator

EXCEPT Set Operator

EXISTS Operator

FILTER Clause

GROUP BY Clause

IN Operator

INTERSECT Set Operator

IS Operator

JOIN Subclause

LIKE Operator

ORDER BY Clause

OVER Clause

SELECT Statement

SUBQUERY Substatement

UNION Set Operator

VALUES Clause

WHERE Clause

WITH Clause

WITH ORDINALITY Clause

5. Manipulating Your Data

How to Use This Chapter

SQL Platform Support

SQL Command Reference

COMMIT Statement

DELETE Statement

INSERT Statement

MERGE Statement

RELEASE SAVEPOINT Statement

RETURNING Clause

ROLLBACK Statement

SAVEPOINT Statement

SET TRANSACTION Statement

START TRANSACTION Statement

TRUNCATE TABLE Statement

UPDATE Statement

6. Securing Your Data

How to Use This Chapter

SQL Platform Support

SQL Command Reference

CONNECT Statement

CREATE ROLE Statement

GRANT Statement

REVOKE Statement

SET CONNECTION Statement

SET CONSTRAINTS Statement

SET PATH Statement

SET ROLE Statement

SET SCHEMA Statement

SET SESSION AUTHORIZATION Statement

SET TIME ZONE Statement

7. SQL Built-in Functions

How to Use This Chapter

Types of Functions

Deterministic and Nondeterministic Functions

Aggregate Functions

Window Functions

SQL Functions

Variable Functions

General-Purpose Functions

Numeric Functions

String Functions and Operators

Collection Functions

Platform-Specific Extensions

MySQL-Supported Functions

Oracle-Supported Functions

PostgreSQL-Supported Functions

SQL Server–Supported Functions

8. SQL Built-in Aggregate and Window Functions

How to Use This Chapter

SQL Aggregate Functions

SQL Aggregate Syntax

ARRAY_AGG

AVG and SUM

COLLECT

CORR

COUNT

COVAR_POP

COVAR_SAMP

CUME_DIST

DENSE_RANK

EVERY

LISTAGG

MIN and MAX

PERCENT_RANK

PERCENTILE_CONT

PERCENTILE_DISC

RANK

The REGR Family of Functions

STDDEV_POP

STDDEV_SAMP

VAR_POP

VAR_SAMP

Complementary Functions

GROUPING

MATCH_RECOGNIZE

SQL Window Functions

SQL Standard Window Syntax

MySQL Window Syntax

Oracle Window Syntax

PostgreSQL Window Syntax

SQL Server Window Syntax

Partitioning

Ordering

Grouping or Windowing

List of Window Functions

Platform-Specific Extensions

MySQL-Supported Functions

Oracle-Supported Functions

PostgreSQL-Supported Functions

SQL Server–Supported Functions

9. Storing Logic in the Database

How to Use This Chapter

SQL Platform Support

SQL Command Reference

CALL Statement

CLOSE Statement (Cursors)

CREATE/ALTER AGGREGATE Statement

CREATE CAST Statement

CREATE/ALTER FUNCTION/PROCEDURE Statement

CREATE/ALTER METHOD Statement

CREATE/ALTER/DROP TRIGGER Statement

DECLARE CURSOR Statement

FETCH Statement (Cursors)

OPEN Statement (Cursors)

RETURN Statement

Platform-Specific Extensions

10. Flexible and Schemaless

Why JSON?

Exporting Relational Data as JSON

JSON Support

JSON Data Types

SQL/JSON Path

SQL Standard JSON Functions

JSON Platform-Specific Extensions

Why XML?

XML Data Types

XPath

SQL XML Functions

XML Platform-Specific Extensions

A. Shared and Platform-Specific Keywords

SQL Standard Keywords

People also search for SQL in a Nutshell 4th Edition:

    
mysql in a nutshell 2nd edition
    
sql in a nutshell o’reilly
    
how to use sql in python
    
can you use sql in python
    
sql full details

Tags: Kevin Kline, Regina O Obe, Leo S Hsu, Nutshell, SQL