Skip to content

stringzzz/MySQL_Practice_Databases

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

32 Commits
 
 
 
 
 
 

Repository files navigation

Contained in this repo are some .sql files for producing sample databases with completely made up data for practicing SQL queries.

'game_player_table1.sql' and 'global_players1.sql' only contains one table to keep things as simple as possible, a good starting point for 
practicing simple queries.

'library1.sql' has two tables, it's meant for practicing JOINs for just two tables, still pretty simplified.

Finally, 'dairy_store_database.sql' is made to be much more realistic, there are six tables in it and they can be JOINed together in many different ways,
good for practice after learning more.

Additionally, there are .txt files with the same names plus 'sample_queries' on the end containing some sample queries that can work with the table(s) in 
that particular database, along with what each query is grabbing in plain English.

I hope these can be of some use to anyone just starting to learn SQL, as they did help me in practicing.

I will likely keep updating the 'dairy_store_database' as I learn more myself, but I will leave the others in their simple form to make it easier for anyone using them to learn basics of SQL.

--stringzzz, Ghostwarez Co. 09-03-2025

About

Simple databases for practicing MySQL

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published