SQL in a Nutshell: A Desktop Quick Reference

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 14 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 Platform-specific functions unique to each implementation

From the brand

Explore our collection

More From O’Reilly

Sharing the knowledge of experts

O’Reilly’s mission is to change the world by sharing the knowledge of innovators. For over 40 years, we’ve inspired companies and individuals to do new things (and do them better) by providing the skills and understanding that are necessary for success.

Our customers are hungry to build the innovations that propel the world forward. And we help them do just that.

Publisher ‏ : ‎ O’Reilly Media
Publication date ‏ : ‎ July 19, 2022
Edition ‏ : ‎ 4th
Language ‏ : ‎ English
Print length ‏ : ‎ 838 pages
ISBN-10 ‏ : ‎ 1492088862
ISBN-13 ‏ : ‎ 978-1492088868
Item Weight ‏ : ‎ 2.6 pounds
Dimensions ‏ : ‎ 6 x 1.8 x 8.9 inches
Best Sellers Rank: #826,460 in Books (See Top 100 in Books) #84 in SQL #102 in Data Warehousing (Books) #214 in Data Modeling & Design (Books)
Customer Reviews: 4.7 4.7 out of 5 stars (18) var dpAcrHasRegisteredArcLinkClickAction; P.when(‘A’, ‘ready’).execute(function(A) { if (dpAcrHasRegisteredArcLinkClickAction !== true) { dpAcrHasRegisteredArcLinkClickAction = true; A.declarative( ‘acrLink-click-metrics’, ‘click’, { “allowLinkDefault”: true }, function (event) { if (window.ue) { ue.count(“acrLinkClickCount”, (ue.count(“acrLinkClickCount”) || 0) + 1); } } ); } }); P.when(‘A’, ‘cf’).execute(function(A) { A.declarative(‘acrStarsLink-click-metrics’, ‘click’, { “allowLinkDefault” : true }, function(event){ if(window.ue) { ue.count(“acrStarsLinkWithPopoverClickCount”, (ue.count(“acrStarsLinkWithPopoverClickCount”) || 0) + 1); } }); });