book

SQL in a Nutshell, 4th Edition

by Kevin Kline, Regina O. Obe, Leo S. Hsu

June 2022

Intermediate to advanced

838 pages

21h 1m

English

O'Reilly Media, Inc.

Book available

Read now

Unlock full access

Why This Book?Who Should Read This Book?How This Book Is OrganizedHow to Use This BookResourcesChanges in the Fourth EditionConventions Used in This BookO’Reilly Online LearningHow to Contact UsAcknowledgmentsKevin E. Kline’s AcknowledgmentsRegina Obe and Leo Hsu’s Acknowledgments
The Relational Model and ANSI SQLCodd’s Rules for Relational Database SystemsCodd’s Rules in Action: Simple SELECT ExamplesHistory of the SQL StandardLevels of ConformanceParts of the SQL StandardSQL Statement ClassesSQL DialectsNoSQL
Database Platforms Described in This BookCategories of SyntaxIdentifiersLiteralsOperatorsKeywords and Reserved WordsSQL and Platform-Specific Data TypesMySQL Data TypesOracle Data TypesPostgreSQL Data TypesSQL Server Data TypesConstraintsScopeSyntaxPRIMARY KEY ConstraintsFOREIGN KEY ConstraintsUNIQUE ConstraintsCHECK Constraints
How to Use This ChapterSQL Platform SupportSQL Command ReferenceCREATE/ALTER DATABASE StatementCREATE DOMAIN StatementCREATE/ALTER INDEX StatementCREATE/ALTER SCHEMA StatementCREATE/ALTER TABLE StatementCREATE/ALTER TYPE StatementCREATE/ALTER VIEW StatementDROP Statements
How to Use This ChapterSQL Platform SupportSQL Command ReferenceALL/ANY/SOME OperatorsBETWEEN OperatorEXCEPT Set OperatorEXISTS OperatorFILTER ClauseGROUP BY ClauseIN OperatorINTERSECT Set OperatorIS OperatorJOIN SubclauseLIKE OperatorORDER BY ClauseOVER ClauseSELECT StatementSUBQUERY SubstatementUNION Set OperatorVALUES ClauseWHERE ClauseWITH ClauseWITH ORDINALITY Clause
How to Use This ChapterSQL Platform SupportSQL Command ReferenceCOMMIT StatementDELETE StatementINSERT StatementMERGE StatementRELEASE SAVEPOINT StatementRETURNING ClauseROLLBACK StatementSAVEPOINT StatementSET TRANSACTION StatementSTART TRANSACTION StatementTRUNCATE TABLE StatementUPDATE Statement
How to Use This ChapterSQL Platform SupportSQL Command ReferenceCONNECT StatementCREATE ROLE StatementGRANT StatementREVOKE StatementSET CONNECTION StatementSET CONSTRAINTS StatementSET PATH StatementSET ROLE StatementSET SCHEMA StatementSET SESSION AUTHORIZATION StatementSET TIME ZONE Statement
How to Use This ChapterTypes of FunctionsDeterministic and Nondeterministic FunctionsAggregate FunctionsWindow FunctionsSQL FunctionsVariable FunctionsGeneral-Purpose FunctionsNumeric FunctionsString Functions and OperatorsCollection FunctionsPlatform-Specific ExtensionsMySQL-Supported FunctionsOracle-Supported FunctionsPostgreSQL-Supported FunctionsSQL Server–Supported Functions
How to Use This ChapterSQL Aggregate FunctionsSQL Aggregate SyntaxARRAY_AGGAVG and SUMCOLLECTCORRCOUNTCOVAR_POPCOVAR_SAMPCUME_DISTDENSE_RANKEVERYLISTAGGMIN and MAXPERCENT_RANKPERCENTILE_CONTPERCENTILE_DISCRANKThe REGR Family of FunctionsSTDDEV_POPSTDDEV_SAMPVAR_POPVAR_SAMPComplementary FunctionsGROUPINGMATCH_RECOGNIZESQL Window FunctionsSQL Standard Window SyntaxMySQL Window SyntaxOracle Window SyntaxPostgreSQL Window SyntaxSQL Server Window SyntaxPartitioningOrderingGrouping or WindowingList of Window FunctionsPlatform-Specific ExtensionsMySQL-Supported FunctionsOracle-Supported FunctionsPostgreSQL-Supported FunctionsSQL Server–Supported Functions
How to Use This ChapterSQL Platform SupportSQL Command ReferenceCALL StatementCLOSE Statement (Cursors)CREATE/ALTER AGGREGATE StatementCREATE CAST StatementCREATE/ALTER FUNCTION/PROCEDURE StatementCREATE/ALTER METHOD StatementCREATE/ALTER/DROP TRIGGER StatementDECLARE CURSOR StatementFETCH Statement (Cursors)OPEN Statement (Cursors)RETURN StatementPlatform-Specific Extensions

Why JSON?Exporting Relational Data as JSONJSON SupportJSON Data TypesSQL/JSON PathSQL Standard JSON FunctionsJSON Platform-Specific ExtensionsWhy XML?XML Data TypesXPathSQL XML FunctionsXML Platform-Specific Extensions
SQL Standard KeywordsABCDEFG–HIJK–LMNOP–QRSTUV–ZKeywords Shared Across Multiple Platforms

Content preview from SQL in a Nutshell, 4th Edition

Chapter 6. Securing Your Data

In this chapter, we will discuss the SQL commands that enable DBAs and developers to permit or disable access to data, objects, and execution permissions within the database, as well as several commands that provide a higher level of control over the runtime characteristics of a worker session. These statements, particularly GRANT and REVOKE, make up the core of the data control language (DCL) category within the SQL standard.

There are some variations between vendors in terms of which statements they classify as DCL statements, and not all of them use that name. For example, SQL Server includes a DENY statement that implements a subset of the behavior of the SQL standard’s REVOKE statement (as explained in “REVOKE Statement”), and MySQL categorizes GRANT and REVOKE as database administration statements and does not use the term DCL.

How to Use This Chapter

When researching a command in this chapter:

Read “SQL Platform Support”.
Check Table 6-1.
Look up the specific SQL statement, check the syntax, and read the “Keywords,” “Rules at a glance,” and “Programming tips and gotchas” sections. Do this even if you are looking for a specific platform implementation.
Finally, read the platform-specific implementation information.

You will note that the entry for a given platform implementation does not duplicate information on any clauses that do not differ from the standard. So, it is possible that you will need to flip between the descriptions for a vendor ...