PostgreSQL: Advanced Server Programming
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
- Introduction 1m
- What Is Trigger? 1m
- Types of Trigger 3m
- Types of Trigger - Table 1m
- Notes on Trigger 2m
- Real World Scenario Setup 1m
- Data Integrity with Triggers 2m
- Demo: Data Integrity with Triggers 6m
- Demo: Validating Data Integrity with Triggers 4m
- Data Auditing with Triggers 2m
- Demo: Data Auditing with Triggers 6m
- Demo: Validating Data Auditing with Triggers 4m
- Summary 2m
- Introduction 1m
- What Is Rule? 1m
- Types of Rule 2m
- Notes on Rule 1m
- Real World Scenario 2m
- Rules and Views for SELECT 2m
- Demo: Rule for SELECT Setup 4m
- Demo: Rule for SELECT 8m
- Demo: View for SELECT 3m
- Rules and Views for Table Modification 2m
- Demo: Rule for Table Modification Setup 2m
- Demo: Rule for Table Modification 6m
- Demo: Trigger for Table Modification 6m
- Real World Scenario Conclusion 2m
- Summary 2m
- Introduction 2m
- What Are Procedural Languages? 1m
- Types of PLs 3m
- PL/pgSQL Design Goals 2m
- PL/pgSQL Advantages 3m
- Structure of PL/pgSQL 2m
- Real World Scenario 1m
- Basics of Procedural Languages 1m
- Demo: Basics of Procedural Languages - Task 1 6m
- Demo: Basics of Procedural Languages - Task 2 5m
- Demo: Basics of Procedural Languages - Task 3 2m
- Procedure and Error 2m
- Demo: Procedure and Error 6m
- Procedure and Control Structure 1m
- Demo: Procedure and Control Structure 4m
- Summary 2m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 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 81 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.