{"product_id":"procedural-programming-with-postgresql-plpgsql-design-complex-database-centric-applications-with-plpgsql-9781484298398","title":"Procedural Programming with PostgreSQL Pl\/Pgsql: Design Complex Database-Centric Applications with Pl\/Pgsql","description":"\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\u003cbr\u003e\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Apress\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 10\/31\/2023\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9781484298398\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 316\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 1.29lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 10.00h x 7.00w x 0.70d","brand":"Baji Shaik, Dinesh Kumar Chemuduru","offers":[{"title":"Default Title","offer_id":43271868252341,"sku":"9781484298398","price":46.74,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0473\/0804\/6492\/files\/img_f4617611-74ca-42c9-a9c7-ad39bed6b3d8.jpg?v=1699957907","url":"https:\/\/pastforward.org\/products\/procedural-programming-with-postgresql-plpgsql-design-complex-database-centric-applications-with-plpgsql-9781484298398","provider":"Past Forward","version":"1.0","type":"link"}