Practice MySQL Programming Projects

Languages

🇨🇳 简体中文 🇯🇵 日本語 🇪🇸 Español 🇫🇷 Français 🇩🇪 Deutsch 🇷🇺 Русский 🇰🇷 한국어 🇧🇷 Português 🇺🇸 English

MySQL is a widely - used relational database management system. This Skill Tree offers a comprehensive learning path for mastering MySQL. It's perfect for database beginners, presenting a structured roadmap to understand SQL, database design, and administration. Through hands - on, non - video courses and practical exercises in an interactive SQL playground, you'll gain real - world experience in database management and querying.

Exercises

Index	Name	Difficulty	Practice
01	Manage MySQL User Permissions	Beginner	🚀 Start Lab
02	A Simple Course Database	Beginner	🚀 Start Lab
03	Managing Database Indexes in MySQL	Beginner	🚀 Start Lab
04	Add Student Information to Table	Beginner	🚀 Start Lab
05	Add Student Personal Information	Beginner	🚀 Start Lab
06	Adding Constraints to the Course Schedule	Beginner	🚀 Start Lab
07	Adding Unique Constraint to City Names	Beginner	🚀 Start Lab
08	Average Salaries Per Department	Beginner	🚀 Start Lab
09	Backup MySQL Database with Mysqldump	Beginner	🚀 Start Lab
10	Biology Course Alumni Search	Beginner	🚀 Start Lab
11	Calculate User's Encrypted Password	Beginner	🚀 Start Lab
12	Change Default Value for Countrylanguage Table	Beginner	🚀 Start Lab
13	Changing the Error Log Location	Beginner	🚀 Start Lab
14	Cities With Over One Million Population	Beginner	🚀 Start Lab
15	City Names and Respective Countries	Beginner	🚀 Start Lab
16	Database Management and SQL Self-Join	Beginner	🚀 Start Lab
17	Columbus Discovery of the New World	Beginner	🚀 Start Lab
18	Comprehensive Operation of Basic Functions	Beginner	🚀 Start Lab
19	Comprehensive Challenge of This Section	Beginner	🚀 Start Lab
20	Comprehensive Operation of Conversion Functions	Beginner	🚀 Start Lab
21	Database Constraint Design and Implementation	Beginner	🚀 Start Lab
22	Countries and Codes in Region	Beginner	🚀 Start Lab
23	Countries With 1 Billion+ Population	Beginner	🚀 Start Lab
24	Accessing MySQL Database and Querying GNP	Beginner	🚀 Start Lab
25	Country GNP and Population Query	Beginner	🚀 Start Lab
26	Creating Stored Procedures for Course Data Retrieval	Beginner	🚀 Start Lab
27	Creating Secure MySQL User Accounts	Beginner	🚀 Start Lab
28	Creating Product Information Table	Beginner	🚀 Start Lab
29	SQL Queries for Student Course Analysis	Beginner	🚀 Start Lab
30	MySQL Database Management Fundamentals	Beginner	🚀 Start Lab
31	Mastering Database Management with SQL	Beginner	🚀 Start Lab
32	Delete Course Schedule View Data	Beginner	🚀 Start Lab
33	Delete Expired Course Information	Beginner	🚀 Start Lab
34	Comprehensive MySQL Data Manipulation	Beginner	🚀 Start Lab
35	SQL Querying for Employee Data	Beginner	🚀 Start Lab
36	Mastering MySQL Database Management	Beginner	🚀 Start Lab
37	Format Query for Teacher Salary	Beginner	🚀 Start Lab
38	General Function Comprehensive Challenge	Beginner	🚀 Start Lab
39	Accessing MySQL Database and SQL Querying	Beginner	🚀 Start Lab
40	Identify MVP Recipient in Game	Beginner	🚀 Start Lab
41	Mastering Database Joins for Personnel Data	Beginner	🚀 Start Lab
42	Largest Population by Country	Beginner	🚀 Start Lab
43	Largest Population in Five Countries	Beginner	🚀 Start Lab
44	Create MySQL Maximum Value Function	Beginner	🚀 Start Lab
45	Modifying MySQL Database Table Constraints	Beginner	🚀 Start Lab
46	Modify Primary Key of Countrylanguage Table	Beginner	🚀 Start Lab
47	Modify Student Table Attributes	Beginner	🚀 Start Lab
48	Mastering MySQL Data Analysis	Beginner	🚀 Start Lab
49	Number of Users With Modify Permissions	Beginner	🚀 Start Lab
50	Obtain Pi With Two Decimals	Beginner	🚀 Start Lab
51	Official Languages in Various Countries	Beginner	🚀 Start Lab
52	Personnel Management System Database Setup	Beginner	🚀 Start Lab
53	Print Current Login User Information	Beginner	🚀 Start Lab
54	Printing Current Time with MySQL	Beginner	🚀 Start Lab
55	Print Standard Body Temperature in Fahrenheit	Beginner	🚀 Start Lab
56	Query City Information for Specified IDs	Beginner	🚀 Start Lab
57	Query City Names With Country	Beginner	🚀 Start Lab
58	Query GDP for All Countries	Beginner	🚀 Start Lab
59	Query Is So Slow	Beginner	🚀 Start Lab
60	Query Population of All Countries	Beginner	🚀 Start Lab
61	SQL Database Creation and Non-Equijoin Query	Beginner	🚀 Start Lab
62	Query User Levels With Left Join	Beginner	🚀 Start Lab
63	Querying Country Codes Range	Beginner	🚀 Start Lab
64	Querying Official Languages and Sorting	Beginner	🚀 Start Lab
65	Querying Official Languages of Each Country	Beginner	🚀 Start Lab
66	Reverse Print File Content Command	Beginner	🚀 Start Lab
67	Right Outer Join Query User Level	Beginner	🚀 Start Lab
68	Salary Range for Teachers by Department.	Beginner	🚀 Start Lab
69	Search for Favorite Courses	Beginner	🚀 Start Lab
70	Stored Procedure Cursor Database Retrieval	Beginner	🚀 Start Lab
71	Student Grade Management System	Beginner	🚀 Start Lab
72	Creating Database Views in MySQL	Beginner	🚀 Start Lab
73	Mastering SQL Subqueries for Data Analysis	Beginner	🚀 Start Lab
74	Top 5 Countries by Land Area	Beginner	🚀 Start Lab
75	Updating Student GPA in MySQL Database	Beginner	🚀 Start Lab
76	Creating and Updating Database Views	Beginner	🚀 Start Lab
77	MySQL Database Administration Essentials	Beginner	🚀 Start Lab
78	View for Course Information	Beginner	🚀 Start Lab
79	Exploring MySQL User Permissions	Beginner	🚀 Start Lab
80	Wuxu Reform Duration Calculation	Beginner	🚀 Start Lab
81	Extending Entity with Custom Properties	Beginner	🚀 Start Lab
82	Operate the Course Table	Beginner	🚀 Start Lab
83	Practical Use of resultMap	Beginner	🚀 Start Lab
84	Course Schedule CRUD With MyBatis	Beginner	🚀 Start Lab
85	Build a Simple URL Shortener With Flask and MySQL	Advanced	🚀 Start Lab

More

• 🔗 MySQL Learn more about
• 🔗 Awesome Programming Projects
• 🔗 Awesome Programming Courses