*Take $10 off when you spend $50+! Use code NEWYEAR10. Ends Mon 5 Jan. T&Cs apply.
Track My Order
Help Centre
Likes
My Wish ListsLogin / Join
Booktopia
Australia's local bookstore
Get Free Shipping on orders over $79
Procedural Programming with PostgreSQL PL/pgSQL : Design Complex Database-Centric Applications with PL/pgSQL - Baji Shaik

Procedural Programming with PostgreSQL PL/pgSQL

Design Complex Database-Centric Applications with PL/pgSQL

By: Baji Shaik, Dinesh Kumar Chemuduru

eText | 30 October 2023

At a Glance

eText

$89.99

or 4 interest-free payments of $22.50 with

 or 

Instant online reading in your Booktopia eTextbook Library *

Why choose an eTextbook?

Instant Access *

Purchase and read your book immediately

Read Aloud

Listen and follow along as Bookshelf reads to you

Study Tools

Built-in study tools like highlights and more

* eTextbooks are not downloadable to your eReader or an app and can be accessed via web browsers only. You must be connected to the internet and have no technical issues with your device or browser that could prevent the eTextbook from operating.

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.

on
Desktop
Tablet
Mobile

You Can Find This eBook In

Non-FictionComputing & I.T.Computer ScienceDigital Lifestyle & Online World: Consumer & User GuidesInternet Guides & Online ServicesComputer Networking & CommunicationsComputer Programming & Software DevelopmentProgramming & Scripting LanguagesDatabases

More in Computer Programming & Software Development

The End of Leadership - Barbara Kellerman

eBOOK

The End of Leadership

eBook

$21.99

Addiction by Design : Machine Gambling in Las Vegas - Natasha Dow Schüll

eBOOK

Addiction by Design

Machine Gambling in Las Vegas

eBook

RRP $47.30

$37.99

20%
OFF

This product is categorised by