MySQL Stored Procedure Techniques

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

• Do you want to end repetitive and time consuming reissuing of individual SQL statements?
• Do you need an advanced level of implementation of stored procedures that matches the advanced level of SQL code being used?
• Do you want to ensure fast, reliable and efficient performance, while handling errors, exceptions and security?
• 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 Procedure Techniques online course is for you!

This synchronous, instructor-led course is designed for MySQL users who would like to deepen their knowledge and use of 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:

• Use error handling capabilities
• Explain error handling limitations
• Implement error handlers
• Set security permissions
• Explain Invokers and Definers rights
• Prevent code injection
• Implement fundamental programming best practices
• Explain caveats of variable usage and best practices
• Describe flow control best practices
• Describe SQL best practices