{"product_id":"9781484298398","title":"Procedural Programming with PostgreSQL PL\/pgSQL: Design Complex Database-Centric Applications with PL\/pgSQL","description":"\u003ch1\u003eProcedural Programming with PostgreSQL PL\/pgSQL: Design Complex Database-Centric Applications with PL\/pgSQL\u003c\/h1\u003e \u003ch2\u003eShaik, Baji; Chemuduru, Dinesh Kumar\u003c\/h2\u003e \u003cp\u003e\u003c\/p\u003e\u003cp\u003eLearn 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.\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eThe 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. \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003eFinally, you'll explore the installation and configuration of extensions to enhance the performance of stored procedures and functions.\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat You'll Learn\u003c\/strong\u003e\u003cbr\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eUnderstand the PL\/PGSQL concepts\u003c\/li\u003e\n\u003cli\u003eLearn to debug, profile, and optimize PL\/PGSQL code\u003c\/li\u003e\n\u003cli\u003eStudy linting PL\/PGSQL code\u003c\/li\u003e\n\u003cli\u003eReview transaction management within PL\/PGSQL code\u003c\/li\u003e\n\u003cli\u003eWork with developer friendly features like operators, casts, and aggregators\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eWho Is This Book For\u003c\/strong\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eApp developers, database migration consultants, and database administrators.\u003c\/p\u003e \u003ch3\u003eDetails\u003c\/h3\u003e \u003cp\u003ePublished by: Apress\u003c\/p\u003e \u003cp\u003ePublication Date: 2023-10-31\u003c\/p\u003e \u003cp\u003eFormat: Paperback\u003c\/p\u003e \u003cp\u003eISBN-13: 9781484298398\u003c\/p\u003e \u003cp\u003eDOI: 10.1007\/978-1-4842-9840-4\u003c\/p\u003e \u003cp\u003eDimensions: 254cm x178cm\u003c\/p\u003e \u003cp\u003ePages: 316\u003c\/p\u003e ","brand":"Apress","offers":[{"title":"Default Title","offer_id":44677150670988,"sku":"9781484298398","price":49.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0710\/9545\/1788\/files\/9781484298398.jpg?v=1776870161","url":"https:\/\/lateknightbooks.com\/products\/9781484298398","provider":"Late Knight Books and Services, LLC","version":"1.0","type":"link"}