SQL is a database language used to build and maintain database objects, and is at the heart of many enterprise applications. If you're involved in software development, you're likely to use some level of SQL. When working with SQL, you need a good syntax reference. Although SQL is a standardized language, the implementation of SQL is not standardized, and there are many differences in software from one vendor to another.

SQL in a Nutshell serves as an indispensable resource for programmers, analysts, and database administrators. It provides a comprehensive reference for the SQL language used in today's popular database products. It adheres to the latest ANSI/ISO standard and offers detailed documentation of SQL commands in Microsoft SQL Server, Oracle, MySQL, MariaDB, and PostgreSQL.

In addition to SQL commands, SQL in a Nutshell offers a concise overview of the relational database management system (RDBMS) model and explains foundational RDBMS concepts in a clear-cut manner. All of this valuable information is presented in a succinct, comprehensive, and user-friendly format.

SQL in a Nutshell is divided into sections that cover various aspects, including the background of the relational database model; current and previous SQL standards; fundamental concepts for understanding relational databases and SQL commands; an alphabetical command reference to SQL statements based on 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, and platform-specific functions unique to each implementation.

SQL in a Nutshell is a concise and valuable resource for anyone looking to quickly grasp the fundamentals of this essential programming language. It is not only a handy reference guide for experienced SQL programmers, analysts, and database administrators, but also an excellent resource for consultants and users who need to be familiar with the SQL language across multiple platforms.

Table Of Contents

  • 1. SQL History and Implementations
  • 2. Foundational Concepts
  • 3. Structuring Your Data
  • 4. Reading Your Data
  • 5. Manipulating Your Data
  • 6. Securing Your Data
  • 7. SQL Built-in Functions
  • 8. SQL Built-in Aggregate and Window Functions
  • 9. Storing Logic in the Database
  • 10. Flexible and Schemaless
  • A. Shared and Platform-Specific Keywords

Download URLs

Format Download Size
SQL in a Nutshell, 4th Edition
PDF 5.66 MB
(Homepage)