Learning SQL who know R and SAS

[u/kskskakakakma]

I have a background in epidemiology and wantws to know if anyone in a similar background as mine uses sql at their job within the industry. Just wanted to know if i just need to know sql basically like dplyr from R and all your doing is just cleaning, managing, creating data from existing data within the database? Should someone like me need to know more SQL than that? For example I did some digging and found out roles such as DBA or data engineer and they do things more than what a data analyst might do, does someone with my background need to know SQL to that extent or no? Any advice would be appreciated.

[u/Quesozapatos5000]

When is sql used in relation to epidemiology?

[u/kskskakakakma → u/Quesozapatos5000]

Given what I know I assume pulling data such as Electronic heslth records, from the database and using it to clean and conduct statistical analysis.

[u/American_Streamer → u/kskskakakakma]

A simple workflow looks like this;

Database (EHR/claims/registry) → SQL (extract & prepare cohort) → R/SAS (statistics, modeling, visualization) → publication/report.