Welcome to SQLPad Tutorials 📖️

Find tips and techniques for your data job search and career.

Instacart Machine Learning Engineer Interview
...

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

How I 14Xed my salary in 14 years
...

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

Uber Machine Learning Engineer Interview
...

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

Doordash Machine Learning Engineer Interview
...

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

Twitter Machine Learning Engineer Interview
...

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

Yelp Product Data Scientist Job Interview
...

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

Doordash machine learning data scientist job interview
...

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

Amazon Business Intelligence Engineer (BIE) interview case study
...

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

Facebook product data scientist interview: case study
...

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

Facebook data engineer interview case study
...

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

Dropbox Data Engineer Interview Case Study
...

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

Walmart Data Scientist Interview Case Study
...

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

Amazon Data Scientist (L5) Interview Case Study
...

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

Redfin Data Analyst Interview Case Study
...

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

LinkedIn Staff Data Scientist Interview
...

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

SQL Knowledge/Concept Interview Cheatsheet
...

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

Lyft Data Scientist Interview | Case Study
...

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

From competing with Google to independent business advisor, an interview with Ittai Shiu
...

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

From Microwaving fresh salad to a female tech leader | mentor interview with Chen Zhao
...

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

Product owner’s mindset: software engineers' key to career advancement. | chunzhao
...

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

SQL Window Functions for Job Interviews
...

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

Job search is hard, community and mentors are here to help | Alex Chao
...

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

Two secret weapons for your job search and career: networking and showing initiatives.
...

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

Data Scientist interview case study: Stripe
...

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

SQLPad Q&A
...

Leon


SQLPad Q&A

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

Why is SQL so important for your data scientist career?
...

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

Data Scientist Job Interview Prep: 7 Steps for Analytics & Inference Track
...

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

11 Tools for Productive Data Analytics Professionals - The fullstack data scientist toolkit
...

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

SQL Interview at FAANG: an overview
...

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

Job search mistakes to avoid
...

Leon


Job search mistakes to avoid

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

Data Scientist Resume Writing: 5 quick tips
...

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

How to install Postgres on a Mac with Homebrew in 5 minutes
...

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

9 behavioral questions you must prepare for a data scientist job interview in 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