Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Build real MySQL projects with 85 beginner-friendly challenges. Learn by doing with guided coding exercises and practical applications.

NotificationsYou must be signed in to change notification settings

labex-labs/practice-mysql-programming-projects

Repository files navigation

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 DepartmentBeginner🚀 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

Releases

No releases published

Packages

No packages published

[8]ページ先頭

©2009-2025 Movatter.jp