{"product_id":"9781484298398-procedural-programming-wpostg","title":"Procedural Programming with PostgreSQL PL\/pgSQL","description":"\u003cmeta content=\"text\/html; charset=utf-8\" http-equiv=\"Content-Type\"\u003e\u003cp\u003e\u003cspan\u003eDesign Complex Database-Centric Applications with PL\/pgSQL\u003cbr\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\n\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\n\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\n\u003cp\u003e\u003cstrong\u003eWhat You'll Learn\u003c\/strong\u003e\u003cbr\u003e\u003c\/p\u003e\n\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\n\u003cp\u003e\u003cstrong\u003eWho Is This Book For\u003c\/strong\u003e\u003cbr\u003e\u003c\/p\u003e\n\u003cp\u003eApp developers, database migration consultants, and database administrators.\u003c\/p\u003e\n\u003cbr\u003e\u003cbr\u003e\u003c\/span\u003e\u003c\/p\u003e","brand":"Rarewaves","offers":[{"title":"Default Title","offer_id":53528089690486,"sku":"9781484298398","price":40.36,"currency_code":"GBP","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0092\/7504\/8033\/files\/stand_16903580_jpg.jpg?v=1728408534","url":"https:\/\/www.rarewaves.com\/products\/9781484298398-procedural-programming-wpostg","provider":"Rarewaves.com","version":"1.0","type":"link"}