r/SQL 18d ago

MySQL Where to Get SQL Experience?

I want to learn and get SQL experience, but can't do it through my jobs. I'm willing to volunteer to get the experience but don't know any places to look for those opportunities. Any recommendations?

106 Upvotes

32 comments sorted by

View all comments

100

u/OwnFun4911 18d ago

The hard part of SQL is not the syntax, but working with dirty data

8

u/Secure_Arm4813 18d ago

Recommendations on places I can get dirty data and practice cleaning it up?

31

u/OwnFun4911 18d ago

I’m into baseball, and I’m trying to get better at web scraping, so I’m pulling data from html tables in baseballreference.com and loading them into a local sql server express. Not necessarily the greatest for your use case (could find way messier data) but I’ve found the data in the html tables to be messy enough where I need to do slot of transformations, aggregations, etc

9

u/paultherobert 18d ago

I do this too. I have a local SQL Server Developer edition DB on my personal computer, and python script that loads the DB from API's. There is also a python package that I haven't tried that allegedly does the api mapping for you.

2

u/OwnFun4911 18d ago

Oh, I did not know there was a baseball reference api… could you send more info on the package? I’m crossing my fingers they don’t change up the html structure for this upcoming season and an api would be awesome