Advanced MySQL DBA

This badge is earned by successfully completing the Advanced MySQL Database Administration course at Maven Analytics. COURSE HOURS: 13.0 COURSE DESCRIPTION: MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal. In this course, you'll take your database DBA skills to the next level, expanding into advanced concepts like replication, backup, recovery, and security, along with automation tools like stored procedures, triggers, and scheduled events. We'll start by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; creating and editing schemas & tables, inserting and deleting records, and reviewing the key principles of normalized databases. From there we'll work through more advanced DBA concepts like replication, backup and recovery, and learn how to leverage automation via stored procedures, triggers, and scheduled events. Throughout the course, you'll be playing the role of Lead DBA for a new firm, building out an entire database and populating tables from the ground up, just like you would in the real world. If you're looking for a unique and highly engaging way to develop advanced SQL database administration skills, this is the course for you.