Learn MySQL

Learn MySQL, a widely-used relational database management system, with this comprehensive learning path. These MySQL courses are designed for beginners, providing a structured roadmap to master SQL, database design, and administration. Gain real-world experience through hands-on, non-video tutorials and practical exercises in an interactive SQL playground focused on database management and querying.

38 Skills|5 Courses

MySQL for Beginners

DatabaseMySQL

In this course, you will learn what Structured Query Language (SQL) and databases are, the basics of database management, how to set up and configure MySQL, and how to get MySQL client to connect to a MySQL Server.

Completed 0 of 17 Labs

Installation and Basic Configuration of MySQL

Explore MySQL System Tables

Database Management Fundamentals with MySQL

Create Your First MySQL Database

MySQL Table Structure and Data Types

Create a Product Catalog Table

MySQL Basic Data Manipulation

Record Movie Data Challenge

MySQL Data Filtering and Sorting

Book Search Challenge

MySQL Multi-Table Operations

Author Book Information Challenge

MySQL Data Aggregation and Grouping

MySQL Sales Data Analysis Challenge

MySQL User and Privileges Management

MySQL Database Access Challenge

Make Database More Secure

Advanced MySQL Practical Labs

DatabaseMySQL

In this course, master advanced MySQL techniques through hands-on labs covering indexing, stored procedures, triggers, transactions, replication, and more.

Completed 0 of 20 Labs

Keeping Workshop Sign-Ups Consistent

ProjectMySQLDatabase

Keep a working MySQL sign-up desk consistent with relationship rules that preserve existing bookings and allow legitimate requests.

Completed 0 of 2 Labs

Speeding Up Order Queries

ProjectMySQLDatabase

Tune two MySQL order queries with a limited index budget, then keep every order across stable cursor pages with measured diagnostic work.

Completed 0 of 3 Labs

Adding Pickup Options to a Shop

ProjectDatabaseMySQL

Extend a MySQL order schema, backfill approved pickup choices and preserve both old and new checkout contracts.

Completed 0 of 3 Labs