MySQL: Triggers & Stored Procedures

placeholder

Learners can explore how triggers can be used to react to specific conditions in your database and how stored procedures can be used to achieve code reuse and code composition of SQL commands in this 12-video course. You will examine how triggers which are described as actions or groups of logic and special stored procedures that are executed by the MySQL database when certAIn specific events occur. This course demonstrates how to use several types of triggers and the use of foreign keys. You will learn how to use the ON DELETE and ON UPDATE cascade functionality. Then learn how to create stored procedures which are bits of SQL code queries or other operations which can be saved given a name and then invoked at will. Observe how to invoke stored procedures to redefine stored procedures and then examine advance and intricate stored procedures. Finally this course demonstrates how to construct an elaborate stored procedure.