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 learn how to design, optimize, and administer relational databases using MySQL Workbench.

You’ll be playing the role of a Database Administration Consultant for Maven Consulting, a firm that helps businesses create, maintain, and optimize their databases.

Your job is to work with the owners of various companies to help them manage data in their new and scaling enterprises. You’ll use the skills you learn to complete actual projects that database administration professionals work on every day.

We’ll start by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; including creating and editing schemas and tables, inserting and deleting records, and designing efficient, normalized databases.

From there we’ll work through more advanced DBA concepts using real-world projects and case studies, including stored procedures, triggers and indexes, user permissions, and more.

If you’re looking for a unique and highly engaging way to develop SQL database administration skills, this is the course for you.