Mastering PostgreSQL 9.6 (Paperback)
暫譯: 精通 PostgreSQL 9.6 (平裝本)
Hans-Jurgen Schonig
- 出版商: Packt Publishing
- 出版日期: 2017-05-30
- 售價: $2,400
- 貴賓價: 9.5 折 $2,280
- 語言: 英文
- 頁數: 416
- 裝訂: Paperback
- ISBN: 1783555351
- ISBN-13: 9781783555352
-
相關分類:
PostgreSQL、SQL
-
相關翻譯:
由淺入深 PostgreSQL (Mastering PostgreSQL 9.6) (簡中版)
已過版
相關主題
商品描述
Key Features
- Your one-stop guide to mastering the advanced concepts in PostgreSQL with ease
- Master query optimization, replication, and high availability with PostgreSQL
- Extend the functionalities of PostgreSQL to suit your organizational needs with minimum effort
Book Description
PostgreSQL is an open source database management tool used for handling large datasets (big data) and as a JSON document database. It also has applications in the software and web domains. This book will enable you to build better PostgreSQL applications and administer databases more efficiently.
We begin by explaining the advanced database design concepts in PostgreSQL 9.6, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery and high availability, and much more. You will understand the common and not-so-common troubleshooting problems and how you can overcome them.
By the end of this book, you will have an expert-level command of the advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL.
What you will learn
- Explore the new features of PostgreSQL 9.6 and PostgreSQL 10.0
- See how to administer PostgreSQL effectively using a variety of methods
- Understand a variety of techniques to optimize your database to get a better performance
- Find out how to create a professional database cluster
- Get to know how to monitor PostgreSQL step by step
- Dive into advanced SQL and its features
商品描述(中文翻譯)
主要特點
- 您的一站式指南,輕鬆掌握 PostgreSQL 的進階概念
- 精通 PostgreSQL 的查詢優化、複製和高可用性
- 以最小的努力擴展 PostgreSQL 的功能以滿足您的組織需求
書籍描述
PostgreSQL 是一個開源的資料庫管理工具,用於處理大型數據集(大數據)以及作為 JSON 文件資料庫。它在軟體和網頁領域也有應用。本書將使您能夠構建更好的 PostgreSQL 應用程式並更有效地管理資料庫。
我們將從解釋 PostgreSQL 9.6 中的進階資料庫設計概念開始,並介紹索引和查詢優化。您還將學習如何使用事件觸發器,執行並發交易和表分區,並探索 SQL 和伺服器調優。我們將引導您實施進階管理任務,例如伺服器維護和監控、複製、恢復和高可用性等。您將了解常見和不常見的故障排除問題,以及如何克服它們。
在本書結束時,您將對進階資料庫功能有專家的掌握,並能夠使用 PostgreSQL 實施進階管理任務。
您將學到什麼
- 探索 PostgreSQL 9.6 和 PostgreSQL 10.0 的新功能
- 了解如何使用多種方法有效管理 PostgreSQL
- 理解多種技術以優化您的資料庫以獲得更好的性能
- 瞭解如何創建專業的資料庫集群
- 逐步了解如何監控 PostgreSQL
- 深入了解進階 SQL 及其功能