SQL Pocket Guide, 3/e (Paperback)
暫譯: SQL 口袋指南，第3版 (平裝本)
Jonathan Gennick
- 出版商: O'Reilly
- 出版日期: 2010-12-13
- 售價: $890
- 貴賓價: 9.5 折 $846
- 語言: 英文
- 頁數: 206
- 裝訂: Paperback
- ISBN: 1449394094
- ISBN-13: 9781449394097
-
相關分類:
SQL
-
其他版本:
SQL Pocket Guide: A Guide to SQL Usage 4th 版本
買這商品的人也買了...
-
Unix Systems Programming: Communication, Concurrency and Threads, 2/e (Hardcover)$3,360$3,293 -
Oracle Regular Expressions Pocket Reference$620$589 -
$650Oracle SQL*Plus : The Definitive Guide, 2/e (Paperback) -
深入淺出設計模式 (Head First Design Patterns)$880$695 -
Oracle PL/SQL Language Pocket Reference, 4/e$750$713 -
$1,488C++ GUI Programming with Qt 4, 2/e (Hardcover) -
Microsoft ASP.NET and AJAX: Architecting Web Applications (Paperback)$1,590$1,511 -
必備計算機概論 2011$580$493 -
深入淺出 Android 遊戲程式開發範例大全$620$484 -
App 程式設計入門－iPhone、iPad$450$356 -
The Web Design Pocket Guide Boxed Set (Includes The HTML Pocket Guide, The JavaScript Pocket Guide, and The CSS Pocket Guide) (Paperback)$1,580$1,548 -
Android 案例開發完全講義$580$458 -
Programming Microsoft ASP.NET 4 (Paperback)$2,220$2,109 -
$990Criminalistics: An Introduction to Forensic Science, 9/e (paperback) -
高效能網站建置指南 (Even Faster Web Sites: Performance Best Practices for Web Developers)$580$493 -
無瑕的程式碼 － 敏捷軟體開發技巧守則 (Clean Code: A Handbook of Agile Software Craftsmanship)$580$452 -
Make 國際中文版 vol.07$380$342 -
超圖解 Arduino 互動設計入門 (附 Arduino UNO R3 開發板)$1,130$961 -
Google 御用網頁語言 Node.js：一流程式設計師養成精華$490$417 -
讓東西動起來 ─ 給發明家、業餘愛好者以及藝術家的 DIY 機械裝置 (Making Things Move: DIY Mechanisms for Inventors, Hobbyists, and Artists)$580$522 -
搞懂 NoSQL 的 15 堂課 (NoSQL Distilled 中文版) (NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence)$360$284 -
$174SQL 必知必會(第4版)(Sams Teach Yourself SQL in 10 Minutes, 4/e) -
Getting Started with SQL: A Hands-On Approach for Beginners (Paperback)$1,128$1,068 -
Linux Pocket Guide: Essential Commands, 3/e (Paperback)$1,040$988 -
TensorFlow + Keras 深度學習人工智慧實務應用$590$460
商品描述
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 函數
