PostgreSQL Developer s Guide

Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad

PostgreSQL Developer s Guide
  • 出版商: Packt Publishing
  • 出版日期: 2015-02-27
  • 售價: $1,740
  • 貴賓價: 9.5 折 $1,653
  • 語言: 英文
  • 頁數: 201
  • 裝訂: Paperback
  • ISBN: 1783989025
  • ISBN-13: 9781783989027
  • 相關分類: PostgreSQL、SQL

    • 下單後立即進貨 (約3~4週)

商品描述

Design, develop, and implement streamlined databases with PostgreSQL

About This Book

  • Design efficient, real-world database solutions and extend your knowledge of database concepts
  • Learn how to program using native PostgreSQL procedural languages to write custom functions
  • Explore database partitioning and learn about query optimization techniques

Who This Book Is For

If you are a database developer who wants to learn how to design and implement databases for application development using PostgreSQL, this is the book for you. Existing knowledge of basic database concepts and some programming experience is required

What You Will Learn

  • Refresh your knowledge of SQL with PostgreSQL-supported DDL and DML
  • Explore native PostgreSQL procedural languages and learn how to write custom functions
  • Leverage the power of indexes for optimal database efficiency
  • Unfold tricky trigger concepts and implement them in native procedural languages
  • Discover how to implement views, partitioned tables, and window functions in PostgreSQL
  • Design efficient queries with query optimization and query analysis
  • Communicate with PostgreSQL servers using foreign data wrappers such as LibPQ and ECPG
  • Extend database powers using foreign data wrappers and achieve maintainability via PostgreSQL extensions

In Detail

PostgreSQL is an enterprise-level database that competes among proprietary database vendors, owing to its remarkable feature set and reliability without the expensive licensing overhead.

This book is a comprehensive and pragmatic guide to developing databases in PostgreSQL. Beginning with a refresher of basic SQL skills, you will gradually be exposed to advanced concepts, such as learning how to program in native PostgreSQL procedural languages, implementing triggers, custom functions, and views. You will learn database optimization techniques such as query optimization and indexing while exploring extensive code examples. Lastly, you will explore foreign data wrappers, implementing extensibility, and improving maintainability.

商品描述(中文翻譯)

設計、開發和實施具有PostgreSQL的精簡數據庫

關於本書



  • 設計高效的現實世界數據庫解決方案，擴展數據庫概念知識

  • 學習使用原生的PostgreSQL程序語言編寫自定義函數

  • 探索數據庫分區並學習查詢優化技術

本書適合對象


如果您是一位數據庫開發人員，想要學習如何使用PostgreSQL設計和實施應用程序開發的數據庫，那麼這本書適合您。需要具備基本數據庫概念知識和一些編程經驗。

您將學到什麼



  • 使用PostgreSQL支持的DDL和DML刷新SQL知識

  • 探索原生的PostgreSQL程序語言並學習如何編寫自定義函數

  • 利用索引的威力實現最佳數據庫效能

  • 揭示棘手的觸發器概念並在原生程序語言中實現它們

  • 在PostgreSQL中實現視圖、分區表和窗口函數

  • 使用查詢優化和查詢分析設計高效的查詢

  • 使用LibPQ和ECPG等外部數據包裝器與PostgreSQL服務器通信

  • 使用外部數據包裝器擴展數據庫功能並通過PostgreSQL擴展實現可維護性

詳細內容


PostgreSQL是一個企業級數據庫，由於其卓越的功能集和可靠性，與專有數據庫供應商競爭，而無需昂貴的許可費用。


本書是一本全面而實用的PostgreSQL數據庫開發指南。從基本SQL技能的複習開始，您將逐漸接觸到高級概念，例如學習如何使用原生的PostgreSQL程序語言編寫觸發器、自定義函數和視圖。在探索廣泛的代碼示例的同時，您將學習查詢優化和索引等數據庫優化技術。最後，您將探索外部數據包裝器，實現可擴展性和提高可維護性。

類似商品