Created by useiconic.comfrom the Noun Project

MySQL Administration

MySQL is an OS relational database management system (RDBMS), and the most popular among the other SQL database projects for servers. This course aims at providing the trainees with the proper knowledge on how to exploit and administer a MySQL database.

Syllabus

  • Introduction
  • Basics
  • Data types
  • Table types
  • Create a database
  • Configuration
  • Privilege system and security
  • User management
  • Backup and restoration
  • MySQL tools
  • Log files
  • Optimization
  • Replication
  • Presentation of MySQL 5

Audience

This course is for anyone who has to administer a MySQL database.

Prerequisites

Having knowledge of Linux System Administration, SFL201, is recommended.