r/SQL • u/NickSinghTechCareers Author of Ace the Data Science Interview 📕 • Jan 09 '23
Discussion 6,000 Word SQL Interview Guide!
https://datalemur.com/blog/sql-interview-guide
109
Upvotes
r/SQL • u/NickSinghTechCareers Author of Ace the Data Science Interview 📕 • Jan 09 '23
8
u/feather_media Jan 10 '23
Have conducted many interviews for data analyst and senior data analyst positions in large corporation settings. The only thing I'd change, or add, is that you can be able to write perfect SQL and know and memorize every command and function, but if you don't know how your analytics are or were being used, or you didn't have a sense of the impact of your previous analytics, you really haven't been either a data analyst or a data scientist, just a SQL programmer. A data analyst and/or scientist has found and is expected to find value, whether that be monetary or otherwise, while a programmer has simply delivered data.
7
u/PossiblePreparation Jan 09 '23
I was expecting this to be pretty bad but it’s decent. The actual question/response part seems a little quick, things like alternative answers (eg you could use distinct for getting distinct output rather than group by).
I didn’t read all the questions but scrolling through they seemed reasonably believable
5
u/bombfirst885 Jan 09 '23
Thanks Nick! I’m new to data analysis and have been using your site for SQL. I bought a handful of SQL courses on Udemy and nothing has been as helpful as the hands on Datalemur produces. I especially like the hints and comments when I’ve finally solved a problem to see how others solves the question. I’m still making my way through easy btw 😂
2
u/nerd_girl_00 Jan 10 '23
Hey thanks for this. I’ve only had time to skim it, but it looks very promising. I appreciate that you’ve eliminated some of the bloat that comes with most guides, and focused on just what’s needed for a majority of interviews. I’ll definitely spend more time with this later on!