Capturing Logic with Custom Functions in PostgreSQL

Whether you are getting into PostgreSQL for the first time or an experienced developer wanting to explore function-writing more deeply, this course is for you. You will learn foundational knowledge of how to build your own functions in PostgreSQL.
Course info
Level
Intermediate
Updated
Mar 20, 2020
Duration
1h 54m
Table of contents
Course Overview
Introduction
Creating Your First Function
Creating Functions in PL/pgSQL
Creating Polymorphic Functions to Control Repetition
Protecting Your Database by Securing Your Functions
Defending Your Database and Handling Errors
Course Summary
Description
Course info
Level
Intermediate
Updated
Mar 20, 2020
Duration
1h 54m
Description

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.

About the author
About the author

Gerald is 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). 

More from the author
SSIS Database Maintenance Playbook
Advanced
1h 10m
Jun 26, 2020
PostgreSQL Functions Playbook
Advanced
2h 28m
Dec 10, 2019
More courses by Gerald Britton
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is Gerald Britain. Welcome to my course After in logic with custom functions in Post Rescue Bill, I'm a senior database designer and parasite author. Out of the box, all database systems come packaged with great functionality. However, the business specific items that you need to manage you need to provide custom functions are one piece of that large puzzle. And that is just what this course is about. Some of the major topics that we will cover include Writing Functions, a sequel and P L P G sequel using polymorphism, securing your functions and defending your database and your functions. By the end of this course, you'll know how to create functions to address common business needs and a good set of best practices to follow in your work. Before beginning the course, you should be familiar with querying tables and views in post rescue. You'll also need access to your running coffee of a post best database, or you can follow the set of instructions given in the introductory material. From here on, you should feel comfortable diving into advanced topics with courses on post rescue will built in functions, Advanced data Base programming and performance to me. I hope you'll join me on this journey to learn about writing functions with the capturing logic, with custom functions in post rescue, of course, at plural site.