MySQL Database Administration: Beginner SQL Database Design

Learn SQL for data analysis, relational database management & administration w/ MySQL Workbench (SQL DBA for beginners!)

Created by: Maven Analytics • 1,500,000 Learners
Empowering everyday people with life-changing data skills

Created by: John Pauler
Analytics Expert

What Will I Learn?

• Write SQL queries and use the MySQL Workbench UI to create databases and tables
• Learn how to alter tables by adding and removing columns
• Connect data between tables by creating primary and foreign key relationships
• Assign user roles and permissions to database users, just like a real DBA
• Solve practical hands-on assignments and real-world business use cases
• Master unique tips, tools and case studies that you won't find anywhere else
• Understand common Relational Database Management Systems (RDBMS)
• 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 you through the free install process)
• Basic understanding of database fundamentals encouraged, but not required

Target audience

• Analysts or BI professionals looking to improve their understanding of relational database systems
• Excel users looking to shift into a broader business intelligence or database-focused role
• Anyone seeking to learn one of the world’s most popular and powerful database programming languages (SQL)
• Students looking for a hands-on and highly engaging introduction to MySQL for database administration
• Anyone looking to pursue a career as a database administrator
• NOTE: This course does NOT database analysis (we cover data analysis in a separate course)