-
Notifications
You must be signed in to change notification settings - Fork 0
stringzzz/MySQL_Practice_Databases
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
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 0
No packages published