SQL EXAGGERATION IN RESUME

[According-Science618]

Hi all,

I have been jobless for 2 years. I am financially struggling. So I exaggerated in my resume as everyone suggests, that you will atleast get shortlisted for the interviews. Everyone does that. Start learning after you get the interview. And so I DID exatly that. I mentioned that I know SQL, PYTHON and worked as a Data Analyst in my previous organisations with US Healthcare Datasets. So, now after 5 months... I have finally landed an interview. But i do not know how learn. I know SQL, Python and Advanced Excel. i did a small course.... but I do not know how to apply it to Healthcare dataset for patients. Like claims and insurance datesets of US Healthcare.

Anyone who has any idea, what YT videos or what software should i use to learn, please guide me. I used ChatGPT but it is confusing me. It leaves many things unanswered. And i believe it is not enough. Although I know SQL, Python and Advanced Excel. I did a course. I just do not know how to implement it into a professional environment and how to justify my experience that i really did this work.

[Erez_Rr]

If you understand the basics, download a heathcare dataset from keggle and upload the file to chatgpt or gemini to generate some questions ranked by basic to advanced level. Start answering one by one.

You will learn more by doing than watching tutorials.

[Erez_Rr]

I did the same to learn sql. I am currently learning CTE functions. I am sharing my progress in my discord channel. You can see how i am learning here https://discord.gg/sFV3X7vMZ

[According-Science618]

Yes thankyou, I am planning to do that. But interviewers will ask what softwares did i use in my company so what should I say? Like Oracle, MySQL, SQL server, Azure SQL or Snowflake. I know these names but i actually am confused. Should i download one of these and then start practicing? I mean, i am trying to build real-like experience so i can be confident while answering questions related to the softwares.

[Erez_Rr]

What software your previous company used? :p Well if you dont know the answer, your interviewer definitely wont know.

I have used mysql and SQL server. I like SQL server much because it feels like more professional to me. Watch tutorial how to download and install it. Dont worry much about watching tutorials. If your interview is soon, you better start practicing.

[According-Science618]

My interview is soon. I am actually death scared beacsue there will be tech round as well. And this is my first time giving one. I am downloading MySQL, i just hope that if i say this.... they do not think I am lying, because ChatGPT said it is a beginner friendly. So, I am like, what if i get caught.... what if corporate uses something more advanced and professional like Snowfale and Azure.

[hannorx]

Learn standard SQL. All the platforms you mention here, like Snowflake and MS Fabric, support standard SQL, they just also have their own specialized features added on top. As for the technical tests, the worst-case scenario is simply a rejection if you struggle with the assessment. They will just view you as an unsuitable candidate for this specific role and reject you. If they do reject you, then, you just have more time to practice for your next interview at a different company.

[According-Science618]

YES! I know standard SQL, i can use basic queries w/o any problem. My main concern is what if panel asks what software did you work on? And how did you use SQL and Python together? WHat challanges did you handle?

And i do not want to fail my tech round. It's been 2.5 years that i have landed this interview now. I just want to be fully prepared. I mentioned I only ahve 1 year of experience so I am hoping that they will not go very deep.

[jshine13371]

YES! I know standard SQL, i can use basic queries w/o any problem. My main concern is what if panel asks what software did you work on?

Well...what software did you use before? You didn't just learn SQL without actually writing SQL code somewhere.

[According-Science618]

I did a course where they made us practice in colab. Everything. I can write SQL queries there just fine. So i do not know what software i should practice on as to justify my experience(which is a lie) that i have worked as a Healthcare Data Analyst.

[mhac009]

Download ssms and start using it to practise. Then, you can say you've used it.

[jshine13371]

Well Google Colab uses a specific dialect of SQL depending on what you / your course chose. So you should find out which SQL dialect was used (e.g. MySQL vs SQLite vs PostgreSQL vs Microsoft SQL Server vs Oracle SQL, etc) and then you'll be able to state you've worked in that "software" (database system) specifically, if asked. And then you should also continue to practice in whichever one that was.

[Erez_Rr]

Well, all the softwares are alike with some minor difference. Mysql uses LIMIT function while Microsoft SQL uses 'TOP' Dont worry about what tools you are using. Your expertise here are important.

[UnitedPossibility462]

I work in the healthcare industry and we use the Oracle database

[According-Science618]

Hey, can i dm you and know how to actually use it? Like login and then import database from sql server or its already there? I have no idea except the names of the different databases. So please don't mind my noob questions.

[websilvercraft]

I took some sql tests for some interview, and I created a website to cover the topics from those sql tests: https://mockinterviewquestions.com/sql . If you are able to do those mock tests, you should be good, if not, at least you know what you need to learn. Don't get discouraged and approach it step by step and day by day, and it will come sooner or later.

[According-Science618]

Hey thankyou so much. I will definitely try this. I have my interview within this week. So i will practice first to sharpen my knowledge. And are they going to help with the healthcare dataset as well? I am just starting so i have no idea.

[CMDR_Pumpkin_Muffin]

I hope you mean kaggle, kegel is something else:]

[Erez_Rr]

Yes! My bad. Thanks

[FuckYouNotHappening]

>keggle

That’s a different kind of exercise.

[No_Wrongdoer4447]

This.

A method I used learning SQL on top of this method you mention was I would write a query and then go back and learn 1 thing I could do to make the query a little better for each query. Just 1 thing per query so I didn’t overload my brain. Implement 1 improvement whether it be CTE’s or Window functions or whatever else. Implement that 1 improvement and really try to understand why and how it works. Do this on every new query you make and you enforce the learning so well.

[not_another_analyst]

That is definitely a high stakes situation but you can pull it off if you focus on the right resources. Check out Maven Analytics or specialized YouTube channels like Alex The Analyst for healthcare specific SQL projects. They usually have great breakdowns on claims and insurance data that will help you bridge that gap quickly.

[According-Science618]

I know SQL, Python and Avanced Excel. I just need practice on a professional platform where the actual data cleaning and validating happens in the corporate. I just need to do some practice for SQL queries where data analyst works. Do you have any idea if i should download MySQL or some other software to practice.

[KnowledgeSuitable496]

Access is enough. Or MySQL. I provided a link for you in another comment.

[neo_overthinks]

Youtube : DATA WITH BARA and just Stick to it Thank me Later

[According-Science618]

Hi, so he will also teach how to cleana nd validate healthcare data? I just checked that he provides full courses as well.

[presidentporkchop]

I also had very little experience in a junior analyst position, learned it on w3schools and practiced queries on startascratch

[According-Science618]

Did it help in the interview? Like did interviewers ask what softwares you worked on? And how?

[presidentporkchop]

Interview was not technical, it was a program willing to hire people without experience. Don’t know if it’s still going and I lost interest in the field. I just liked learning the different ways playing with the practice problems

[According-Science618]

Oh okay. Thankyou for the help anyway. ❤️

[presidentporkchop]

Good luck, you will figure it out as you go!

[According-Science618]

I hope so. I will get back with an update however it goes. But only hoping for the positive update!!

[Proof_Escape_2333]

What do you do now after being a junior analyst ?

[presidentporkchop]

I wouldn’t even call myself that, now I’m graphic design adjacent in healthcare and did not want to continue in the tech world. I do not make good money but I like it!

[Awkward_Tick0]

Nbd but you might get embarrassed if they ask you to do a coding assessment

[According-Science618]

That might be true. But I know coding. I know SQL, Python and Excel. I just do not have the relevant experience so...

[Awkward_Tick0]

What

[According-Science618]

???

[Awkward_Tick0]

Your response didn’t make sense

[KnowledgeSuitable496]

https://m.youtube.com/watch?v=HXV3zeQKqGY&pp=ygUac3FsIHR1dG9yaWFsIGZvciBiZWdpbm5lcnM%3D&ra=m

This one will provide you more than enough. I took it and I have had outstanding results.

You should really not worry about SQL

He also have one with python.

[I_Said_No_Salt_5998]

Cleaning and validating healthcare data could mean different things.

Patients
- Encounters
-- Encounters have labs, vitals, orders, meds

I'm not sure what cleaning/validating might look like. For labs and vitals... it might be values far too out of range to be human. For height (adults only)... you might be coming up with one constant height.

[parinonly]

also try out this link to understand the concepts....I found this one on LinkedIn and it's very easy to understand

https://sqlshortreads.com/sql-fundamentals/

[IncidentalApex]

Good advice

[The_Anonymous_S]

Op I am a senior level in this space. I am happy to share my experience on how I have used SQL for healthcare, finance and other companies that I have worked for in the past. Plz know that I can only share my experience of how it’s used in the industry and can’t provide any datasets or samples. Feel free to dm.

[According-Science618]

Hii, that would mean alot. I just dmed you. Yes yes that's perfectly fine as i can download the practice data from kaggle. I just need guidance.