MySQL: Triggers & Stored Procedures

Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description

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.

Expected Duration (hours)
1.4

Lesson Objectives

MySQL: Triggers & Stored Procedures

discover the key concepts covered in this course

define a trigger and enumerate use cases of triggers in a database system

create a row-level trigger executed after inserts into a MySQL table

create a row-level trigger executed before inserts into a MySQL table

use triggers to performing cascading inserts and satisfy foreign key constraints

override default ON DELETE and ON UPDATE behavior in MySQL tables

enumerate applications of stored procedures

create a simple stored procedure correctly specifying choice of delimiter

invoke a stored procedure and pass in required arguments

check if a stored procedure already exists and drop it before re-defining it

combine complex declarative and imperative operations in a stored procedure

Course Summary

Course Number:
it_aplumgdj_07_enus

Expertise Level
Intermediate