Best resource on how to prepare oneself for programming interview.
https://www.linkedin.com/pulse/20141120061048-6976444-ace-the-coding-interview-every-time
Key Takeaways -
1. Cracking the Coding Interview: 150 Programming Questions and Solutions – to date, there is not a better book out there for technical interview preparation
Additional links from the same site
- "Get that job at Google" - Steve Yegge. The original article, and by far the best reference on the topic
- "Get that job at Facebook" - Carlos Bueno
- "Get that job at Microsoft" - Nick Ciubotariu (shameless plug)
Practice some programming from the below links -
http://codekata.pragprog.com/2007/01/code_katahow_it.html
Reference for a Data Scientist position
https://alyaabbott.wordpress.com/2014/10/01/how-to-ace-a-data-science-interview/
http://ucanalytics.com/blogs/data-science-job-interview-types-sample-questions-preparation-strategies/
https://www.quora.com/Data-Science-What-are-some-ways-to-prepare-for-a-data-challenge-with-a-Silicon-Valley-tech-company
SQL References
http://sqlzoo.net/wiki/SELECT_basics
http://blog.sqlauthority.com/sql-server-interview-questions-and-answers/
http://www.artfulsoftware.com/infotree/queries.php
https://www.simple-talk.com/sql/t-sql-programming/how-to-get-nulls-horribly-wrong-in-sql-server/
Probablity and Statistics
https://www.amazon.com/First-Course-Probability-9th/dp/032179477X