MySQL Release 5.0+: Stored Routines

Course:  MYSSTOR
Duration:  2 Days
Level:  II
Course Summary

This course is designed to give you hands-on practice working with a MySQL database. Although the focus is to enable students to meet the standards of MySQL 5.0 Certification. The enhancements in versions 5.1, 5.5 and 5.6 will also be discussed and the class will be conducted using a MySQL Version 5.5 database.

« Hide The Details
Topics Covered In This Course

Introduction To Stored Procedures

Stored Procedure Basics

Programming Components

Blocks & Control Flow

SQL In Stored Routines

Error Handling Methods

Program Creation

Managing Transactions

Built-In MySQL Functions

Creating Custom Functions

Creating Database Triggers

Stored Procedures In Applications

Use With PHP/Perl/Python/Java/.NET


Tuning Stored Routines

SQL Tuning

Optimizing Code

Best Practices

Who Should Take This Course

Application Developers, Database Administrators, Support Staff, Management and anyone seeking an OCA or OCP Certification.

Recommended Prerequisites

Participants should be well familiar with IT terminology and computer use. They should also be familiar with relational database concepts.

Training Style

Short lecture sessions (60%) along with hands-on lab sessions (40%).

« Hide The Details
Related Courses
Code Course Title Duration Level
MySQL Release 5.0+ Developer
4 Days
MySQL Release 5.0+ Database Administrator
4 Days
MySQL Release 5.0+: High Availability
3 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]