Preview "SQL in a Nutshell (4th ed.)" in a new window.

SQL in a Nutshell (4th ed.)

Authors

Book 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 standardsFundamental concepts necessary for understanding relational databases and SQL commandsAn alphabetical command reference to SQL statements, according to the SQL:2016 ANSI standardThe implementation of each command by MySQL, Oracle, PostgreSQL, and SQL ServerAn alphabetical reference of the ANSI SQL:2016 functions and constructs as well as the vendor implementationsPlatform-specific functions unique to each implementation

In The Press

About the Author

Read on Your Favourite Devices

to find out more

Ebook Permissions

to find out more

About this Ebook

File formats
This ebook is available in:
The publisher has not yet supplied format information.
Pre-order formats shown are based on publisher intent and may change before release.
File sizes shown are an approximation. The actual download size will vary based on the application you use to read the book.
Publisher
Published
; Copyright:
ISBNs
Title
Series
Author
;
Edition
Imprint
Language
Number of Pages
Page count shown is an approximation provided by the publisher. The actual page count will vary based on various factors such as your device's screen size and font-size.