Learning Paths

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
  •  (3746)

MySQL Fundamentals

  • by Pinal Dave
  • 2h 38m Duration
  •  (872)

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
  •  (359)

MySQL Workbench Guided Tour

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

MySQL Backup and Recovery Fundamentals

  • by Pinal Dave
  • 1h 15m Duration
  •  (133)

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
  •  (201)

MySQL Query Optimization and Performance Tuning

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

phpMyAdmin Fundamentals

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

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 a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 25 Pluralsight courses and has written over 5000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.

Join our learners and upskill
in leading technologies