MySQL Advanced Stored Procedures

Sun Microsystems K.K.
Tokyo, Japan

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' Then Advanced Stored Procedures in MySQL is the class for you! An Authorized MySQL instructor will teach you how to improve the quality of Stored Procedures, Function and Triggers in your applications as well as how to debug and optimize them!

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.

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 ...''

Elements of this syllabus are subject to change.

Phone:81-3-5843-1140

School Address/Venue(s):

4-11, Jingumae 2-chom, Shibuya-ku,
Tokyo 150-0001, Japan

Jobs & Resumes: Tokyo
Houses & Roommates: Tokyo
Travel Agencies: Tokyo

Search other schools for MySQL Advanced Stored Procedures training resources.

Managing MySQL
MySQL for Beginners
MySQL for DBAs
MySQL Performance Tuning
MySQL High Availability
MySQL Cluster
MySQL Bootcamp
MySQL Developer Techniques
MySQL 5.0
MySQL for Developers
MySQL and PHP
Using MySQL
MySQL 5.0 In Depth
Advanced MySQL Cluster
NDB API
MySQL Stored Procedures Fundamentals
MySQL Proxy

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.