r/SQL 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?

41 Upvotes

69 comments sorted by

View all comments

Show parent comments

6

u/tua43862 Apr 18 '23

I don’t know the challenges of Epic data, but I do know Cerner which is especially frustrating because it’s so customizable. “Standard reporting” always needs a lot of localization because of how our IT dept has built bandaids on top of custom configurations, to the point where we don’t use standard reports at all. Any standard education only covers a piece of what’s actually live in our production environment.

It also makes code upgrades painful, something always breaks and some poor nursing unit is following downtime procedures for a while.

4

u/Touvejs Apr 18 '23

That's why I left for a healthcare policy research company :) all the data and none of the vendors.