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 a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 25 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.

Ready to upskill? Get started