DBA 2: Administering MySQL
Database administrators are responsible for the planning, installation, and maintenance of a database server. Proper administration of MySQL means databases will be fast, secure, and capable of growing with future data needs.
In this course, students will learn how to estimate database capacity needs and install a MySQL server. Students will setup database users, grant permissions, and apply advanced security to database objects. Next, they will learn how to create and maintain database indexes. To ensure proper data security, students learn to create backups and how to restore data. They will also learn how to provide data to external systems using exports, and how to include external data using imports. Finally, students learn how to track database performance, and how to troubleshoot problems.
From beginning to end, participants will learn by doing projects in their own Unix and MySQL environments, and then handing them in for instructor feedback. These projects, as well as the final project - developing a complete database and demonstrating administrative tasks - will add to the student's portfolio and will contribute to certificate completion. Besides a browser and internet connection, all software is provided online by the O'Reilly School of Technology.
Upon completion of the course, students will earn 4 CEUs (Continuing Education Units) and a CEU letter from the University of Illinois Office of Continuing Education. This is the second course of four in the Database Administration Certificate Series.
To see the topics covered in DBA 2: Administering MySQL, please see the Syllabus and Course Details.
Course Syllabus
Earn a Certificate
for Professional Development from the University of Illinois' Office of Continuing Education upon completion of a selected series of courses.
