MySQL Stored Procedures Fundamentals: Virtual Classroom Course

Do you want answers for these common questions about MySQL Stored Procedures?

• How do I avoid repetitive and time consuming reissuing of individual SQL statements?
• Where/how do I get help when needed?

Do you want to receive the undivided attention and instruction of a MySQL expert who will share information and techniques on this topic?

Do you want to avoid time and travel hassles by learning in your own setting, rather than going to an actual training site?

Then, the MySQL Stored Procedures Fundamentals Virtual Classroom course is for you!

This synchronous, instructor-led course is designed for MySQL users who would like to understand and use the MySQL Stored Procedures and Stored Functions (also known as Stored Routines). This course provides in-depth information in a “virtual” classroom format that is convenient and affordable.

At the completion of this course, you should be able to:

• Define a stored routine
• Differentiate between stored procedures and stored functions
• Create stored routines
• Execute stored routines
• Examine an existing stored routine
• Delete an existing stored routine
• Explain alterable stored routine characteristics
• Explain non-alterable stored routine characteristics
• Create stored routines with compound statements
• Assign variables in stored routines
• Create flow control statements
• Declare and use handlers
• Use Cursors and understand their limitations
• Find more information about Stored Procedure usage and support