Course Objectives

• In this course you will learn how to:
  • Download and install MySQL
  • Configure a MySQL server
  • Successfully log on to any MySQL server
  • Create a MySQL database
  • Load data into, and retrieve data from, MySQL tables
  • Integrate MySQL with Apache log files
  • Work with MySQL system variables
  • Tune the MySQL server to improve performance
  • Secure a MySQL installation against attack or misuse
  • Set up new accounts and remove existing accounts
  • Use the MySQL access control system
  • Make full and incremental backups
  • Repair and optimize tables
  • Schedule table maintenance
  • Perform server log maintenance
  • Use MyISAM and InnoDB storage engines

---

---

© 2007 John Michael Pierobon

Notes