Journey to FAANG - Interview Tips and Strategies

Job hunting and giving interviews is not something you do often that you can learn from your mistakes and improve upon. That is the reason I wanted to write this so you learn from my mistakes and see if what worked for me will work for you. I did my best to provide unique and new information that you may not find elsewhere. 💡 This is tailored for data scientist positions in top tech (FAANG) and equivalent companies. Some of it may apply to everyone like (Resume, Behavioral prep), but not all. ...

Comparison operators LIKE is case sensitive ILIKE is not BETWEEN includes the range bounds IS NULL is for missing values. column=NULL will not work. For non null values - use IS NOT NULL. Don’t use NOT IS NULL Aggregate function COUNT COUNT(col) gives of count of col where values are not null. This is the main difference between COUNT(*) and COUNT(col) SUM, AVG and COUNT can only be used for numeric values. (duh!) AVG ignores null values completely. Does not take in the denominator MIN and MAX can be used for numeric, date, chars GROUP BY ...