MySQL Database Development: Stored Routines, Triggers, & the InnoDB memcached Plugin
MySQL 8.0
| Intermediate
- 8 Videos | 47m 8s
- Includes Assessment
- Earns a Badge
Stored programs (procedures) and routines (functions) in MySQL are used to create reusable, executable code. Explore the syntax and use of stored procedures and functions in MySQL
WHAT YOU WILL LEARN
-
create and execute stored programs in MySQLcreate and execute stored routines in MySQLuse the CREATE_TRIGGER and DROP_TRIGGER statements to create a new trigger or delete an existing trigger in MySQLcreate and execute triggers in MySQL
-
use events in MySQL to schedule and run repetitive tasks in your databaserecognize how the InnoDB memcached plugin fits in the overall architecture of MySQL and the function it servesinstall and configure the InnoDB memcached plugin for use in MySQLuse triggers, events, and the InnoDB memcached plugin in MySQL databases
IN THIS COURSE
-
1.Working with Stored Programs7m 55sUP NEXT
-
2.Working with Stored Routines8m 26s
-
3.Creating and Dropping Triggers5m 17s
-
4.Working with Triggers7m 35s
-
5.Working with Events5m 47s
-
6.InnoDB memcached Architecture3m 45s
-
7.Installing the InnoDB memcached Plugin2m 39s
-
8.Exercise: Using the InnoDB memcached Plugin5m 46s
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.