Stored Routines, Triggers, & the InnoDB memcached Plugin

MySQL 8.0
  • 8 Videos | 50m 38s
  • Includes Assessment
  • Earns a Badge
Likes 11 Likes 11
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 MySQL
    create and execute stored routines in MySQL
    use the CREATE_TRIGGER and DROP_TRIGGER statements to create a new trigger or delete an existing trigger in MySQL
    create and execute triggers in MySQL
  • use events in MySQL to schedule and run repetitive tasks in your database
    recognize how the InnoDB memcached plugin fits in the overall architecture of MySQL and the function it serves
    install and configure the InnoDB memcached plugin for use in MySQL
    use triggers, events, and the InnoDB memcached plugin in MySQL databases

IN THIS COURSE

  • Playable
    1. 
    Working with Stored Programs
    7m 55s
    UP NEXT
  • Playable
    2. 
    Working with Stored Routines
    8m 26s
  • Locked
    3. 
    Creating and Dropping Triggers
    5m 17s
  • Locked
    4. 
    Working with Triggers
    7m 35s
  • Locked
    5. 
    Working with Events
    5m 47s
  • Locked
    6. 
    InnoDB memcached Architecture
    3m 45s
  • Locked
    7. 
    Installing the InnoDB memcached Plugin
    2m 39s
  • Locked
    8. 
    Exercise: Using the InnoDB memcached Plugin
    5m 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.

YOU MIGHT ALSO LIKE

Likes 25 Likes 25  
Likes 24 Likes 24  
Likes 61 Likes 61  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 179 Likes 179  
Likes 9 Likes 9  
Likes 188 Likes 188