Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL 1st Edition Baji Shaik

Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL 1st Edition Baji Shaik – Ebook Instant Download/Delivery ISBN(s): 9781484298398,148429839X,B0CHLBQ323, 9781484298404, 1484298403

Product details:
• ISBN 10: 1484298403
• ISBN 13: 9781484298404
• Author: Baji Shaik, Dinesh Kumar Chemuduru

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.

Table contents:

1. Introduction to PL/pgSQL

2. PL/pgSQL Variables

3. PL/pgSQL Data Types

4. Dealing with Strings, Numbers, and Arrays

5. Control Statements

6. Handling Arrays

7. Handling JSON

8. Cursors

9. Custom Operators

10. Custom Casting

11. Dynamic SQL

12. Building Functions and Procedures

13. Return Values and Parameters

14. Handling Exceptions

15. Triggers

16. Transaction Management

17. Aggregates

18. Listen and Notify

19. PL/pgSQL Essential Extensions

People also search:

complex database design examples

complex database design

postgresql table design best practices

postgres create user interactive

postgresql concepts