对于程序员、分析员和数据库管理员来说，本简明指南是当今最流行的数据库产品中使用的SQL语言的基本参考。新的第四版根据最新的ANSI/ISO标准清楚地记录了SQL命令，并详细介绍了这些命令在Microsoft SQL Server 2019和Oracle 19c以及MySQL 8、MariaDB 10.5和PostgreSQL 13开源数据库产品中的实现方式。
您还将获得关系数据库管理系统（RDBMS）模型的简要概述，以及对基本RDBMS概念的清晰解释——所有这些都以简洁、全面和易于使用的格式打包。
部分包括
关系数据库模型的背景知识，包括当前和以前的SQL标准
理解关系数据库和SQL命令所需的基本概念
根据SQL:2016 ANSI标准，对SQL语句的字母顺序命令引用
MySQL、Oracle、PostgreSQL和SQL Server对每个命令的实现
ANSI SQL:2016函数和构造以及供应商实现的字母参考
SQL in a Nutshell, 4th Edition (Fourth Early Release)
For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today’s most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 13 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.
Sections include
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 SQL:2016 ANSI standard
The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server
An alphabetical reference of the ANSI SQL:2016 functions and constructs as well as the vendor implementations
OR
