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
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 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.
Testimonials
Check Out These Other Learning Paths
Excel Specialist
This path is for Excel users looking to ace the Microsoft MO-201 Exam and build a deep, expert-level skill set, including formulas, charts, PivotTables, Power Query and more
Data Visualization Expert
This path is about bringing your data to LIFE, with project-based courses featuring some of the most popular data visualization platforms, including Excel, Power BI and Tableau
Business Intelligence Analyst
This path is for aspiring analysts and BI professionals looking to master a powerful stack of self-service business intelligence tools, including Excel, Power BI, MySQL and Tableau
Power BI Specialist
This path is for users looking to master self-service business intelligence with Power BI Desktop & Service, build Advanced DAX skills, and ace the Microsoft PL-300 exam
Tableau Specialist
This path will help you build expert-level Business Intelligence skills with Tableau Desktop, Prep & Server, and ace the Tableau Desktop Specialist & Certified Data Analyst exams
Python Specialist
This path is for BI Analysts or Data Scientists looking to master Python's most powerful tools for data analysis and visualization, including Pandas, Matplotlib, Seaborn, Plotly and Dash.
Machine Learning Foundations
This path is for analysts looking to build a fundamental understanding of machine learning techniques, including profiling, classification, regression & unsupervised learning