__STYLES__
MySQL Specialist
Learning PathMySQL Specialist

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

50 hours
4 courses
2 projects
MySQL
Start learning this path
Overview

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

We'll start by reviewing 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.

From there we'll introduce key database administration topics, 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.

Finally, we'll dive into advanced topics for data analysis and database management with MySQL, including replication & backup, triggers, stored procedures, and more.

This path is designed to help you learn job-ready skills, solve real business problems, and build a project portfolio to showcase your skills to peers and employers.

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
  • Students looking for a hands-on, project-based learning experience

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
Curriculum
Course
MySQL Data AnalysisExplore and analyze relational databases with MySQL, with hands-on assignments and real-world case studies
Guided Project
Restaurant Order AnalysisAnalyze order data to identify the most and least popular menu items and types of cuisine
Course
MySQL Database AdministrationLearn how to build, optimize, and administer relational databases using MySQL and MySQL Workbench
Course
Advanced MySQL for Marketing & Web AnalyticsLearn advanced SQL techniques for marketing analytics, and apply them to real-world cases using a custom-built ecommerce database
Guided Project
Baby Name Trend AnalysisView trends in baby name popularity based on US social security data from 1980-2010
Course
Advanced MySQL Database AdministrationLearn Advanced SQL skills for building, optimizing, and administering relational databases using MySQL Workbench
Instructors
Alice Zhao
Alice ZhaoAlice Zhao is a seasoned data scientist and author of the book, SQL Pocket Guide, 4th Edition (O'Reilly). She has taught numerous courses in Python, SQL, and R as a data science instructor at Maven Analytics and Metis, and as a co-founder of Best Fit Analytics.

John Pauler
John PaulerJohn brings over 15 years 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.
Overview

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

We'll start by reviewing 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.

From there we'll introduce key database administration topics, 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.

Finally, we'll dive into advanced topics for data analysis and database management with MySQL, including replication & backup, triggers, stored procedures, and more.

This path is designed to help you learn job-ready skills, solve real business problems, and build a project portfolio to showcase your skills to peers and employers.

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
  • Students looking for a hands-on, project-based learning experience

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
Instructors
Alice Zhao
Alice ZhaoAlice Zhao is a seasoned data scientist and author of the book, SQL Pocket Guide, 4th Edition (O'Reilly). She has taught numerous courses in Python, SQL, and R as a data science instructor at Maven Analytics and Metis, and as a co-founder of Best Fit Analytics.

John Pauler
John PaulerJohn brings over 15 years 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.
Curriculum
Course
MySQL Data AnalysisExplore and analyze relational databases with MySQL, with hands-on assignments and real-world case studies
Guided Project
Restaurant Order AnalysisAnalyze order data to identify the most and least popular menu items and types of cuisine
Course
MySQL Database AdministrationLearn how to build, optimize, and administer relational databases using MySQL and MySQL Workbench
Course
Advanced MySQL for Marketing & Web AnalyticsLearn advanced SQL techniques for marketing analytics, and apply them to real-world cases using a custom-built ecommerce database
Guided Project
Baby Name Trend AnalysisView trends in baby name popularity based on US social security data from 1980-2010
Course
Advanced MySQL Database AdministrationLearn Advanced SQL skills for building, optimizing, and administering relational databases using MySQL Workbench
Testimonials

Real. Happy. Students.

We've helped thousands of students land dream jobs, launch new careers, and build powerful data skills. Start writing your own success story today!

"Thinking like an analyst" course is a very complete compact course if you have to go through the process of getting to know your customers business till building an insightful dashboard for them. I did a lot of courses the past year but this one is totally different. Key is satisfying your customer by giving them strong insights. I really enjoyed the course and put it on pause many times to check or use it directly in my own ongoing project. I can recommend this course to anybody working as a consultant in the data area.
Marjolein Opsteegh
Marjolein Opsteegh
Marjolein Opsteegh
Maven's Pivot Table & Charts class was a great intro to dashboard design but Advanced Excel Dashboard Design will take your approach to a whole new level. You'll learn the importance of formula-based dashboard design and how to manipulate colors, charts, and KPI metric cards to tell your story. By far one of my favorite Maven classes!
Nate Dunn
Nate Dunn
Thinking like an Analyst course has helped me to clearly understand what it takes to have a successful career in data analytics. I have learnt that my focus should be on the skills I acquire while learning and not the tools. I have also learnt a data analysis workflow for high quality analysis that drives actionable outcomes. I had fun while learning during this course. It is self pacing and elaborate.
Eniola Dada
Eniola Dada
Eniola Dada
For all aspiring or converted analyst out there, stop looking around, this is the way to get the role you are looking for. I am truly impressed with the quality of the information and the completeness of the package Maven Analytics put together. In this well rounded package you have everything you need, from finding your own path, writing or re-writing your resume, marketing on LinkedIn, to building the so needed project portfolio, and even interview skills and approaches.
Radu Tecuceanu
Radu Tecuceanu
Radu Tecuceanu
Love the Maven courses! The instructors always have great slide content to help solidify the concepts and drive home the key aspects. The examples and very relatable making it so much easier to understand how to apply my own projects.
Joseph Collins
Joseph Collins
Joseph Collins
Maven Analytics changed my life, I found a better job position taking the Excel and Power BI paths, nowadays I can apply my skills in my company innovating everyday. Thankful forever.
Rodrigo Chavez
Rodrigo Chavez
Rodrigo Chavez
An excellent course with top-notch data sets to work around with. As usual, Chris Dutton did a fabulous job of covering each element with a simplistic but analytical approach. Although I've been using pivot tables for 5+ years, the new learnings will open a whole array of opportunities for extracting actionable insights. Thank you!
Faizan Qadri
Faizan Qadri
Faizan Qadri
Before deciding to join this learning platform, I struggled to understand and figure out what direction I needed to take for my skill development to be a Data Analyst. This first course helped ease some of my fears and confusion. I am more passionate about my decision to become a data analyst. THANK YOU Chris, John, Aaron, and Enrique , and I look forward to learning more through Maven.
Angie
Angie
Angie
The Maven Analytics Courses are packed full of practical lessons and useful pro tips that can be immediately applied to data in the workplace. One of the best trainings I've ever taken!
Randy McCauley
Randy McCauley
Randy McCauley
Once again Maven blows it out of the water. In this fantastic, well structures course about the way to "Think Like an Analyst". It has so many good points and actions to take when putting together a project. I found it very useful and was able to put it into practice at work straight away. Thank Guys!
Catherine Taylor
Catherine Taylor
Catherine Taylor
Maven really makes it possible to get into data analytics without taking (and paying for) a traditional education program. The courses I took left me with a better understanding and deeper knowledge of what I like most: analyzing data.
Erik van’t Ende
Erik van’t Ende
Erik van’t Ende
The course is fantastic and highly recommended. It gave me the confidence to perform the logical analysis in any given data source and of course build kickass visuals business dashboards for my clients :). Loved the course from the first second to the last.
Tonmoy Hashmi
Tonmoy Hashmi
Tonmoy Hashmi
View all testimonials

Trusted by top companies to upskill their teams

Launch Your Data Career
For IndividualsLaunch Your Data CareerStart learning for free, no credit card required
Request A Free Demo
For TeamsRequest A Free DemoRequest a demo and access a free trial for your team
Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.