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

MySQL 8.0    |    Intermediate
  • 8 Videos | 47m 8s
  • 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
    FREE ACCESS
  • Locked
    4. 
    Working with Triggers
    7m 35s
    FREE ACCESS
  • Locked
    5. 
    Working with Events
    5m 47s
    FREE ACCESS
  • Locked
    6. 
    InnoDB memcached Architecture
    3m 45s
    FREE ACCESS
  • Locked
    7. 
    Installing the InnoDB memcached Plugin
    2m 39s
    FREE ACCESS
  • Locked
    8. 
    Exercise: Using the InnoDB memcached Plugin
    5m 46s
    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 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

BOOK Learn SQL with MySQL: Retrieve and Manipulate Data Using SQL Commands with Ease
COURSE MySQL: Views, Indices, & Normal Forms
Likes 7 Likes 7  
COURSE Database Fundamentals: Working with SQL Commands

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Agile Principles and Methodologies
Likes 2971 Likes 2971  
COURSE MySQL Database Development: Query & Performance Optimization
Likes 16 Likes 16  
COURSE JIRA Administration: Platform Fundamentals
Likes 269 Likes 269