Boolean Education Yan Shiba MySQL Advanced Video Tutorial

Understand triggers

Write the first trigger by hand

Row variable referenced in trigger

Let’s talk about row variables again

Simple programming of triggers

What does for each row do?

Stored procedure concept

Introducing variables and control structures

Parameter passing of stored procedures

Use loop structures in procedures

What are output parameters?

Usage of Case structure

repeat loop structure

Cursor concept

cursor loop

declare processing conditions

Compare the difference between continue and exit

Correct logic for cursor loop reading

MySQL permission check principle

Global authorization and withdrawal

Database and table level authorization and withdrawal

Master-slave replication principle

Master-slave configuration process

Start master-slave