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.
LabEx is an interactive, hands-on learning platform dedicated to coding and technology. It combines labs, AI assistance, and virtual machines to provide a no-video, practical learning experience.
- A strict “Learn by Doing” approach with exclusive hands-on labs and no videos.
- Interactive online environments within the browser, with automated step-by-step checks.
- A structured content organization with the Skill Tree based learning system.
- A growing learning resource of 30 Skill Trees and over 6,000 Labs.
- The AI learning assistant Labby, built on ChatGPT, providing a conversational learning experience.
Learn more about LabEx VM.
| Index | Name | Difficulty | Practice |
|---|---|---|---|
| 01 | 📖 Installation and Basic Configuration of MySQL | ★☆☆ | Start Lab |
| 02 | 🎯 Explore MySQL System Tables | ★☆☆ | Start Challenge |
| 03 | 📖 Database Management Fundamentals with MySQL | ★☆☆ | Start Lab |
| 04 | 🎯 Create Your First MySQL Database | ★☆☆ | Start Challenge |
| 05 | 📖 MySQL Table Structure and Data Types | ★☆☆ | Start Lab |
| 06 | 🎯 Create a Product Catalog Table | ★☆☆ | Start Challenge |
| 07 | 📖 MySQL Basic Data Manipulation | ★☆☆ | Start Lab |
| 08 | 🎯 Record Movie Data Challenge | ★☆☆ | Start Challenge |
| 09 | 📖 MySQL Data Filtering and Sorting | ★☆☆ | Start Lab |
| 10 | 🎯 Book Search Challenge | ★☆☆ | Start Challenge |
| 11 | 📖 MySQL Multi-Table Operations | ★☆☆ | Start Lab |
| 12 | 🎯 Author Book Information Challenge | ★☆☆ | Start Challenge |
| 13 | 📖 MySQL Data Aggregation and Grouping | ★☆☆ | Start Lab |
| 14 | 🎯 MySQL Sales Data Analysis Challenge | ★☆☆ | Start Challenge |
| 15 | 📖 MySQL User and Privileges Management | ★☆☆ | Start Lab |
| 16 | 🎯 MySQL Database Access Challenge | ★☆☆ | Start Challenge |
| 17 | 🎯 Make Database More Secure | ★☆☆ | Start Challenge |