BookFronter
SQL in a Nutshell by Kevin Kline

SQL in a Nutshell

A Desktop Quick Reference

Kevin Kline, Regina Obe, Leo Hsu

O'Reilly Media · Print & ebook · July 19, 2022

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.

Computer ResourcesDatabase AdministrationSQL & Databasesscience
Buy on Amazon

We earn from qualifying purchases.

Who it’s for
Compare SQL:2016 commands across five database products, alongside core relational database concepts.
Themes
SQL command reference, Relational database concepts, SQL across database products
Genres
SQL & Databases, Database Administration, Computer Resources

Nearest books

Matched by what the books are about, then ordered by what their readers also loved. Most of these share its genres: SQL & Databases and Database Administration.

  1. SQL for DummiesAllen G. Taylor73% match
  2. SQL All-in-one for DummiesAllen G. Taylor, Richard Blum72% match
  3. Getting Started With SQLThomas Nield66% match
  4. SQL in 24 Hours, Sams Teach YourselfRyan Stephens66% match
  5. Unix in a NutshellArnold Robbins65% matchAlso shares Computer Resources
  6. Practical SQL, 2nd EditionAnthony DeBarros64% match
  7. Java in a NutshellBenjamin Evans, David Flanagan63% matchAlso shares Computer Resources
  8. T-SQL FundamentalsItzik Ben-Gan61% match

Start with three books, and this one can be the first.

Members get a new edition every morning: a route out from their books to essays, research and talks, with the reason for each.

Start with this book

About this book

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.

Continue reading

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

SQL Across Platforms

Compare SQL:2016 commands across five database products, alongside core relational database concepts.

Come here for

  • SQL commands mapped to MySQL, Oracle, PostgreSQL, and SQL Server
  • Relational database concepts and an alphabetical SQL function reference

Expect

  • ANSI SQL command and function references
  • Platform-specific implementations and functions

Where it sits

SQL & Databases99%
Database Administration71%
Computer Resources48%

Percentages are BookFrontier’s reading of the book.

Publisher categories

  • Data Science
  • Database Administration
  • Data Mining
  • Data Warehousing
Show all 6 publisher categories
  • SQL & Databases
  • Data Modeling
Authors
Kevin Kline, Regina Obe, Leo Hsu
Publisher
O'Reilly Media
Published
July 19, 2022
Format
Print & ebook
Theme
SQL command reference · Relational database concepts · SQL across database products
Reading lane
Data Science