Expanded Library

PostgreSQL: Advanced Server Programming

by Pinal Dave

PostgreSQL is one of the most advanced and popular open-source databases out there. If you're a database developer looking to expand your skills and understanding of triggers, rules, and procedural language in PostgreSQL, this course is for you.

What you'll learn

PostgreSQL, commonly known as Postgres, is known as the world’s most advanced open-source database. For database developers programming with this server, this course, PostgresQL: Advanced Server Programming, is essential to keeping your knowledge base updated and your programming skills sharp. First, you will learn about different types of triggers and how to use them to validate data integrity and auditing. Next, you'll go over rules and how to implement them, as well as their limitations. You'll also learn about procedural languages--their control structures, loops, and more. By the end of this course, you will have a better understanding of the advanced aspects of server programming with PostgreSQL and how to practically apply your skills.

Table of contents

Course Overview
PostgreSQL: Summary

About the author

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Ready to upskill? Get started