SQL in a Nutshell: A Desktop Quick Reference - Softcover

Kline, Kevin; Obe, Regina O; Hsu, Leo S

 
9781492088868: SQL in a Nutshell: A Desktop Quick Reference
Softcover
ISBN 10: 1492088862 ISBN 13: 9781492088868
Verlag: O'Reilly Media, 2022

Inhaltsangabe

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

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Über die Autorin bzw. den Autor

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 13 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

„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.

Verlag
O'Reilly Media
Erscheinungsdatum
2022
Sprache
Englisch
ISBN 10 
1492088862
ISBN 13 
9781492088868
Einband
Taschenbuch
Auflage
4
Anzahl der Seiten
838
Kontakt zum Hersteller
Nicht verfügbar
Verantwortliche Person
Buchpark GmbH
gpsr@buchpark.de

Krügerweg 1
Trebbin
Brandenburg
14959
Deutschland