MySQL Release 5.0+: Stored RoutinesCourse: 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. Topics Covered In This Course
Introduction To Stored ProceduresStored Procedure BasicsProgramming ComponentsBlocks & Control FlowSQL In Stored RoutinesError Handling MethodsProgram CreationManaging TransactionsBuilt-In MySQL FunctionsCreating Custom FunctionsCreating Database TriggersStored Procedures In ApplicationsUse With PHP/Perl/Python/Java/.NETSecurityTuning Stored RoutinesSQL TuningOptimizing CodeBest PracticesWho 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%). Related Courses
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] |
|||||||||||||||||||||||||||
Training Courses and On-Line Classes Preferred By IT Pros
Toll Free: 800.631.0410
© Copyright 2010-2015 Verhoef Training – All Rights Reserved.