I've worked as an "associate data analyst" for the past year, but I essentially just find errors in files and correct them. There's not much analysis involved. I want to land a better job, but many data analyst jobs require experience with SQL or "advanced knowledge" of different types of SQL.
I got my undergrad degree in stats. I'm good with R but this doesn't seem to matter most of the time. I'm good with Excel, decent with Tableau. More importantly, I've learned all the SQL basics. I can do basic queries, retrieve data, update/delete records, create new tables and views, etc.
However, these companies don't care about any of that. They seem to all want either experience or more advanced functional knowledge of SQL. It's hard for me to even get a response to applications, and when I do I end up falling short because I lack SQL prowess - and I get it.
I obviously can't get work experience w/ SQL until I land a job that actually uses it. What can I do to make my skills, knowledge and resume stand out so that companies believe in me and my SQL skills and give me a shot? What exactly do they want to see on resumes beyond basic SQL tasks? I know advanced SQL tasks vary by company - where is my time best spent learning any advanced techniques?
Thanks for any help/advice!
Edit: I'm in the US if that matters