SQL in a Nutshell
A Desktop Quick Reference
4th Edition
Will be published approx. on 24. June 2022
Book
Paperback/Softback
650 pages
978-1-4920-8886-8 (ISBN)
Description
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
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
More details
Edition
4th New edition
Language
English
Place of publication
Sebastopol
United States
Edition type
New edition
Product notice
Paperback (trade)
Unsewn / adhesive bound
Dimensions
Height: 226 mm
Width: 151 mm
Thickness: 48 mm
Weight
1200 gr
ISBN-13
978-1-4920-8886-8 (9781492088868)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Kevin Kline | Regina O. Obe | Leo S. Hsu
SQL in a Nutshell
E-Book
06/2022
4th Edition
O'Reilly
€50.49
Available for download
Kevin Kline | Regina O. Obe | Leo S. Hsu
SQL in a Nutshell
E-Book
06/2022
O'Reilly
€50.49
Available for download
Previous edition
Kevin Kline | Brand Hunt | Daniel Kline
SQL in a Nutshell
Book
12/2008
3rd Edition
O'Reilly
€37.00
Article exhausted; check for reprint
Persons
Kevin Kline is a noted database expert and software industry veteran. A Microsoft SQL Server MVP since 2004, Kevin is a founder and former president of the Professional Association for SQL Server (PASS.org) and the author of many popular IT books. Kevin is also a top-rated speaker at industry trade shows worldwide. Regina O. Obe is co-principal of Paragon Corporation, a database consulting company based in Boston. She has close to 30 years of professional experience in various programming languages and database systems, with special focus on PostgreSQL and PostGIS spatial database extension for PostgreSQL. Leo Hsu is co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 25 years of professional experience developing and thinking about databases for organizations large and small. He also holds a lectureship at Tufts University, teaching SQL to graduate level students. He has coauthored several database books with his wife Regina Obe.