PostgreSQL Development Essentials

Develop programmatic functions to create powerful database applications
Preview in Mapt
Code Files

PostgreSQL Development Essentials

Manpreet Kaur, Baji Shaik

3 customer reviews
Develop programmatic functions to create powerful database applications
Mapt Subscription
FREE
$29.99/m after trial
eBook
$16.00
RRP $31.99
Save 49%
Print + eBook
$39.99
RRP $39.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$16.00
$39.99
$29.99 p/m after trial
RRP $31.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


PostgreSQL Development Essentials Book Cover
PostgreSQL Development Essentials
$ 31.99
$ 16.00
PostgreSQL High Availability Cookbook - Second Edition Book Cover
PostgreSQL High Availability Cookbook - Second Edition
$ 43.99
$ 22.00
Buy 2 for $33.50
Save $42.48
Add to Cart

Book Details

ISBN 139781783989003
Paperback210 pages

Book Description

PostgreSQL is the most advanced open source database in the world. It is easy to install, configure, and maintain by following the documentation; however, it’s difficult to develop applications using programming languages and design databases accordingly. This book is what you need to get the most out of PostgreSQL

You will begin with advanced SQL topics such as views, materialized views, and cursors, and learn about performing data type conversions. You will then perform trigger operations and use trigger functions in PostgreSQL. Next we walk through data modeling, normalization concepts, and the effect of transactions and locking on the database.

The next half of the book covers the types of indexes, constrains, and the concepts of table partitioning, as well as the different mechanisms and approaches available to write efficient queries or code. Later, we explore PostgreSQL Extensions and Large Object Support in PostgreSQL. Finally, you will perform database operations in PostgreSQL using PHP and Java. By the end of this book, you will have mastered all the aspects of PostgreSQL development. You will be able to build efficient enterprise-grade applications with PostgreSQL by making use of these concepts

Table of Contents

Chapter 1: Advanced SQL
Creating views
Materialized views
Creating cursors
Using the GROUP BY clause
Using the HAVING clause
Using the UPDATE operation clauses
Using the LIMIT clause
Using subqueries
Subqueries that return multiple rows
Using the Union join
Using the Self join
Using the Outer join
Summary
Chapter 2: Data Manipulation
Conversion between datatypes
Introduction to arrays
Summary
Chapter 3: Triggers
Introduction to triggers
Creating a trigger function
Summary
Chapter 4: Understanding Database Design Concepts
Basic design rules
Normalization
Anomalies in DBMS
Summary
Chapter 5: Transactions and Locking
Defining transactions
Summary
Chapter 6: Indexes and Constraints
Introduction to indexes and constraints
Clustering on an index
Exclusion constraints
Summary
Chapter 7: Table Partitioning
Table partitioning
Summary
Chapter 8: Query Tuning and Optimization
Query tuning
Optimizer settings for cached data
Multiple ways to implement a query
Bad query performance with stale statistics
Explain Plan
Query operators
Summary
Chapter 9: PostgreSQL Extensions and Large Object Support
Creating an extension
Using binary large objects
Summary
Chapter 10: Using PHP in PostgreSQL
Postgres with PHP
PHP-to-PostgreSQL connections
Dealing with DDLs
DML operations
Data retrieval
Helper functions to deal with data fetching
Summary
Chapter 11: Using Java in PostgreSQL
Making database connections to PostgreSQL using Java
Using prepared statements
Connection properties
Summary

What You Will Learn

  • Write more complex queries with advanced SQL queries
  • Design a database that works with the application exactly the way you want
  • Make the database work in extreme conditions by tuning, optimizing, partitioning, and indexing
  • Develop applications in other programming languages such as Java and PHP
  • Use extensions to get extra benefits in terms of functionality and performance
  • Build an application that does not get locked by data manipulation
  • Explore in-built db functions and data type conversions

Authors

Table of Contents

Chapter 1: Advanced SQL
Creating views
Materialized views
Creating cursors
Using the GROUP BY clause
Using the HAVING clause
Using the UPDATE operation clauses
Using the LIMIT clause
Using subqueries
Subqueries that return multiple rows
Using the Union join
Using the Self join
Using the Outer join
Summary
Chapter 2: Data Manipulation
Conversion between datatypes
Introduction to arrays
Summary
Chapter 3: Triggers
Introduction to triggers
Creating a trigger function
Summary
Chapter 4: Understanding Database Design Concepts
Basic design rules
Normalization
Anomalies in DBMS
Summary
Chapter 5: Transactions and Locking
Defining transactions
Summary
Chapter 6: Indexes and Constraints
Introduction to indexes and constraints
Clustering on an index
Exclusion constraints
Summary
Chapter 7: Table Partitioning
Table partitioning
Summary
Chapter 8: Query Tuning and Optimization
Query tuning
Optimizer settings for cached data
Multiple ways to implement a query
Bad query performance with stale statistics
Explain Plan
Query operators
Summary
Chapter 9: PostgreSQL Extensions and Large Object Support
Creating an extension
Using binary large objects
Summary
Chapter 10: Using PHP in PostgreSQL
Postgres with PHP
PHP-to-PostgreSQL connections
Dealing with DDLs
DML operations
Data retrieval
Helper functions to deal with data fetching
Summary
Chapter 11: Using Java in PostgreSQL
Making database connections to PostgreSQL using Java
Using prepared statements
Connection properties
Summary

Book Details

ISBN 139781783989003
Paperback210 pages
Read More
From 3 reviews

Read More Reviews

Recommended for You

PostgreSQL High Availability Cookbook - Second Edition Book Cover
PostgreSQL High Availability Cookbook - Second Edition
$ 43.99
$ 22.00
PostgreSQL High Performance Cookbook Book Cover
PostgreSQL High Performance Cookbook
$ 43.99
$ 22.00
Learning PostgreSQL Book Cover
Learning PostgreSQL
$ 43.99
$ 22.00
PostgreSQL Administration Cookbook, 9.5/9.6 Edition Book Cover
PostgreSQL Administration Cookbook, 9.5/9.6 Edition
$ 47.99
$ 24.00
PostgreSQL 9.6 High Performance Book Cover
PostgreSQL 9.6 High Performance
$ 39.99
$ 20.00
Building RESTful Python Web Services Book Cover
Building RESTful Python Web Services
$ 39.99
$ 20.00