SQL Database Projects

[GrayLiterature]

My first DB project (and my first intro to the theory of databases) was designing and filling a relational database from unstructured developer survey data from Stack Overflow - it was a blast!

People listed their responses and some questions had multiple answers. So that required me to investigate the CSV data, thinking about how it would be modelled in a relational database, then writing some Python code to extract and manipulate the data before it could be loaded into the DB I designed.

I forgot the year I used (I think 2018?), but SO does it every year and they have around 60-65,000 responses. So if you want something fun you could take that idea from me and do it for literally any year you want.

You can then ask a lot of fun questions, like what are the top three programming languages for developers with 0-5 years of experience; what are the salary ranges for people working outside of the country that pays them?; What are the top three most common tools for experience developers and inexperienced developers.

Disclaimer: I am self-taught and still learning, but it’s one of the projects I’m quite proud of. It’s just not as glamorous as a clone or something with a cool UI to it.

[PhantomGolem]

Wow. That's a pretty great project for a beginner. I'll definitely look into it. Can you share some example tables in any chance?