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

Name: Procedural Programming with PostgreSQL PL/pgSQL
Brand: APress
SKU: 9781484298398
Price: 9000 KES
Availability: OutOfStock
ISBN: 9781484298398

by Baji Shaik , Dinesh Kumar Chemuduru

Book Details

Format Paperback / softback

ISBN-10 148429839X

ISBN-13 9781484298398

Publisher APress

Imprint APress

Country of Manufacture GB

Country of Publication GB

Publication Date Oct 31st, 2023

Print length 316 Pages

Product Classification: Operating systems Programming & scripting languages: general Programming and scripting languages: general Databases Databases / Data management

KSh 9,000.00

Currently unavailable 0 in stock

Delivery Location

County

Location

Delivery fee: Select location

Secure

Quality

Fast

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.

Get Procedural Programming with PostgreSQL PL/pgSQL by Baji Shaik, Dinesh Kumar Chemuduru at the best price and quality guaranteed only at Werezi Africa's largest book ecommerce store. The book was published by APress and it has 316 pages.