PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database, 3/e (Paperback)
暫譯: PostgreSQL:快速上手:進階開源資料庫實用指南,第3版(平裝本)
Regina O. Obe, Leo S. Hsu
- 出版商: O'Reilly
- 出版日期: 2017-11-28
- 售價: $1,900
- 貴賓價: 9.5 折 $1,805
- 語言: 英文
- 頁數: 314
- 裝訂: Paperback
- ISBN: 1491963417
- ISBN-13: 9781491963418
-
相關分類:
PostgreSQL
海外代購書籍(需單獨結帳)
買這商品的人也買了...
-
Learning Python, 5/e (Paperback)$2,820$2,679 -
精實開發與看板方法$550$435 -
Essential SQLAlchemy, 2/e (Paperback)$1,330$1,260 -
$414Python 計算機視覺編程 (Programming Computer Vision with Python) -
Arduino 官方正版 Genuino 101$1,700$1,700 -
Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems (Paperback)$1,995$1,890 -
Redis 開發與運維$534$507 -
$1,350Text Mining with R: A Tidy Approach (Paperback) -
$2,083Spark: The Definitive Guide: Big Data Processing Made Simple (Paperback) -
演算法圖鑑:26種演算法 + 7種資料結構,人工智慧、數據分析、邏輯思考的原理和應用 step by step 全圖解$450$356 -
$1,782Flask Web Development : Developing Web Applications with Python, 2/e (Paperback) -
Raspberry Pi 3 Model B+ (UK製)$4,620$4,389 -
$354PostgreSQL9.6 從零開始學(視頻教學版) -
超圖解 Python 物聯網實作入門 -- 使用 ESP8266 與 MicroPython$699$594 -
提升程式設計師的面試力|189道面試題目與解答, 6/e (Cracking the Coding Interview : 189 Programming Questions and Solutions, 6/e)$880$695 -
$403Redis 深度歷險:核心原理與應用實踐 -
人工智慧導論 (鴻海教育基金會發行)$380$342 -
晉昇軟體最高殿堂:Jenkins2 持續整合大師之路$600$474 -
$1,320Deep Learning with JavaScript: Neural Networks in Tensorflow.Js -
JavaScript 技術手冊$560$476 -
Deep Learning with Pytorch (Paperback)$1,850$1,758 -
Java SE 14 技術手冊$680$537 -
$2,070Multithreaded JavaScript: Concurrency Beyond the Event Loop -
Code:隱藏在電腦軟硬體底下的秘密 (第二版) (Code: The Hidden Language of Computer Hardware and Software, 2/e)$680$510 -
OpenTelemetry 入門指南:建立全面可觀測性架構(iThome鐵人賽系列書)【軟精裝】$750$585
相關主題
商品描述
Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you’ll also discover that PostgeSQL is more than a database system—it’s an impressive application platform as well.
With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e.
If you’re a current PostgreSQL user, you’ll pick up gems you may have missed before.
- Learn basic administration tasks such as role management, database creation, backup, and restore
- Apply the psql command-line utility and the pgAdmin graphical administration tool
- Explore PostgreSQL tables, constraints, and indexes
- Learn powerful SQL constructs not generally found in other databases
- Use several different languages to write database functions
- Tune your queries to run as fast as your hardware will allow
- Query external and variegated data sources with foreign data wrappers
- Learn how to use built-in replication to replicate data
商品描述(中文翻譯)
思考要遷移到 PostgreSQL 嗎?這本清晰且快速的入門書籍幫助您理解並使用這個開源資料庫系統。您不僅會學到版本 9.5 到 10 中的企業級功能,還會發現 PostgreSQL 不僅僅是一個資料庫系統——它也是一個令人印象深刻的應用平台。
本書中包含了許多範例,展示了如何完成在其他資料庫中困難或不可能實現的任務。這第三版涵蓋了新功能,例如直到現在僅在專有資料庫中出現的 ANSI-SQL 結構:外部資料包裝器 (Foreign Data Wrapper, FDW) 的增強;在版本 9.6 中引入的新全文檢索函數和運算子語法;版本 10 中的新 XML 結構;在 9.6 中引入並在 10 中增強的查詢平行化功能;以及在版本 10.e 中引入的內建邏輯複製。
如果您是目前的 PostgreSQL 使用者,您將會發現一些您之前可能錯過的寶貴知識。
- 學習基本的管理任務,例如角色管理、資料庫創建、備份和恢復
- 應用 psql 命令行工具和 pgAdmin 圖形管理工具
- 探索 PostgreSQL 的表格、約束和索引
- 學習在其他資料庫中通常找不到的強大 SQL 結構
- 使用多種不同的語言來編寫資料庫函數
- 調整查詢以便在硬體允許的範圍內運行得更快
- 使用外部資料包裝器查詢外部和多樣化的資料來源
- 學習如何使用內建複製來複製資料
