Boolean Education Yan Shiba MySQL Advanced Video Tutorial

• Chapter1 mysql advanced tutorial
• 1-1 Understand triggers
• 1-2 Write the first trigger by hand
• 1-3 Row variable referenced in trigger
• 1-4 Let’s talk about row variables again
• 1-5 Simple programming of triggers
• 1-6 What does for each row do?
• 1-7 Stored procedure concept
• 1-8 Introducing variables and control structures
• 1-9 Parameter passing of stored procedures
• 1-10 Use loop structures in procedures
• 1-11 What are output parameters?
• 1-12 Usage of Case structure
• 1-13 repeat loop structure
• 1-14 Cursor concept
• 1-15 cursor loop
• 1-16 declare processing conditions
• 1-17 Compare the difference between continue and exit
• 1-18 Correct logic for cursor loop reading
• 1-19 MySQL permission check principle
• 1-20 Global authorization and withdrawal
• 1-21 Database and table level authorization and withdrawal
• 1-22 Master-slave replication principle
• 1-23 Master-slave configuration process
• 1-24 Start master-slave