Advanced MySQL

Course Description:

This course teaches participants to install, configure, and optimize MySQL DBMS, including how to use triggers and stored procedures, data backup/restore, database replication, storage clustering.

Learning Objectives:

After completing this course, students will be able to:

• Install MySQL server
• Config MySQL server in multi-user environment
• Use transactions and locking
• Use corsors and indexex
• Use triggers and stored procedures
• Backup/Restore database
• Config MySQL replication environment
• Use storage clustering

Prerequisites:

• LAMPTECH's Database Design - Data Modeling/Analysis and Introduce to MySQL

Required Software:

• MySQL 5.0 or later

Platform Support:

You can take this course on computers running Windows, Macintosh, or UNIX.