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

Table of Contents

  1. 1. SQL History and Implementations
    1. The Relational Model and ANSI SQL
    2. Codd’s Rules for Relational Database Systems
    3. Codd’s Rules in Action: Simple SELECT Examples
    4. History of the SQL Standard
    5. What’s New in SQL:2016
    6. What’s New in SQL:2011
    7. What’s New in SQL:2008
    8. What’s New in SQL:2006
    9. What’s New in SQL:2003 (aka SQL3)
    10. Levels of Conformance
    11. Supplemental Features Packages in the SQL3 Standard
    12. SQL3 Statement Classes
    13. SQL Dialects
  2. 2. Foundational Concepts
    1. Database Platforms Described in This Book
    2. Categories of Syntax
    3. Identifiers
    4. Literals
    5. Operators
    6. Keywords and Reserved Words
    7. ANSI/ISO SQL and Platform-specific Data Types
    8. MySQL Data Types
    9. Oracle Datatypes
    10. PostgreSQL Data types
    11. SQL Server Data Types
    12. Constraints
    13. Scope
    14. Syntax
    15. PRIMARY KEY Constraints
    16. FOREIGN KEY Constraints
    17. UNIQUE Constraints
    18. CHECK Constraints
  3. 3. Structuring Your Data
    1. How to Use This Chapter
    2. SQL Platform Support
    3. SQL Command Reference
    5. CREATE/ALTER DOMAIN Statement
    6. CREATE/ALTER INDEX Statement
    7. CREATE ROLE Statement
    8. CREATE SCHEMA Statement
    9. CREATE/ALTER TABLE Statement
    10. CREATE/ALTER TYPE Statement
    11. CREATE/ALTER VIEW Statement
    12. DROP Statements