Learn PostgreSQL

Ferrari, Luca, Pirozzi, Enrico

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

商品描述

PostgreSQL is one of the fastest-growing open source object-relational database management systems (DBMS) in the world. As well as being easy to use, it's scalable and highly efficient. In this book, you'll explore PostgreSQL 12 and 13 and learn how to build database solutions using it. Complete with hands-on tutorials, this guide will teach you how to achieve the right database design required for a reliable environment.

You'll learn how to install and configure a PostgreSQL server and even manage users and connections. The book then progresses to key concepts of relational databases, before taking you through the Data Definition Language (DDL) and commonly used DDL commands. To build on your skills, you'll understand how to interact with the live cluster, create database objects, and use tools to connect to the live cluster. You'll then get to grips with creating tables, building indexes, and designing your database schema. Later, you'll explore the Data Manipulation Language (DML) and server-side programming capabilities of PostgreSQL using PL/pgSQL, before learning how to monitor, test, and troubleshoot your database application to ensure high-performance and reliability.

By the end of this book, you'll be well-versed with the Postgres database and be able to set up your own PostgreSQL instance and use it to build robust solutions.

商品描述(中文翻譯)

PostgreSQL是全球增長最快的開源物件關聯式資料庫管理系統(DBMS)之一。除了易於使用外,它還具有可擴展性和高效能。在這本書中,您將探索PostgreSQL 12和13,並學習如何使用它來建立資料庫解決方案。這本指南配有實踐教程,將教您如何實現可靠環境所需的正確資料庫設計。

您將學習如何安裝和配置PostgreSQL伺服器,甚至管理使用者和連線。本書隨後介紹關聯式資料庫的關鍵概念,然後帶您了解資料定義語言(DDL)和常用的DDL指令。為了提升您的技能,您將了解如何與實時叢集互動,創建資料庫物件,並使用工具連接到實時叢集。然後,您將熟悉如何創建表格,建立索引,並設計資料庫架構。稍後,您將探索PostgreSQL使用PL/pgSQL的資料操作語言(DML)和伺服器端程式設計能力,然後學習如何監控、測試和疑難排解資料庫應用程式,以確保高效能和可靠性。

通過閱讀本書,您將熟悉Postgres資料庫,能夠設置自己的PostgreSQL實例並使用它來建立強大的解決方案。