MySQL: Triggers & Stored Procedures

MySQL 8:0    |    Intermediate
  • 12 Videos | 1h 28m 36s
  • Includes Assessment
  • Earns a Badge
Likes 15 Likes 15
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 109 Likes 109  
COURSE SQL Developer
Likes 152 Likes 152  
Likes 27 Likes 27