Learning PostgreSQL（Paperback）

Salahaldin Juba, Achim Vannahme, Andrey Volkov

Learning PostgreSQL（Paperback）
  • 出版商: Packt Publishing
  • 出版日期: 2015-11-30
  • 售價: $2,220
  • 貴賓價: 9.5 折 $2,109
  • 語言: 英文
  • 頁數: 464
  • 裝訂: Paperback
  • ISBN: 1783989181
  • ISBN-13: 9781783989188
  • 相關分類: PostgreSQL、SQL

    • 海外代購書籍(需單獨結帳)

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

商品描述

Create, develop and manage relational databases in real world applications using PostgreSQL

About This Book

  • Learn about the PostgreSQL development life cycle including its testing and refactoring
  • Build productive database solutions and use them in Java applications
  • A comprehensive guide to learn about SQL, PostgreSQL procedural language and PL/pgSQL

Who This Book Is For

If you are a student, database developer or an administrator, interested in developing and maintaining a PostgreSQL database, then this book is for you. No knowledge of database programming or administration is necessary.

What You Will Learn

  • Learn concepts of data modelling and relation algebra
  • Install and set up PostgreSQL database server and client software
  • Implement data structures in PostgreSQL
  • Manipulate data in the database using SQL
  • Implement data processing logic in the database with stored functions, triggers and views
  • Test database solutions and assess the performance
  • Integrate database with Java applications
  • Detailed knowledge of the main PostgreSQL building objects, most used extensions
  • Practice database development life cycle including analysis, modelling, (documentation), testing, bug fixes and refactoring

In Detail

PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. Also it provides NoSQL capabilities, and very rich data types and extensions. All that makes PostgreSQL a very attractive solution in various kinds of software systems.

The book starts with the introduction of relational databases with PostegreSQL. It then moves on to covering data definition language (DDL) with emphasis on PostgreSQL and common DDL commands supported by ANSI SQL. You will then learn the data manipulation language (DML), and advanced topics like locking and multi version concurrency control (MVCC). This will give you a very robust background to tune and troubleshoot your application. The book then covers the implementation of data models in the database such as creating tables, setting up integrity constraints, building indexes, defining views and other schema objects. Next, it will give you an overview about the NoSQL capabilities of PostgreSQL along with Hstore, XML, Json and arrays. Finally by the end of the book, you'll learn to use the JDBC driver and manipulate data objects in the Hibernate framework.

Style and approach

An easy-to-follow guide to learn programming build applications with PostgreSQL, and manage a PostgreSQL database instance.

商品描述(中文翻譯)

創建、開發和管理實際應用中的關聯式數據庫，使用PostgreSQL

關於本書



  • 了解PostgreSQL開發生命周期，包括測試和重構

  • 構建高效的數據庫解決方案並在Java應用程序中使用它們

  • 全面指南，學習SQL、PostgreSQL程序語言和PL/pgSQL

本書適合對象


如果您是學生、數據庫開發人員或管理員，有興趣開發和維護PostgreSQL數據庫，那麼本書適合您。不需要具備數據庫編程或管理知識。

您將學到什麼



  • 學習數據建模和關聯代數的概念

  • 安裝和設置PostgreSQL數據庫服務器和客戶端軟件

  • 在PostgreSQL中實現數據結構

  • 使用SQL操作數據庫中的數據

  • 使用存儲函數、觸發器和視圖在數據庫中實現數據處理邏輯

  • 測試數據庫解決方案並評估性能

  • 將數據庫與Java應用程序集成

  • 詳細了解主要的PostgreSQL構建對象和最常用的擴展

  • 實踐數據庫開發生命周期，包括分析、建模、（文檔）、測試、錯誤修復和重構

詳細內容


PostgreSQL是最強大且易於使用的數據庫管理系統之一。它得到了社區的大力支持，每年都有新版本的積極開發。PostgreSQL支持SQL標準中包含的最先進功能。此外，它還提供NoSQL功能，以及非常豐富的數據類型和擴展。所有這些使PostgreSQL成為各種軟件系統中非常有吸引力的解決方案。

本書以介紹使用PostgreSQL的關聯式數據庫開始。然後，它涵蓋了數據定義語言（DDL），重點介紹了PostgreSQL和ANSI SQL支持的常用DDL命令。然後，您將學習數據操作語言（DML）以及鎖定和多版本並發控制（MVCC）等高級主題。這將為您提供非常強大的背景，以調整和疑難解答應用程序。本書還涵蓋了在數據庫中實現數據模型的內容，例如創建表、設置完整性約束、構建索引、定義視圖和其他模式對象。接下來，它將為您概述PostgreSQL的NoSQL功能，以及Hstore、XML、Json和數組。最後，在本書結尾，您將學習使用JDBC驅動程序並在Hibernate框架中操作數據對象。

風格和方法


這是一本易於理解的指南，教您使用PostgreSQL進行編程、構建應用程序，以及管理PostgreSQL數據庫實例。

類似商品