Practice MySQL Programming Projects

September 26, 2025 ยท View on GitHub

Languages

๐Ÿ‡จ๐Ÿ‡ณ ็ฎ€ไฝ“ไธญๆ–‡ ๐Ÿ‡ฏ๐Ÿ‡ต ๆ—ฅๆœฌ่ชž ๐Ÿ‡ช๐Ÿ‡ธ Espaรฑol ๐Ÿ‡ซ๐Ÿ‡ท Franรงais ๐Ÿ‡ฉ๐Ÿ‡ช Deutsch ๐Ÿ‡ท๐Ÿ‡บ ะ ัƒััะบะธะน ๐Ÿ‡ฐ๐Ÿ‡ท ํ•œ๊ตญ์–ด ๐Ÿ‡ง๐Ÿ‡ท Portuguรชs ๐Ÿ‡บ๐Ÿ‡ธ English

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.

Exercises

IndexNameDifficultyPractice
01Manage MySQL User PermissionsBeginner๐Ÿš€ Start Lab
02A Simple Course DatabaseBeginner๐Ÿš€ Start Lab
03Managing Database Indexes in MySQLBeginner๐Ÿš€ Start Lab
04Add Student Information to TableBeginner๐Ÿš€ Start Lab
05Add Student Personal InformationBeginner๐Ÿš€ Start Lab
06Adding Constraints to the Course ScheduleBeginner๐Ÿš€ Start Lab
07Adding Unique Constraint to City NamesBeginner๐Ÿš€ Start Lab
08Average Salaries Per Department Beginner๐Ÿš€ Start Lab
09Backup MySQL Database with MysqldumpBeginner๐Ÿš€ Start Lab
10Biology Course Alumni SearchBeginner๐Ÿš€ Start Lab
11Calculate User's Encrypted PasswordBeginner๐Ÿš€ Start Lab
12Change Default Value for Countrylanguage TableBeginner๐Ÿš€ Start Lab
13Changing the Error Log LocationBeginner๐Ÿš€ Start Lab
14Cities With Over One Million PopulationBeginner๐Ÿš€ Start Lab
15City Names and Respective CountriesBeginner๐Ÿš€ Start Lab
16Database Management and SQL Self-JoinBeginner๐Ÿš€ Start Lab
17Columbus Discovery of the New WorldBeginner๐Ÿš€ Start Lab
18Comprehensive Operation of Basic FunctionsBeginner๐Ÿš€ Start Lab
19Comprehensive Challenge of This SectionBeginner๐Ÿš€ Start Lab
20Comprehensive Operation of Conversion FunctionsBeginner๐Ÿš€ Start Lab
21Database Constraint Design and ImplementationBeginner๐Ÿš€ Start Lab
22Countries and Codes in RegionBeginner๐Ÿš€ Start Lab
23Countries With 1 Billion+ PopulationBeginner๐Ÿš€ Start Lab
24Accessing MySQL Database and Querying GNPBeginner๐Ÿš€ Start Lab
25Country GNP and Population QueryBeginner๐Ÿš€ Start Lab
26Creating Stored Procedures for Course Data RetrievalBeginner๐Ÿš€ Start Lab
27Creating Secure MySQL User AccountsBeginner๐Ÿš€ Start Lab
28Creating Product Information TableBeginner๐Ÿš€ Start Lab
29SQL Queries for Student Course AnalysisBeginner๐Ÿš€ Start Lab
30MySQL Database Management FundamentalsBeginner๐Ÿš€ Start Lab
31Mastering Database Management with SQLBeginner๐Ÿš€ Start Lab
32Delete Course Schedule View DataBeginner๐Ÿš€ Start Lab
33Delete Expired Course InformationBeginner๐Ÿš€ Start Lab
34Comprehensive MySQL Data ManipulationBeginner๐Ÿš€ Start Lab
35SQL Querying for Employee DataBeginner๐Ÿš€ Start Lab
36Mastering MySQL Database ManagementBeginner๐Ÿš€ Start Lab
37Format Query for Teacher SalaryBeginner๐Ÿš€ Start Lab
38General Function Comprehensive ChallengeBeginner๐Ÿš€ Start Lab
39Accessing MySQL Database and SQL QueryingBeginner๐Ÿš€ Start Lab
40Identify MVP Recipient in GameBeginner๐Ÿš€ Start Lab
41Mastering Database Joins for Personnel DataBeginner๐Ÿš€ Start Lab
42Largest Population by CountryBeginner๐Ÿš€ Start Lab
43Largest Population in Five CountriesBeginner๐Ÿš€ Start Lab
44Create MySQL Maximum Value FunctionBeginner๐Ÿš€ Start Lab
45Modifying MySQL Database Table ConstraintsBeginner๐Ÿš€ Start Lab
46Modify Primary Key of Countrylanguage TableBeginner๐Ÿš€ Start Lab
47Modify Student Table AttributesBeginner๐Ÿš€ Start Lab
48Mastering MySQL Data AnalysisBeginner๐Ÿš€ Start Lab
49Number of Users With Modify PermissionsBeginner๐Ÿš€ Start Lab
50Obtain Pi With Two DecimalsBeginner๐Ÿš€ Start Lab
51Official Languages in Various CountriesBeginner๐Ÿš€ Start Lab
52Personnel Management System Database SetupBeginner๐Ÿš€ Start Lab
53Print Current Login User InformationBeginner๐Ÿš€ Start Lab
54Printing Current Time with MySQLBeginner๐Ÿš€ Start Lab
55Print Standard Body Temperature in FahrenheitBeginner๐Ÿš€ Start Lab
56Query City Information for Specified IDsBeginner๐Ÿš€ Start Lab
57Query City Names With CountryBeginner๐Ÿš€ Start Lab
58Query GDP for All CountriesBeginner๐Ÿš€ Start Lab
59Query Is So SlowBeginner๐Ÿš€ Start Lab
60Query Population of All CountriesBeginner๐Ÿš€ Start Lab
61SQL Database Creation and Non-Equijoin QueryBeginner๐Ÿš€ Start Lab
62Query User Levels With Left JoinBeginner๐Ÿš€ Start Lab
63Querying Country Codes RangeBeginner๐Ÿš€ Start Lab
64Querying Official Languages and SortingBeginner๐Ÿš€ Start Lab
65Querying Official Languages of Each CountryBeginner๐Ÿš€ Start Lab
66Reverse Print File Content CommandBeginner๐Ÿš€ Start Lab
67Right Outer Join Query User LevelBeginner๐Ÿš€ Start Lab
68Salary Range for Teachers by Department.Beginner๐Ÿš€ Start Lab
69Search for Favorite CoursesBeginner๐Ÿš€ Start Lab
70Stored Procedure Cursor Database RetrievalBeginner๐Ÿš€ Start Lab
71Student Grade Management SystemBeginner๐Ÿš€ Start Lab
72Creating Database Views in MySQLBeginner๐Ÿš€ Start Lab
73Mastering SQL Subqueries for Data AnalysisBeginner๐Ÿš€ Start Lab
74Top 5 Countries by Land AreaBeginner๐Ÿš€ Start Lab
75Updating Student GPA in MySQL DatabaseBeginner๐Ÿš€ Start Lab
76Creating and Updating Database ViewsBeginner๐Ÿš€ Start Lab
77MySQL Database Administration EssentialsBeginner๐Ÿš€ Start Lab
78View for Course InformationBeginner๐Ÿš€ Start Lab
79Exploring MySQL User PermissionsBeginner๐Ÿš€ Start Lab
80Wuxu Reform Duration CalculationBeginner๐Ÿš€ Start Lab
81Extending Entity with Custom PropertiesBeginner๐Ÿš€ Start Lab
82Operate the Course TableBeginner๐Ÿš€ Start Lab
83Practical Use of resultMapBeginner๐Ÿš€ Start Lab
84Course Schedule CRUD With MyBatisBeginner๐Ÿš€ Start Lab
85Build a Simple URL Shortener With Flask and MySQLAdvanced๐Ÿš€ Start Lab

More