Skip to content

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

Notifications You must be signed in to change notification settings

labex-labs/practice-mysql-programming-projects

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

41 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

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

About

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

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published