MySQL: Advanced Routines, Optimization, and DCL

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
Writing advanced routines can be a big part of being a database developer as well as optimizing the database to ensure queries are running efficiently for end users. In this course, you'll learn how to create and use advanced procedures, functions, and triggers and how to optimize queries and performance of a MySQL database. This course also covers how to grant, revoke, and deny user permissions for the underlying database objects.

Target Audience
Personnel at all levels of an enterprise seeking to attain competency in MySQL

Prerequisites
None

Expected Duration (hours)
2.4

Lesson Objectives

MySQL: Advanced Routines, Optimization, and DCL

start the course

recognize the difference between stored procedures and stored functions

create and use stored functions

recognize the functionality provided by input and output parameters in stored procedures

create stored procedures with input and output parameters

recognize the stored procedure recursion feature

identify when to use before and after triggers

use triggers to automatically respond to data modifications

write basic applications for use with MySQL

identify MySQL queries that require optimization

identify the index types in MySQL and understand their use

identify if an index is useful for improving query performance

use EXPLAIN to analyze query execution

use explicit statements to direct MySQL to use specific join types or indexes

examine various tools used to optimize query execution

describe the DCL statements used to assign user permissions to database objects

grant user access to any database, at any level

remove previously assigned permissions

optimize queries and the database and use DCL statements to administer permissions

Course Number:
df_mysq_a05_it_enus

Expertise Level
Beginner