SQL Database Administration: Advanced MySQL Workbench

Learn advanced SQL for database administration (DBA) & analytics, and practice building SQL databases w/ real projects!

Created by: Maven Analytics
Empowering everyday people with life-changing data skills

Created by: John Pauler
Analytics Expert

What Will I Learn?

• Write SQL queries and use MySQL Workbench to create new databases from scratch
• Explore database security threats and practice techniques like replication, backup and recovery
• Leverage advanced automation tools like triggers, stored procedures, and scheduled events
• Create and modify EER diagrams to understand table structures and relationships
• Work through practical, real-world assignments and projects you won't find anywhere else
• Get LIFETIME access to resource files, quizzes, assignments, and expert support

Requirements

• MySQL Workbench and Community Server for Mac or Windows/PC (we’ll walk through the free install)
• If you are new to MySQL or database administration, we recommend taking our "SQL Database for Beginners" course first

Target audience

• Analysts or BI professionals looking to gain a deeper understanding of database management
• DBAs who want to learn advanced database management & automation tools
• Anyone seeking to master one of the world's most popular database programming languages
• Students looking for a hands-on and project-based deep dive into database administration with MySQL
• NOTE: This course does NOT cover database analysis (we cover data analysis in a separate course)