商品描述
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
商品描述(中文翻譯)
對於程式設計師、分析師和資料庫管理員來說，這本《Nutshell》指南是當今最受歡迎的資料庫產品中使用的 SQL 語言的基本參考資料。這本全新的第四版根據最新的 ANSI/ISO 標準清楚地記錄了 SQL 命令，並詳細說明了這些命令在 Microsoft SQL Server 2019 和 Oracle 19c 中的實現，以及在 MySQL 8、MariaDB 10.5 和 PostgreSQL 14 開源資料庫產品中的實現。
您還將獲得關於關聯資料庫管理系統（RDBMS）模型的簡明概述，以及對基礎 RDBMS 概念的清晰解釋——所有內容都以簡潔、全面且易於使用的格式呈現。
各部分包括：
- 關於關聯資料庫模型的背景，包括當前和過去的 SQL 標準
- 理解關聯資料庫和 SQL 命令所需的基本概念
- 按照 SQL:2016 ANSI 標準的 SQL 語句字母順序命令參考
- MySQL、Oracle、PostgreSQL 和 SQL Server 對每個命令的實現
- ANSI SQL:2016 函數和結構的字母順序參考以及供應商的實現
- 每個實現特有的平台特定函數
作者簡介
Kevin Kline is a noted database expert and software industry veteran. A Microsoft SQL Server MVP since 2004, Kevin is a founder and former president of the Professional Association for SQL Server (PASS.org) and the author of many popular IT books. Kevin is also a top-rated speaker at industry trade shows worldwide.
Regina Obe is co-principal of Paragon Corporation (paragoncorporation.com), a database consulting company based in Boston. She has close to 30 years of professional experience in various programming languages and database systems, with special focus on PostgreSQL and PostGIS spatial database extension for PostgreSQL. She is a member of the PostGIS steering committee and development team. She is a coauthor of several database books with her husband, Leo Hsu.
Leo Hsu is co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 25 years of professional experience developing and thinking about databases for organizations large and small. He also holds a lectureship at Tufts University, teaching SQL to graduate level students. He has coauthored several database books with his wife Regina Obe.
作者簡介(中文翻譯)
Kevin Kline 是一位知名的資料庫專家和軟體產業資深人士。自 2004 年以來，他一直是 Microsoft SQL Server 的 MVP，並且是 SQL Server 專業協會（PASS.org）的創始人及前任會長，也是許多受歡迎的 IT 書籍的作者。Kevin 也是全球各大產業展會的高評價演講者。
Regina Obe 是位於波士頓的資料庫諮詢公司 Paragon Corporation（paragoncorporation.com）的共同負責人。她在各種程式語言和資料庫系統方面擁有近 30 年的專業經驗，特別專注於 PostgreSQL 及其空間資料庫擴展 PostGIS。她是 PostGIS 指導委員會和開發團隊的成員。她與丈夫 Leo Hsu 共同撰寫了幾本資料庫書籍。
Leo Hsu 是位於波士頓的資料庫諮詢公司 Paragon Corporation 的共同負責人。他在為各種大小型組織開發和思考資料庫方面擁有超過 25 年的專業經驗。他還在塔夫茨大學擔任講師，教授研究生級別的 SQL 課程。他與妻子 Regina Obe 共同撰寫了幾本資料庫書籍。
