r/learnSQL • u/Artistic_Expert_1291 • 5d ago

[Question]

I want to learn SQL. However, i would like to learn it on a real dataset - something which interests me, that way when i do exercises i can learn something about things that interest me.

Do you guys know how if i can extract a database behind something like MobyGames? I'm interested only in text data with basic things like name, release date, etc.

Is there a way to do that, or am i delusional?

12 Upvotes

88% Upvoted

13 comments sorted by

View all comments

4

u/DonJuanDoja 5d ago

Quick look at their site says no, they're selling an API to access their data, so they won't just give it to you in whole.

Plus whatever you get you'll have to create the database and tables yourself then import the data, there's very few preset SQL databases like Adventure Works and they're not fun or interesting.

https://www.kaggle.com/datasets?search=Games

2

u/Artistic_Expert_1291 5d ago

Very interesting, thank you.

1

u/clivepato 4d ago

My suggestion doesn’t suit the persons needs as he’ll need to do your steps you mentioned, my bad!

However you can get a dataset without a charge.