Skip to content

labex-labs/database-practice-projects

Repository files navigation

Database Practice Projects

Languages: English · 简体中文 · 日本語 · Español · Français · Deutsch · Русский · 한국어 · Português

Database

Learn Database with a comprehensive learning path designed for beginners. This roadmap features hands-on Database Courses for mastering popular systems like MySQL, Redis, MongoDB, and PostgreSQL. It offers structured learning covering essential concepts, database design, and administration across different database types. Gain real-world experience in database management and querying through practical exercises in interactive database playgrounds.

Explore Projects on LabEx

Projects

Explore 93 beginner-friendly Database projects that turn core language concepts into small, complete programs. Each project opens in LabEx with a ready-to-use environment, so you can focus on building instead of setup.

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

View More on LabEx

About LabEx

LabEx is a hands-on learning platform for beginners.

Explore Linux, DevOps, Cybersecurity, and more — all directly in your browser.

Learn step by step through interactive labs, guided exercises, and real-world projects. 🌱
No setup, no stress — just practice and grow your skills by doing.


Download on the App Store Download on the Mac App Store


📖 Need help? Visit our Help Center or email info@labex.io

About

Database programming projects with guided practice by LabEx.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors