At the core of a PostgresSQL database developer’s toolkit is a thorough knowledge of how to build correct, efficient functions. In this course, Capturing Logic with Custom Functions in PostgreSQL, you will learn foundational knowledge of how to build your own functions in PostgreSQL. First, you will learn how to move from a basic query to a fully-parameterized function. Next, you will discover how to write your functions using PL/pgSQL, one of the many procedural languages available to the PostgreSQL developer. Finally, you will explore important matters relating to polymorphism, security, defensive programming and error handling. When you are finished, you will be able to solve real-world problems using PostgresSQL functions.
Author Name: Gerald Britton
Author Description:
Gerald Britton is a Pluralsight author and expert on Python programming practices and Microsoft SQL Server development and administration. A multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater).

Table of Contents

• Course Overview
  1min
• Introduction
  12mins
• Creating Your First Function
  12mins
• Creating Functions in PL/pgSQL
  29mins
• Creating Polymorphic Functions to Control Repetition
  14mins
• Protecting Your Database by Securing Your Functions
  17mins
• Defending Your Database and Handling Errors
  19mins
• Course Summary
  7mins