Procedural Programming with PostgreSQL PL/pgSQL : Design Complex Database-Centric Applications with PL/pgSQL - Baji Shaik

Instant online reading.
Don't wait for delivery!

Procedural Programming with PostgreSQL PL/pgSQL

Design Complex Database-Centric Applications with PL/pgSQL

By: Baji Shaik, Dinesh Kumar Chemuduru

Write A Review

Paperback | 31 October 2023

At a Glance

Paperback
338 Pages

Dimensions(cm)
25.4 x 17.8 x 1.78

Paperback

RRP $89.99

$89.75

or 4 interest-free payments of $22.44 with

or

Ships in 15 to 25 business days

Learn the fundamentals of PL/PGSQL, the programming language of PostgreSQL which is most robust Open Source Relational Database. This book provides practical insights into developing database code objects such as functions and procedures, with a focus on effectively handling strings, numbers, and arrays to achieve desired outcomes, and transaction management.

The unique approach to handling Triggers in PostgreSQL ensures that both functionality and performance are maintained without compromise. You'll gain proficiency in writing inline/anonymous server-side code within the limitations, along with learning essential debugging and profiling techniques. Additionally, the book delves into statistical analysis of PL/PGSQL code and offers valuable knowledge on managing exceptions while writing code blocks.

Finally, you'll explore the installation and configuration of extensions to enhance the performance of stored procedures and functions.

What You'll Learn

Understand the PL/PGSQL concepts
Learn to debug, profile, and optimize PL/PGSQL code
Study linting PL/PGSQL code
Review transaction management within PL/PGSQL code
Work with developer friendly features like operators, casts, and aggregators

Who Is This Book For

App developers, database migration consultants, and database administrators.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.