Path icon Learning Paths
Skills

MySQL

  • Number of Courses8 courses
  • Duration17 hours
  • Skill IQ available 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 Duration
  •  (4071)

MySQL Fundamentals

  • by Pinal Dave
  • 2h 37m Duration
  •  (934)

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 Duration
  •  (371)

MySQL Workbench Guided Tour

  • by Pinal Dave
  • 1h 52m Duration
  •  (125)

MySQL Backup and Recovery Fundamentals

  • by Pinal Dave
  • 1h 15m Duration
  •  (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 Duration
  •  (210)

MySQL Query Optimization and Performance Tuning

  • by Pinal Dave
  • 1h 51m Duration
  •  (165)

phpMyAdmin Fundamentals

  • by Pinal Dave
  • 1h 40m Duration
  •  (89)

Learn with the best

Jon Flanders
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
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 56 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,700 database tech articles on his blog at https://blog.sqlauthority.com.

Join our learners and upskill
in leading technologies