PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database, 2/e (Paperback)
暫譯: PostgreSQL：快速上手：進階開源資料庫的實用入門，第2版（平裝本）

Regina O. Obe, Leo S. Hsu

PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database, 2/e (Paperback)

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

商品描述

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.2, 9.3, and 9.4, you'll also discover that PostgeSQL is more than a database system--it's also an impressive application platform.
With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. 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 features to replicate data

商品描述(中文翻譯)

考慮遷移到 PostgreSQL 嗎？這本清晰且節奏快速的入門書籍幫助您理解並使用這個開源資料庫系統。您不僅會學到 9.2、9.3 和 9.4 版本中的企業級功能，還會發現 PostgreSQL 不僅僅是一個資料庫系統——它也是一個令人印象深刻的應用平台。
本書中包含了許多範例，展示了如何完成在其他資料庫中困難或不可能實現的任務。這是第二版，涵蓋了 LATERAL 查詢、增強的 JSON 支援、物化視圖及其他關鍵主題。如果您是目前的 PostgreSQL 使用者，您將會發現一些之前可能錯過的寶貴知識。
- 學習基本的管理任務，例如角色管理、資料庫創建、備份和恢復
- 應用 psql 命令行工具和 pgAdmin 圖形管理工具
- 探索 PostgreSQL 表格、約束和索引
- 學習在其他資料庫中通常找不到的強大 SQL 結構
- 使用多種不同的語言來編寫資料庫函數
- 調整查詢以便在硬體允許的範圍內運行得更快
- 使用外部資料包裝器查詢外部和多樣化的資料來源
- 學習如何使用內建的複製功能來複製資料

類似商品