Book cover for SQL in a Nutshell: A Desktop Quick Reference by Kevin Kline, Regina O Obe and Leo S Hsu

SQL in a Nutshell

A Desktop Quick Reference

2022 Released
838 Pages
13-19 Hours
Ebook Unavailable
Audiobook Unavailable
Hardback Unavailable
O'Reilly Media ISBN 9781492088868

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

Kevin Kline

More by Kevin Kline

Regina O Obe

Regina Obe is a co-principal of Paragon Corporation, a database consulting company based in Boston. She has over 30 years of professional experience in various programming languages and database systems, with special focus on spatial databases. Regina has helped develop and contributed to several PostgreSQL extensions and is also a contributor to the core PostgreSQL project, most recently an extension support feature in PostgreSQL 16.

More by Regina O Obe

Leo S Hsu

Leo Hsu is a co-principal of Paragon Corporation, a database consulting company based in Boston. He teaches a master's course at Tufts University, "DATA-0202-01: Database Design and SQL" and uses PostgreSQL for teaching database concepts in his class. Leo has over 30 years of professional experience developing and thinking about databases for organizations large and small.

More by Leo S Hsu

Why Readwise Books?

Readwise Books is an ebook & audiobook platform that automatically logs how much you and your friends read, making it fun and easy to read more. Learn more →