SQL Pocket Guide, 3/e (Paperback)

Jonathan Gennick

買這商品的人也買了...

商品描述

If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2.

SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats.

All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including:

  • Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators
  • Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more
  • PostgreSQL’s support of recursive WITH and some window functions
  • DB2 syntax and datatypes, some compatible with Oracle
  • MySQL features such as the TIMESTAMP type and the TO_SECONDS function

商品描述(中文翻譯)

如果您是一位日常工作中使用SQL的程式設計師或資料庫管理員,這本受歡迎的口袋指南是您理想的工作參考書。書中提供了許多解釋語言複雜性的例子,以及IBM DB2 Release 9.7、MySQL 5.1、Oracle Database 11g Release 2、PostgreSQL 9.0和Microsoft SQL Server 2008 Release 2中使用的SQL的關鍵方面。

《SQL口袋指南》描述了這些資料庫系統如何實現SQL語法進行查詢、管理事務和對數據進行更改。它還展示了這些系統如何使用SQL函數、正則表達式語法以及類型轉換函數和格式。

本書中的所有示例SQL語句都對一組表執行,其中包含您可以快速下載的數據。第三版涵蓋了重要的資料庫變更,包括:

- Oracle對遞歸WITH語法的支援,以及新增的PIVOT和UNPIVOT運算符
- Oracle中新增的函數,例如LISTAGG、NTH_VALUE等
- PostgreSQL對遞歸WITH和一些窗口函數的支援
- DB2的語法和資料類型,其中一些與Oracle兼容
- MySQL的功能,例如TIMESTAMP類型和TO_SECONDS函數