Course details

MySQL: Triggers & Stored Procedures

MySQL: Triggers & Stored Procedures


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore how triggers can be used to react to specific conditions in your database, and also, how stored procedures can be used to achieve code reuse and code composition of SQL commands.



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