Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL
Language: English
Published by Apress, 2023
- Softcover
- New

Seller: Kennys Bookshop and Art Galleries Ltd., Galway, GY, IrelandKennys Bookshop and Art Galleries Ltd.
AbeBooks seller since February 27, 2001
Condition: New
US$ 56.71
Quantity: 15 available
Add to basketItem description from seller
2023. Paperback. . . . . .
Seller Inventory # V9781484298398
- Title
- Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL
- Author
- Shaik, Baji, Chemuduru, Dinesh Kumar
- Publisher
- Apress
- Publication year
- 2023
- Condition
- New
- Binding
- Soft cover
- Language
- English
- ISBN 10
- 148429839X
- ISBN 13
- 9781484298398
Learn 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.
The 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.
Finally, you'll explore the installation and configuration of extensions to enhance the performance of stored procedures and functions.What You'll Learn
- Understand the PL/PGSQL concepts
- Learn to debug, profile, and optimize PL/PGSQL code
- Study linting PL/PGSQL code
- Review transaction management within PL/PGSQL code
- Work with developer friendly features like operators, casts, and aggregators
Who Is This Book For
App developers, database migration consultants, and database administrators.
"Synopsis" may belong to another edition of this title.
About the Author
Baji Shaik 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.
Dinesh Chemuduru 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.
"About the title" may belong to another edition of this title.
Kennys Bookshop and Art Galleries Ltd.
Galway, GY, Ireland
AbeBooks seller since February 27, 2001
Shipping rates from Ireland to U.S.A.
| Item | 12 to 22 business days | 10 to 20 business days |
|---|---|---|
| First item | US$ 10.47 | US$ 12.68 |
Payment methods
Store description
Kennys.ie is the largest exporter of books from Ireland currently exporting to approximately 100 countries around the world. Kennys Bookshop houses hundreds of thousands of books and specialises in collection development and library services, supplying booksellers and state and university libraries on a global scale including the U.S.A.,Japan and Europe. Kennys.ie is Ireland's Largest Online Bookshop.
Specialty
Asia, All Aspects of the Irish Experience, Irish Literature, Irish History, Human Rights, International Espionage, History of Ideas and Human Thought, Labour History, Jewish Studies and the Holocaust. Gureilla Movements., Russian and Soviet History and Literature. Womens Studies and Feminism.Seller's business information
Kennys Bookshop and Art Galleries (Holdings) Limited
Liosbán Retail Park, Tuam Road
Galway, Ireland H91 N5P8
Terms of sale
Terms of Sale - Credit Cards: Visa, Master Card, American Express, Diner.
Payment can also be made by bank draft in Euros, drawn on an Irish Bank.
We regret that PO Boxes are not acceptable to the U.S. as our courier will not deliver to them.
In case of returns or queries please contact us by email books@kennys.ie or by phone +353 91 709350
VAT Registration - IE2238521A
Conor Kenny
Shipping terms
Free Shipping