{"product_id":"procedural-programming-with-postgresql-pl-pgsql-design-complex-database-centric-applications-with-pl-pgsql-paperback","title":"Procedural Programming with PostgreSQL Pl\/Pgsql: Design Complex Database-Centric Applications with Pl\/Pgsql - Paperback","description":"\u003cp\u003eby \u003cb\u003eBaji Shaik\u003c\/b\u003e (Author), \u003cb\u003eDinesh Kumar Chemuduru\u003c\/b\u003e (Author)\u003c\/p\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\u003eBack Jacket\u003c\/h3\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.\u003c\/p\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. \u003cp\u003e\u003c\/p\u003e\u003cp\u003eFinally, you'll explore the installation and configuration of extensions to enhance the performance of stored procedures and functions.\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e \u003cp\u003e You will: \u003c\/p\u003e\u003cp\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\u003c\/p\u003e\u003cbr\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eBaji Shaik\u003c\/strong\u003e is a Senior Database Consultant with AWS Professional Services. He was introduced to databases in 2011 and over the years have worked with Oracle, PostgreSQL, Postgres Advance Server, RedShift, and Greenplum. His background spans a wide depth and breadth of expertise and experience in SQL\/NoSQL database technologies. He is a Database Migration Expert and has developed many successful database solutions addressing challenging business requirements for moving databases from on-premises to Amazon RDS and Aurora PostgreSQL\/MySQL and worked on tuning the RDS\/Aurora PostgreSQL\/MySQL databases to perform up to the mark. He is an author, having written several books on PostgreSQL. A few of his recent works include \"PostgreSQL Configuration\", \"Beginning PostgreSQL on the Cloud\", and \"PostgreSQL Development Essentials\". Furthermore, he has delivered several conferences, and workshop sessions and published many blogs within the AWS blog community.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eDinesh Chemuduru\u003c\/strong\u003e is working as Principal Architect (OSS). He also worked at AWS as a database consultant and he has done many database migrations successfully. He contributed to a few Open Source solutions and built extensions around PostgreSQL. He loves to code in Flutter\/Golang\/C++ and deploys them into Kubernetes.\u003cbr\u003e\u003c\/p\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 316\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.7 x 10 x 7 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eIllustrated:\u003c\/strong\u003e Yes\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e October 31, 2023\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42705245995071,"sku":"9781484298398","price":71.26,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0105\/8226\/1823\/files\/26678e9d7e2b24352758e111dcd2c171.webp?v=1765036092","url":"https:\/\/dhlswag.com\/products\/procedural-programming-with-postgresql-pl-pgsql-design-complex-database-centric-applications-with-pl-pgsql-paperback","provider":"BBB","version":"1.0","type":"link"}