Learning Paths

MySQL

8 courses
17 hours
Skill IQ

MySQL is a DBMS, or database management system. It is developed, supported and distributed by Oracle, but since it is open-source it is freely available to anyone under the GPL. MySQL databases are relational, meaning that the data is split up between tables. MySQL is very fast and lightweight so you can run it alongside your other applications on a desktop or laptop. It can also be scaled up to take advantage of all the CPU power and memory available on a dedicated machine. MySQL is constantly being updated and developed to include a wide array of useful and rich functions. This path will guide you through the basics of SQL and introduce MySQL relational databases, and by the end you'll be confident in creating and administering your very own database.

Courses in this path

Beginner

These courses will show you how to install MySQL software and perform basic setup of MySQL DBMS. You will also be introduced to basic queries in SQL/MySQL.

Introduction to SQL

by Jon Flanders
3h 1m
(4048)

MySQL Fundamentals

by Pinal Dave
2h 38m
(931)

Intermediate

This section will take you through more complex queries in MySQL and cover some of your backup/recovery options. You'll finish of with a brief overview of MySQL Workbench installation and navigation.

MySQL Fundamentals Part 2

by Pinal Dave
2h 43m
(371)

MySQL Workbench Guided Tour

by Pinal Dave
1h 52m
(125)

MySQL Backup and Recovery Fundamentals

by Pinal Dave
1h 15m
(139)

Advanced

The advanced courses you see here will solidify your confidence in MySQL database administration by showing you how to optimize performance and queries for your databases.

MySQL Indexing for Performance

by Pinal Dave
1h 39m
(208)

MySQL Query Optimization and Performance Tuning

by Pinal Dave
1h 51m
(165)

phpMyAdmin Fundamentals

by Pinal Dave
1h 40m
(89)

Try for free

Get this learning path plus top-rated picks in tech skills and other popular topics.

Your 10 day free trial includes

Expert-led courses

Keep up with the pace of change with thousands of expert-led, in-depth courses.

For teams

Give up to 10 users access to our full library including this path free for 30 days

What you will learn

Basics of SQL
MySQL server administration
Backup and recovery of MySQL database
InnoDB and MyISAM Storage Engines
Security
Performance monitoring
MySQL Enterprise
MySQL Workbench

Experience

This path targets beginners who may have no programming experience, or some experience with programming outside of databases and SQL.

Learn with the best

Jon Flanders

Although Jon spent the first few years of his professional life as an attorney, he quickly found chasing bits more interesting than chasing ambulances. He first worked at the University of Minnesota, building a financial reporting Web site using ASP and SQL Server, specializing in automatic integration between multiple data stores. Since joining the training industry in 1999, Jon has devoted his time to working on various projects while migrating from the world of ASP and COM to the world of .NE... more

Pinal Dave

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Contact Sales

Learning Paths

MySQL