Learn PostgreSQL - Second Edition: Use, manage and build secure and scalable databases with PostgreSQL 16

This new edition will help you learn PostgreSQL from scratch with the latest version, providing a complete focused view on aspects like configuration, high performance, partitioning, backup, server-side programming and replication.

Purchase of the print or Kindle book includes a free eBook in PDF format.

Key Features:

• Learn the fundamentals of PostgreSQL 16, including SQL statements, replication, and security
• Enhance your learning journey with the provided Docker images for practical hands-on exercises and tests at the end of each chapter
• Get new and improved examples, use-cases, and scenarios specifically for concepts like partitioning, replication, back-up and restore, cluster configuration, monitoring and others

Book Description:

The latest edition of this PostgreSQL book will help you to start using PostgreSQL from absolute scratch, helping you to quickly understand the internal workings of the database. With a structured approach and practical examples, go on a journey that covers the basics, from SQL statements and how to run server-side programs, to configuring, managing, securing, and optimizing database performance.

This new edition will not only help you get to grips with all the recent changes within the PostgreSQL ecosystem but will also dig deeper into concepts like partitioning and replication with a fresh set of examples. The book is also equipped with Docker images for each chapter which makes the learning experience faster and easier. Starting with the absolute basics of databases, the book sails through to advanced concepts like window functions, logging, auditing, extending the database, configuration, partitioning, and replication. It will also help you seamlessly migrate your existing database system to PostgreSQL and contains a dedicated chapter on disaster recovery. Each chapter ends with practice questions to test your learning at regular intervals.

By the end of this book, you will be able to install, configure, manage, and develop applications against a PostgreSQL database.

What You Will Learn:

• Gain a deeper understanding of PostgreSQL internals like transactions, MVCC, security and replication
• Enhance data management with PostgreSQL's latest partitioning features
• Choose the right replication strategy for your database
• See concrete examples of how to migrate data from another database, perform backups and restores, monitor your PostgreSQL installation and more
• Ensure security and compliance with schemas and user privileges
• Create customized database functions and extensions
• Get to grips with server-side programming, window functions, and triggers

Who this book is for:

Learning PostgresSQL 16 book is for anyone interested in learning about the PostgreSQL database from scratch. Anyone looking to build robust data warehousing applications and scale the database for high-availability and performance using the latest features of PostgreSQL will also find this book useful. Although prior knowledge of PostgreSQL is not required, familiarity with databases is expected.

這本新版書籍將幫助您從頭開始學習最新版本的PostgreSQL，提供完整的配置、高性能、分區、備份、伺服器端程式設計和複寫等方面的專注視角。

購買印刷版或Kindle電子書將包含一本免費的PDF格式電子書。

主要特點：
- 學習PostgreSQL 16的基礎知識，包括SQL語句、複寫和安全性
- 通過提供的Docker映像進行實際的實踐性手動練習和測試，增強學習過程
- 獲得新的和改進的示例、用例和場景，專門針對分區、複寫、備份和還原、集群配置、監控等概念

書籍描述：
這本PostgreSQL書籍的最新版本將幫助您從零開始使用PostgreSQL，幫助您快速理解數據庫的內部運作。通過結構化的方法和實際示例，您將學習從SQL語句和如何運行伺服器端程式，到配置、管理、保護和優化數據庫性能的基礎知識。

這本新版書籍不僅將幫助您掌握PostgreSQL生態系統中的所有最新變化，還將通過一組新的示例更深入地探討分區和複寫等概念。該書還配備了每章的Docker映像，使學習體驗更快速、更輕鬆。從數據庫的絕對基礎開始，本書涵蓋了窗口函數、日誌記錄、審計、擴展數據庫、配置、分區和複寫等高級概念。書中還包含一章專門介紹災難恢復。每章結束時都有練習問題，以定期測試您的學習成果。

通過閱讀本書，您將能夠安裝、配置、管理和開發針對PostgreSQL數據庫的應用程式。

您將學到什麼：
- 深入了解PostgreSQL的內部運作，如事務、MVCC、安全性和複寫
- 通過PostgreSQL的最新分區功能增強數據管理能力
- 為您的數據庫選擇合適的複寫策略
- 看到如何從其他數據庫遷移數據、執行備份和還原、監控PostgreSQL安裝等具體示例
- 通過模式和使用者權限確保安全性和合規性
- 創建自定義數據庫函數和擴展
- 掌握伺服器端程式設計、窗口函數和觸發器

本書適合對從頭開始學習PostgreSQL數據庫感興趣的任何人。任何希望構建強大的數據倉儲應用程式並使用PostgreSQL的最新功能實現高可用性和性能的人也會發現本書很有用。雖然不需要事先了解PostgreSQL，但需要熟悉數據庫的基本概念。