A comprehensive introduction into the use and management of the MySQL client-server relational database management system (RDBMS), covering its installation, configuration, use, SQL dialect, database design, database administration, replication, backup-and-recovery, and optimization. The course focuses on 5.0 features. Both Unix / Linux and Windows configurations are addressed in the course The course has extensive hands-on exercises and attendees receive a personal copy of the MySQL guide by duBois.

• Show how MySQL can be professionally set up and managed
• To explain the release strategy of MySQL
• To present the features of Version 5.0 and later
• To provide experience and best practices for the complete lifecycle of MySQL installations:
  • Installation
  • Account Management
  • Optimisation
  • Data Load
  • Backup, Repair and Recovery
  • Replication
  • MySQL SQL Tuning and tools
  • The Unix / Linux and Windows platforms
  • ODBC with MySQL
    

• SQL or DBA staff needing to come up to speed with MySQL.
• Staff who require specific training to support a MySQL database

• Knowledge of basics of database systems " Some exposure to DBA role

The course provides many examples of the use of database design techniques and reliable methods of working with large amounts of data. Delegates will receive copies of the files used to demonstrate database technology as well as the student guide.

This course is presented together with gbDirect.