Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
 
 
mysql certified training   this course works with savings passes
 
code. MYSQL-ADV-STG   length. 2 days
type. Instructor-Led   partner. MySQL
price.
$999  
 

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.
 
course schedule  
 
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.
   
Request course date Request on site training
 
who can benefit
 
 
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


 
skills gained
 
 
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


 
format
 
 
Instructor led, with hands-on lab exercises
Each student will be provided with their own computer
 
related courses, exams and materials
 
 


  before related training and products


 
course content details  
 



 
Free PSP - FREE GPS

MySQL Training Education Savings



find a course
 
phone us
 
view course schedule





Free $100 Best Buy Gift Certificate

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware