• Online, Self-Paced
Course Description

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

Learning Objectives

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

  • 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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.