MySQL Advanced Stored Procedures

Training

	MySQL trainings
MySQL Advanced Stored Procedures

Training goals

Through a hands-on approach, this instructor-led course with focus on labs is designed to teach you how to maximize the use of stored procedures along with the knowledge to discern when an application should contain stored procedures and when they should not.

Training days

2 days

Conspect

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

Improve upon the design and structure of your compound stored procedure statements.
Improve upon your applications by utilizing the various data items allowed in MySQL stored procedures.
Improve upon cursor creation for processing individual rows of data by learning the best practices associated with them.
Improve upon the integration of SQL statements in MySQL stored procedures by taking advantage of the continuity built-in to the two entities.
Utilize the best feature of dynamic SQL to include the prevention of code injection.
Improve your application by effectively utilizing the exceptions and errors capabilities of MySQL stored procedures.
Improve upon the management of MySQL stored procedures by utilizing best practices in their creation, modification and deletion.
Improve your application by integrating the features of database triggers that can improve data integrity and automate database processes.
Utilize best practices to ensure data security with stored procedures.
Develop personal best practices in relation to the creation and maintenance of stored procedures.
Circumvent MySQL stored procedure limitations.
Improve the performance of your applications by optimizing stored procedures.

Requirements

Having attended the MySQL for Developers course or similar knowledge:

Be able to create user defined variables, prepared statements and stored procedures.
Have experience with simple SQL queries.
Have experience with complex queries like joins and subqueries.
Be able to debug MySQL applications.
Have experience with INFORMATION_SCHEMA.

Recommended trainings