Contact Sales

USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-208-327-6494
USA - Subscription Renewals: +1-866-830-4410

Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 6919191
Germany: +49 89 420 95 98 95
France: +33 1 70 61 48 95
Sweden: +46 730 207 871
Benelux: +358 50 5710 528
Italy: +39 06-99268193
Israel: +358 50 5710 528
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 6919191

Australia/NZ: +61 2 42314328
Asia Pacific: +81 3 5843 1140

Contact Us Online »

MySQL Advanced Stored Procedures (2 days)

FAQ

Sun Training Classes »

Do want to add to your knowledge of Stored Procedures, Functions and Triggers to improve the quality of your applications?

Do you want to be able to fully utilize the programming capabilities of the MySQL Stored Procedures

Do you want to be able to optimize and debug your Stored Procedures?

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

Who should Attend

Database developers and administrators that desire to improve the quality of their applications by creating complex logic within the database itself using stored procedures

Prerequisites

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

Format

Instructor led, with hands-on lab exercises
Each student will be provided with their own computer

Applies to MySQL Version:

5.0, 5.1

Duration

2 Days.

Upcoming Sessions

MySQL Advanced Stored Procedures
Location	Dates	Price
San Francisco Bay Area	2 - 3 Feb 2009	999 USD	Register	Questions?