Welcome to SQLPad Tutorials 📖️
Find tips and techniques for your data job search and career.
Leon
Instacart Machine Learning Engineer Interview
Instacart machine Learning Engineer job interview case study, coding and algorithm, machine learning system design, behavioral question.
Last updated on: Nov. 27, 2021
Leon
How I 14Xed my salary in 14 years
How I increased my full-time job salary 14 times in my 14 years of career. I talked about IPO, RSU, startups and working at FAANG companies.
Last updated on: Nov. 27, 2021
Leon
Uber Machine Learning Engineer Interview
Uber Machine Learning Engineer job interview case study, sample questions: coding, machine learning system design, behavioral questions.
Last updated on: Nov. 24, 2021
Leon
Doordash Machine Learning Engineer Interview
Doordash machine Learning Engineer job interview case study, sample questions: coding, machine learning system design, behavioral question.
Last updated on: Nov. 24, 2021
Leon
Twitter Machine Learning Engineer Interview
Twitter machine Learning Engineer job interview case study, sample questions: coding, machine learning system design, behavioral question.
Last updated on: Nov. 23, 2021
Leon
Yelp Product Data Scientist Job Interview
Yelp product data scientist job interview case study, sample questions, SQL, Python, product sense, statistics, and machine learning
Last updated on: Nov. 21, 2021
Leon
Doordash machine learning data scientist job interview
Doordash Machine Learning Data Scientist job interview case study, take-home assignment, product sense, ab testing, behavioral questions.
Last updated on: Nov. 21, 2021
Leon
Amazon Business Intelligence Engineer (BIE) interview case study
Amazon Business intelligence engineer (BIE) interview case study. How Lisa (one of our instamentor's users) prepared for a BIE role at Amazon
Last updated on: Nov. 20, 2021
Leon
Facebook product data scientist interview: case study
An interview with an instamentor member Jennie, who shared her experience interviewing Facebook product data scientists.
Last updated on: Nov. 20, 2021
Leon
Facebook data engineer interview case study
Facebook data engineer interview case study and sample python and SQL questions.
Last updated on: Nov. 20, 2021
Leon
Dropbox Data Engineer Interview Case Study
Dropbox data engineer interview case study. 3 rounds of interviews: 1. HR call, 2. SQL coding interview, 3. virtual onsite interviews.
Last updated on: Nov. 20, 2021
Leon
Walmart Data Scientist Interview Case Study
Walmart Labs personalization team Data Scientist case study. Sample coding questions including Python, SQL, Machine Learning modeling.
Last updated on: Nov. 20, 2021
Leon
Amazon Data Scientist (L5) Interview Case Study
Amazon Web Service: AWS Data Scientist L5 case study with instamentor customer. SQL, Machine Learning, leadership, behavioral questions.
Last updated on: Nov. 20, 2021
Leon
Redfin Data Analyst Interview Case Study
Redfin data analyst job interview case study, sample questions, take home assignment, SQL, product sense, ab testing
Last updated on: Nov. 20, 2021
Leon
LinkedIn Staff Data Scientist Interview
LinkedIn Staff data scientist job interview case study, sample questions, SQL, Python, product sense, statistics, and machine learning
Last updated on: Nov. 20, 2021
Leon
SQL Knowledge/Concept Interview Cheatsheet
SQL Knowledge/Concept Interview Cheatsheet for non-coding interviews, usually people ask them in the first two rounds of phone screens.
Last updated on: Nov. 17, 2021
Leon
Lyft Data Scientist Interview | Case Study
Lyft senior data scientist job interview case study including sample questions in SQL, Product Sense, leadership, statistics.
Last updated on: Oct. 11, 2021
Leon
From competing with Google to independent business advisor, an interview with Ittai Shiu
In this interview, I talked to Ittai Shiu, who is a marketing operation expert and a savvy business leader with 15 years of experience in advertising.
Last updated on: Oct. 1, 2021
Leon
From Microwaving fresh salad to a female tech leader | mentor interview with Chen Zhao
I talked to Chen Zhao, a seasoned female leader in the tech industry, who's worked at some of the biggest technology companies in the world i
Last updated on: Sept. 23, 2021
Leon
Product owner’s mindset: software engineers' key to career advancement. | chunzhao
I talked to Chunzhao, a software architect with 15 years of software engineering experience, who currently works on Facebook’s distributed AI projects
Last updated on: Sept. 19, 2021
Leon
SQL Window Functions for Job Interviews
Advanced SQL window tutorials, interview questions, and solutions: ROW NUMBER, RANK, NTILE, LAG, LEAD, PARTITION BY, online SQL playground for free practice.
Last updated on: Sept. 19, 2021
Leon
Job search is hard, community and mentors are here to help | Alex Chao
I talked to our latest mentor, Alex Chao. Alex is currently a principal product manager at SambaNova Systems, an AI chip company.
Last updated on: Aug. 11, 2021
Leon
Two secret weapons for your job search and career: networking and showing initiatives.
Advice for anyone who wants to land a job at wall street and work at an investment bank, why Leetcode is not good in finding machine learning/data scientist
Last updated on: Aug. 11, 2021
Leon
Data Scientist interview case study: Stripe
Stripe data scientist interview case study, data challenge, final interview including statistical analysis, product sense, a/b testing, leadership/behavioral qu
Last updated on: July 27, 2021
Leon
SQLPad founder Leon Wei, recently did an AMA on Reddit r/sql, he answered some great questions in database, data science, latest technology, industry trends, gr
Last updated on: July 22, 2021
Leon
Why is SQL so important for your data scientist career?
SQL is crucial for data scientists since 90% of the time is spent on data processing/munging.
Last updated on: July 21, 2021
Leon
Data Scientist Job Interview Prep: 7 Steps for Analytics & Inference Track
Prepare analytics track data scientist interview in 7 steps: SQL, Product Sense, Basic Data Processing, A/B testing, Statistics, Probability, Behavior Questions
Last updated on: July 15, 2021
Leon
11 Tools for Productive Data Analytics Professionals - The fullstack data scientist toolkit
The full stack data scientist toolkit: 11 categories of apps and services for enhancing your productivity as a data analytics professional.
Last updated on: July 8, 2021
Leon
SQL Interview at FAANG: an overview
A walkthrough of a typical SQL interview process in Silicon Valley tech companies. Tips and techniques to improve your chance of getting your dream data jobs.
Last updated on: July 8, 2021
Leon
Common mistakes to avoid in a job search: applying for dream company too early, generic resume, unprepared on behavioral questions, missing out on good chances
Last updated on: July 7, 2021
Leon
Data Scientist Resume Writing: 5 quick tips
5 actionable quick tips and techniques to improve your data scientist resume and make it stand out in the 2021's job market.
Last updated on: July 7, 2021
Leon
How to install Postgres on a Mac with Homebrew in 5 minutes
Step by step guide on how to install the latest Postgres server on a Mac with homebrew, and how to update its configuration file to improve its performance.
Last updated on: July 7, 2021
Leon
9 behavioral questions you must prepare for a data scientist job interview in 2021
Behavioral questions are probably the most frequently asked questions during a job interview process, and they must be well prepared. Don’t ever overlook them.
Last updated on: July 7, 2021