國立高雄大學圖資館 |

Language: English

Back

Procedural programming with PostgreSQL PL/pgSQLdesign complex database-centric applications with PLpl/pgSQL /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Procedural programming with PostgreSQL PL/pgSQLby Baji Shaik, Dinesh Kumar Chemuduru.
Reminder of title:	design complex database-centric applications with PLpl/pgSQL /
Author:	Shaik, Baji.
other author:	Chemuduru, Dinesh Kumar.
Published:	Berkeley, CA :Apress :2023.
Description:	xix, 316 p. :ill., digital ;24 cm.
Contained By:	Springer Nature eBook
Subject:	Procedure calls (Computer programming)
Online resource:	https://doi.org/10.1007/978-1-4842-9840-4
ISBN:	9781484298404$q(electronic bk.)

Procedural programming with PostgreSQL PL/pgSQLdesign complex database-centric applications with PLpl/pgSQL /
Shaik, Baji.

Procedural programming with PostgreSQL PL/pgSQLdesign complex database-centric applications with PLpl/pgSQL /[electronic resource] :by Baji Shaik, Dinesh Kumar Chemuduru. - Berkeley, CA :Apress :2023. - xix, 316 p. :ill., digital ;24 cm.

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. You will: 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.

ISBN: 9781484298404$q(electronic bk.)

Standard No.: 10.1007/978-1-4842-9840-4doiSubjects--Uniform Titles:

PostgreSQL.
Subjects--Topical Terms:

962977
Procedure calls (Computer programming)

LC Class. No.: QA76.6 / .S535 2023

Dewey Class. No.: 005.71

Procedural programming with PostgreSQL PL/pgSQLdesign complex database-centric applications with PLpl/pgSQL /
LDR:02257nmm a2200313 a 4500 001 652446
003 DE-He213
005 20231030172502.0
006 m d
007 cr nn 008maaau
008 240327s2023 cau s 0 eng d
020 $a 9781484298404$q(electronic bk.)
020 $a 9781484298398$q(paper)
024 7 $a 10.1007/978-1-4842-9840-4 $2 doi
035 $a 978-1-4842-9840-4
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.6 $b .S535 2023
072 7 $a UMX $2 bicssc
072 7 $a COM000000 $2 bisacsh
072 7 $a UMX $2 thema
082 0 4 $a 005.71 $2 23
090 $a QA76.6 $b .S526 2023
100 1 $a Shaik, Baji. $3 810305
245 1 0 $a Procedural programming with PostgreSQL PL/pgSQL $h [electronic resource] : $b design complex database-centric applications with PLpl/pgSQL / $c by Baji Shaik, Dinesh Kumar Chemuduru.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2023.
300 $a xix, 316 p. : $b ill., digital ; $c 24 cm.
520 $a 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. You will: 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.
630 0 0 $a PostgreSQL. $3 217128
650 0 $a Procedure calls (Computer programming) $3 962977
650 0 $a Relational databases. $3 214969
650 1 4 $a Programming Language. $3 913494
650 2 4 $a Open Source. $3 758930
650 2 4 $a Database Management System. $3 914921
700 1 $a Chemuduru, Dinesh Kumar. $3 962976
710 2 $a SpringerLink (Online service) $3 273601
773 0 $t Springer Nature eBook
856 4 0 $u https://doi.org/10.1007/978-1-4842-9840-4
950 $a Professional and Applied Computing (SpringerNature-12059)