Capturing Logic with Custom Functions in PostgreSQL

Course Overview

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.
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 skills and knowledge will you acquire during this course?
This course will provide learners with the skills and knowledge to write custom functions in PostgreSQL. Learners will gain an understanding of how to move from a basic query to a fully-parameterized function, and how to write functions using PL/pgSQL. Additionally, learners will explore important matters relating to polymorphism, security, defensive programming and error handling. By the end of the course, learners will be able to solve real-world problems using PostgreSQL functions.

How does this course contribute to professional growth?
This course provides learners with the foundational knowledge and skills needed to write custom functions in PostgreSQL, enabling them to solve real-world problems. This contributes to professional growth by providing learners with the ability to develop their PostgreSQL skills and explore more advanced topics such as database optimization, data modeling, and database administration. Additionally, learners can explore related topics such as SQL, database design, and database security, which can further contribute to their professional growth.

Is this course suitable for preparing further education?
This course is suitable for preparing further education in PostgreSQL. It provides learners with foundational knowledge and skills needed to write custom functions in PostgreSQL, enabling them to solve real-world problems. Additionally, learners can continue to develop their PostgreSQL skills by exploring more advanced topics such as database optimization, data modeling, and database administration. Learners can also explore related courses such as Introduction to PostgreSQL, Advanced PostgreSQL, and PostgreSQL Performance Tuning, as well as courses related to other database systems such as MySQL, Oracle, and Microsoft SQL Server.