MySQL is the open source community's most popular Relational Database Management System (RDBMS) offering, and is a key part of LAMP – Linux, Apache, MySQL, PHP/Perl/Python. Many Fortune 500 companies adopt MySQL to reap the benefits of an open source, platform-independent RDMS, such as simplifying conversion from other platforms and lowering database Total Cost of Ownership by 90%. This class walks the admin through the basics of MySQL administration. Included are an introduction to the available MySQL client software and its use in performing administrative functions, optimization tasks, and general performance tuning. This course covers MySQL 5.5.
Before taking this course, prior experience installing software and programming in any language, such as HTML, is recommended but not required.
2 Days/Lecture & Lab
This course is designed for system administrators.
- Course Introduction
- Introduction to Database Concepts and MySQL
- Installation, Configuration, and Upgrading
- MySQL Client Software and the mysql Command-Line Tool
- MySQL Storage Engines
- Administering a Database and Users
- Optimization and Performance Tuning