-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathREADME.txt
More file actions
18 lines (11 loc) · 1.15 KB
/
README.txt
File metadata and controls
18 lines (11 loc) · 1.15 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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