MySQL Release 5.0+: Stored Routines
Duration: 2 Days
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.
Topics Covered In This Course
Introduction To Stored Procedures
Stored Procedure Basics
Blocks & Control Flow
SQL In Stored Routines
Error Handling Methods
Built-In MySQL Functions
Creating Custom Functions
Creating Database Triggers
Stored Procedures In Applications
Use With PHP/Perl/Python/Java/.NET
Tuning Stored Routines
Who Should Take This Course
Application Developers, Database Administrators, Support Staff, Management and anyone seeking an OCA or OCP Certification.
Participants should be well familiar with IT terminology and computer use. They should also be familiar with relational database concepts.
Short lecture sessions (60%) along with hands-on lab sessions (40%).
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.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]