PostgreSQL Developer’s Guide

Book Description

, develop, and implement streamlined 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 using PostgreSQL, this is the book for you. Existing knowledge of basic database concepts and some experience is required

In Detail

PostgreSQL is an -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 examples. Lastly, you will explore foreign data wrappers, implementing extensibility, and improving maintainability.

Table of Contents

Chapter 1. Getting Started with PostgreSQL
Chapter 2. The Procedural Language
Chapter 3. Working with Indexes
Chapter 4. Triggers, Rules, and Views
Chapter 5. Window Functions
Chapter 6. Partitioning
Chapter 7. Query Optimization
Chapter 8. Dealing with Large Objects
Chapter 9. Communicating with PostgreSQL Using LibPQ
Chapter 10. Embedded SQL in C – ECPG
Chapter 11. Foreign Data Wrapper
Chapter 12. Extensions

Book Details

Download LinkFormatSize (MB)Upload Date
Download from UpLoadedPDF, EPUB1.801/05/2017
Download from ZippySharePDF, EPUB1.812/05/2016
How to Download? Report Dead Links & Get a Copy