Ask HN: SQL interview in 2 weeks, how to best prepare?
Hi HN, I have an interview lined up for a data science (intern) position in about two weeks time. This is after I passed an initial take-home assessment testing Python (Pandas) and basic SQL. I received comments from the HR staff that my SQL 'could do some brushing up', which I expected since I had never really worked with it beforehand. He also informed me upfront that the interview in 2 weeks time would 'grill' me on SQL by more experienced and software oriented members of the team.
How should I go about better securing my odds of passing the interview? Previously, I worked through the excellent exercises at https://pgexercises.com/ and am planning to at least go through the introduction for the Stanford Databases course. Are there any other resources (books, online tutorials with exercises) that I could go through in this short span of time which would help me learn as much as possible?
(if it helps, I find that I am still weak on window functions and best practices when it comes to complex queries) HackerRank's practice questions are pretty good.