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

MySQL    |    Intermediate
  • 8 videos | 47m 8s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 15 users Rating 4.4 of 15 users (15)
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

Course MySQL Database Development: Introduction
Rating 4.6 of 109 users Rating 4.6 of 109 users (109)
Course MySQL Database Development: Query & Performance Optimization
Rating 4.6 of 33 users Rating 4.6 of 33 users (33)
Book PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries, Second Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course AWS Cloud Practitioner 2019: AWS Cloud & the Value Proposition
Rating 4.5 of 647 users Rating 4.5 of 647 users (647)
Course CompTIA Security+: Organizational Security Assessment Tools & Mitigation Controls
Rating 4.4 of 108 users Rating 4.4 of 108 users (108)
Course MySQL Database Development: Manipulating Data
Rating 4.4 of 80 users Rating 4.4 of 80 users (80)