{"product_id":"procedural-programming-with-postgresql-plpgsql-baji-shaik-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\u003eAuthor:\u003c\/b\u003e Baji Shaik, Dinesh Kumar Chemuduru\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 148429839X\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781484298398\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Apress\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 10\/31\/2023\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 316\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\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","offers":[{"title":"Paperback","offer_id":45478580650239,"sku":"9781484298398","price":54.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_8790f8f8-349f-44cf-a40e-2ab34fffbcf6.jpg?v=1715935391","url":"https:\/\/www.whiterainbookhouse.com\/products\/procedural-programming-with-postgresql-plpgsql-baji-shaik-9781484298398","provider":"WR Book House","version":"1.0","type":"link"}