MySQL Database Development: Stored Routines, Triggers, & the InnoDB memcached Plugin

MySQL 8.0    |    Intermediate
  • 8 videos | 47m 8s
  • Includes Assessment
  • Earns a Badge
Likes 18 Likes 18
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

  • 7m 55s
    In this video, you will learn how to create and execute stored programs in MySQL. FREE ACCESS
  • 8m 26s
    Find out how to create and execute stored routines in MySQL. FREE ACCESS
  • Locked
    3.  Creating and Dropping Triggers
    5m 17s
    In this video, you will use the CREATE_TRIGGER and DROP_TRIGGER statements to create a new trigger or delete an existing trigger in MySQL. FREE ACCESS
  • Locked
    4.  Working with Triggers
    7m 35s
    In this video, you will create and execute triggers in MySQL. FREE ACCESS
  • Locked
    5.  Working with Events
    5m 47s
    Find out how to use events in MySQL to schedule and run repetitive tasks in your database. FREE ACCESS
  • Locked
    6.  InnoDB memcached Architecture
    3m 45s
    Upon completion of this video, you will be able to recognize how the InnoDB memcached plugin fits in the overall architecture of MySQL and what function it serves. FREE ACCESS
  • Locked
    7.  Installing the InnoDB memcached Plugin
    2m 39s
    In this video, you will learn how to install and configure the InnoDB memcached plugin for MySQL. FREE ACCESS
  • Locked
    8.  Exercise: Using the InnoDB memcached Plugin
    5m 46s
    In this video, you will learn how to use triggers, events, and the InnoDB memcached plugin in MySQL databases. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries
Course MySQL: Triggers & Stored Procedures
Likes 50 Likes 50  
Course MySQL Database Development: Introduction
Likes 109 Likes 109  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course MySQL Database Development: Working with Functions
Likes 32 Likes 32  
Course MySQL Database Development: GIS, Cloud, & Connectors
Likes 26 Likes 26  
Course MySQL Database Development: Introduction
Likes 109 Likes 109