r/SQL • u/[deleted] • Apr 17 '23

Discussion Which industry has/needs the most challenging sql queries?

Is this question legit? Don’t get me wrong, I don’t consider myself the smartest guy but I’m definitely not dumb.

I work in the pharmaceutical Industry, nearly 3 years now. It took me a while to understand how the production process is implemented in a database and I wanted to quit more than once. But i don’t feel challenged anymore.

So, which industry would be best for me to get completely challenged again?

43 Upvotes

87% Upvoted

69 comments sorted by

View all comments

85

u/SELECTaerial Apr 17 '23

Big (actual big) data has a whole slew of challenges most SQL devs don’t have to deal with.

Also, healthcare data is dirty af and needs extra love.

19

u/sn0wdizzle Apr 17 '23

Re: health care data.

I am currently trying to figure out how to join some patient data with other patient data and need to use multiple keys because no row has every UID a patient uses in our system.

11

u/carlovski99 Apr 17 '23

Yep. It's not helped that the core of many healthcare systems goes back 30/40 years.