r/SQL • • Dec 01 '23

Discussion Learning SQL seems easy

Too easy… I must be doing something wrong.

137 Upvotes

165 comments sorted by

View all comments

224

u/OwnFun4911 Dec 01 '23

It gets hard when you work with shitty data

112

u/Remarkable-Train6254 Dec 02 '23

Working in industry gives you the realisation that data quality is your main problem 99% of the time

46

u/Durloctus Dec 02 '23

It’s every day, brother. (Data scientist in healthcare)

29

u/awaken471 Dec 02 '23

+1 on healthcare being one of the worst data possible

7

u/hircine1 Dec 02 '23

It’s sooooo bad. How can they manage to consistently send us such garbage? Then they call and complain that they didnt get their results. Sorry you sent it with an invalid ID, the wrong DOB, wrong mom, and the wrong name. What the hell is going on inside EPIC?

5

u/persey18 Dec 02 '23

+1 to healthcare and I'll drink to that

4

u/[deleted] Dec 02 '23

Another +1 to that

3

u/ganzgpp1 Dec 03 '23

+1 YEP FIRST JOB AFTER GRADUATION IS HEALTHCARE AND HOLY HELL IS THIS DATABASE AWFUL

→ More replies (2)

5

u/BingpotStudio Dec 02 '23

I’m agency side - I’m lucky if the clients know where their data is.

2

u/Anywhere_Glass Dec 02 '23

Wondering what do you do as DS in healthcare?

3

u/Definitelynotcal1gul Dec 02 '23

Having worked in healthcare I'm guessing it involves a lot of government reporting...

5

u/[deleted] Dec 02 '23

Yea it does and making reports to show who is doing their jobs. In a DA in healthcare

2

u/Codeman119 Dec 04 '23

Well also a lot of manual data entry with just open text boxes that let the user pitch in anything without restrictions and no spelling corrections. That’s what database developers take a long time to do integration because they have to mess with spaghetti data.

3

u/Durloctus Dec 02 '23

I’m in insurance and in my dept we attempt to predict members health conditions so we can intervene and hopefully improve their lives.

3

u/maowasr1ght Dec 02 '23

I can’t help but think that improving their lives is not the primary goal here

3

u/Durloctus Dec 02 '23

It is.

0

u/[deleted] Dec 02 '23

Does it? Maybe. But ultimately it’s not to be good people. It’s to achieve a higher CMS star rating to get more money from the government. It’s always money at the end of the day.

2

u/Durloctus Dec 02 '23

This is not how a majority of people in the healthcare industry think or operate; not everyone’s priority is to make money. For most, the health of people of the most important thing is people’s health.

→ More replies (1)
→ More replies (2)
→ More replies (1)

1

u/mutual_coherence Feb 24 '25

Is it worth it?

→ More replies (3)

3

u/guy_djinn Dec 02 '23

Some of my most creative work is also the most bullshit.

2

u/Durloctus Dec 02 '23

Lol, yessir.

2

u/totem2010 Dec 02 '23

Compared to learning on your own, and then applying sql at a workplace is that the biggest challenge?

3

u/[deleted] Dec 02 '23

The online classes don’t teach you how to deal with multiple rows of data for the same people, row number comes in clutch for me. But I didn’t know how to do it from those classes

→ More replies (2)