
PostgreSQL Developer's Guide
PostgreSQL Developer's Guide
Packt Publishing
Published on 27. February 2015
Book
Paperback/Softback
270 pages
978-1-78398-902-7 (ISBN)
Description
Key Features
Book DescriptionWhat you will learn
Who this book is for
Book DescriptionWhat you will learn
Who this book is for
More details
Language
English
Place of publication
Birmingham
United Kingdom
Dimensions
Height: 235 mm
Width: 191 mm
Thickness: 15 mm
Weight
510 gr
ISBN-13
978-1-78398-902-7 (9781783989027)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
Ibrar Ahmed is a senior database architect in an Enterprise PostgreSQL company. He started his development career in 1999. He has contributed to the PostgreSQL community, the company's PostgreSQL fork, and other open source communities such as Google Chrome. He also has experience in MySQL, Oracle, MongoDB and Hadoop (Hive, Hbase, Spark). He is a major contributor in integrating other databases with PostgreSQL. He also authored PostgreSQL Developer's Guide. He has a master's in computer science (1999) and MS in computer engineering (2015), and is finalizing his PhD. Achim Vannahme works as a senior software developer at a mobile messaging operator, where he focuses on software quality and test automation. He holds a degree in computer science and has over 10 years of experience in using Java and PostgreSQL in distributed and high-performance applications. Amjad Shahzad has been working in the open source software industry for the last 10 years. He is currently working as a senior quality assurance engineer at a leading PostgreSQL-based company, which is the only worldwide provider of enterprise-class products and services based on PostgreSQL. Amjad's core expertise lies in the areas of pg_upgrade, slony and streaming replication, Cloud database, and database partitioning. His future endeavors include exploring PostgreSQL replication solutions. Apart from his professional activities, he is also involved in doing social activities that involve helping people stand on their feet. In his free time, he likes to explore nature by doing outdoor activities, including hiking, trekking, and nature photography. Salahaldin Juba has over than a decade of experience in the industry and academia, with a focus on database development for large-scale and enterprise applications. He holds a master's degree of science in environmental management with a distinction, and a bachelor's degree of engineering in computer systems. He is also a Microsoft Certified Solution Developer (MCSD).
He has worked mainly with SQL server, PostgreSQL, and Greenplum databases. As a software engineer, he works mainly with defining ETL processes with external parties, promoting SQL best practices, designing OLTP and OLAP applications, and providing training and consultation services.
He has worked mainly with SQL server, PostgreSQL, and Greenplum databases. As a software engineer, he works mainly with defining ETL processes with external parties, promoting SQL best practices, designing OLTP and OLAP applications, and providing training and consultation services.
Content
Table of Contents
Getting Started with PostgreSQL
The Procedural Language
Indexes
Triggers, Rules and Views
Window Functions
Partitioning
Query Optimization
Dealing With Large Objects
Communicating PostgreSQL Using LibPQ
Embedded SQL in C (ECPG)
Foreign Data Wrapper
Extensions
Getting Started with PostgreSQL
The Procedural Language
Indexes
Triggers, Rules and Views
Window Functions
Partitioning
Query Optimization
Dealing With Large Objects
Communicating PostgreSQL Using LibPQ
Embedded SQL in C (ECPG)
Foreign Data Wrapper
Extensions