Learning Path

MySQL Specialist

This path is for database administrators or data analysts looking to build expert-level MySQL skills, and practice applying them to real-world projects and case studies

Courses3
Hours20.5 hours
Tools

Not Sure Which COURSE or PATH is right for you?

Take our customized survey to find the perfect courses & paths for your skill level and goals!

About This Path

This path is for database administrators or data analysts looking to build expert-level MySQL skills, and practice applying them to real-world projects and case studies.

We'll start with an introduction to database administration, where you'll learn how to design, optimize and manage relational databases with MySQL Workbench. You'll learn how to create and edit tables and schemas, insert and delete records, manage users and permissions, and apply advanced tools like triggers and stored procedures.

From there we'll review core techniques for single and multi-table analysis, including SELECT and CASE statements, table unions and joins, and database normalization best practices. You'll apply your skills to a number of advanced case studies, including website traffic analysis, measurement and testing, channel mix, product performance, user analysis, and more.

Included Courses

WHO SHOULD TAKE THIS PATH?

  • Analysts and BI professionals looking to build expert-level MySQL skills
  • Data professionals who work with large, relational databases
  • Anyone who wants to learn how to build, manage or analyze databases

WHAT ARE THE PATH REQUIREMENTS?

  • MySQL Workbench & Community Server (we'll walk you through the install process)
  • Experience with database fundamentals encouraged, but not required

Meet Your Instructors

John Pauler

John brings over a decade of business intelligence experience to the Maven team, having worked with companies ranging from Fortune 500 to early stage startups. As a MySQL expert, he has played leadership roles across analytics, marketing, SaaS and product teams.

Testimonials