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

Book Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON
Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Course MySQL Database Development: Query & Performance Optimization
Rating 4.6 of 33 users Rating 4.6 of 33 users (33)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course MySQL: Grouping & Aggregation Operations
Rating 4.8 of 80 users Rating 4.8 of 80 users (80)
Course MySQL Database Development: SELECT Statement & Operators
Rating 4.8 of 43 users Rating 4.8 of 43 users (43)
Course MySQL Database Development: Database Design Fundamentals
Rating 4.6 of 122 users Rating 4.6 of 122 users (122)