|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-plpgsql-triggers/
课程评论：没有评论
**课程总结：PostgreSQL PL/pgSQL 触发器** 本课程深入探讨了 PostgreSQL 服务器的 PL/pgSQL 过程语言，重点关注触发器。课程将详细解释触发器的概念、用途、类型以及何时使用它们。 通过在真实的 PostgreSQL 服务器和数据库环境中进行实践操作，讲师将展示各种触发器在不同表上的应用，并说明它们如何影响数据变更。课程还将强调在使用触发器时需要注意的关键点，这些细节可能会对数据库查询结果产生重大影响。 此外，课程还将介绍 PL/pgSQL 函数中的一种特殊类型——触发器函数，以及它们与触发器的配合使用。讲师将详细讲解不同类型的触发器函数及其与“语句级触发器”和“行级触发器”的结合方式。 课程中将提供 PostgreSQL 官方手册的参考资料，帮助学员在实际操作中进行验证和深入学习。
This course about Procedural Language of Postgresql servers, in this course we talk about the first type of the PL.PGSQL that is the Triggers in depth...what are the triggers , why we use them, their types and when we use these types.We will explain all this with examples on a real Postgresql server and a database with tables were we all apply all types of triggers on different tables to see how these triggers will effect changes in out tables.Then we will see what are the special points we need pay attention to when using the triggers, such points that can have big impact on the result that our queries we apply on the database.During the course will provide you with sources from the manual of Postgresql to double check about your implementations of the triggers on your Postgresql database tables.In this course we will talk about a special type if PL/PGSQL Functions that is called the Triggers Functions and their use with the Triggers...We also will see the effect of both the Triggers Functions types...and how each type can be joind with each type of the triggers (i.e, the per-statement & per-row triggers).
