PostgreSQL Developer's Guide

by Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad

Design, develop, and implement streamlined databases with PostgreSQL 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 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.

248 pages, Paperback

First published February 27, 2015

Reviews

[* ^ · Rating 4 out of 5]

Very instructive book with a lot of code inside. A lot of useful concepts covered.

[Amrullah Zunzunia · Rating 5 out of 5]

A good book to learn PostgreSQL, (Although it expects you to be familiar with concepts of RDBMS)