DBA 2: Administering MySQL
Database Installation and Maintenance for the Beginning or Intermediate Student
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.
