When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
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.
This Course Includes
pluralsight
5 (13 reviews )
1 hour 54 minutes 
english
Online - Self Paced
core courses
pluralsight
About Capturing Logic with Custom Functions in PostgreSQL
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.
What You Will Learn?
- 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.