Introduction to PL/pgSQL Development

Tuesday 2:00PM - 5:00PM

@ Hill Country B

PostgreSQLMySQL/MariaDBOpen Source Databases

3 hours tutorial

Beginner

Tracks:
Observability & Monitoring, MySQL

When developing against a PostgreSQL database, many times you will use SQL from your applications, but sometimes you need more. You might need to run some of your logic on the database server for performance or you may want to just create some server-side functions to simplify your application development. There is an infinite number of reasons why you would want to write some code that runs on the PostgreSQL server and PostgreSQL has a rich set of options when you want to do that, but most times, you will use PL/pgSQL. The primary objective of this tutorial is to introduce you to the PostgreSQL PL/pgSQL programming language and to give you the practical skills to be a productive developer working with PostgreSQL databases.

In the course of this tutorial, you will be introduced to a variety of fundamental PL/pgSQL functions like:
* How to declare and use PL/SQL Variables
* How to create functions and procedures
* How to write triggers
* Handle run time errors

And much more...


Speakers

Jim Mlodgenski

Jim Mlodgenski (Amazon Web Services)

Principal Database Engineer

Biography:

Principal database engineer at Amazon Web Services, Co-Chair - PGConf US, Director - United States PostgreSQL, Co-organizer of Philly PUG & NYC PUG, former CTO at OpenSCG


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863