VTC Legacy
Home / Databases

MySQL 5 Administration (Part 1)

by David Swain
171 lessons17 chapters16 hReleased 20124 free
Start the free chapter

This VTC MySQL 5 Administration Part 1 course is the first of a two-part series on the basics of administering a MySQL Server. This is a continuation of the introduction to MySQL 5 we began with the MySQL 5 Development Parts 1 and 2 courses and it assumes that the student has the equivalent knowledge covered in those courses. This first Administration course lays the groundwork for an understanding of basic internal systems of the MySQL server. The focus in Part 1 is to gain familiarity with these systems and various alternatives we have, from the different administrative tools that are available to the different options and sources for MySQL server software and services. While Part 1 has limited hands-on sections, we do offer a lot of detail and a number of exercises on user accounts and security, accessing information about some key internal systems, and some important operations for performing table maintenance. After learning this academic information about the Server, Part 2 will follow this with many practical administrative operations and systems critical to your successful use of the MySQL Server. To begin learning today, simply click on the movie links.

Course content

Introduction4 lessons
The Job of the DBA4 lessons
Architecture12 lessons
MySQL Resource Usage10 lessons
MySQL Server10 lessons
Installing MySQL7 lessons
Configuration and Setup9 lessons
Command Line Clients16 lessons
GUI Clients9 lessons
User Accounts and Security27 lessons
Storage Engines17 lessons
Data Types17 lessons
Indexes8 lessons
Administrative Metadata5 lessons
Table Maintenance13 lessons
Conclusion2 lessons
Credits1 lessons