Welcome to SQLPad Tutorials 📖️
Find tips and techniques for your data job search and career.
Leon
How to install MySQL on Mac with Apple M1 chip?
A step-by-step guide to install the latest MySQL 8 on an M1 Mac with homebrew, and how to fine tune its configuration to improve the performance
Last updated on: Nov. 11, 2022
Leon
How to install Postgres on a Mac M1 with Homebrew in 5 minutes
A step-by-step guide to install the latest Postgres 14 on an M1 Mac with homebrew, and how to fine tune its configuration to improve the performance
Last updated on: Nov. 11, 2022
Leon
Data Scientist Job Interview Prep: 7 Steps for Analytics & Inference Track
Prepare analytics track data scientist interview in 7 steps: SQL, Product Sense, Data Processing, A/B testing, Statistics, Probability, Behavioral
Last updated on: Aug. 30, 2022
Leon
SQL Window Functions for Job Interviews
Window functions in SQL interview sample questions & solutions in ROW NUMBER, RANK, NTILE, LAG, LEAD, PARTITION BY, SQL practice in the playground.
Last updated on: Aug. 30, 2022
Leon
Apple Data Scientist Interview
Apple Data Scientist interview case study, interview process, sample questions in SQL, Python, Statistics, Product, machine learning.
Last updated on: May 21, 2022
Leon
Spotify data scientist interview
Spotify Data Scientist interview case study with an instamentor mentee: SQL, Python, Statistics, Product Case Study, take-home challenge.
Last updated on: April 8, 2022
Leon
How to move to the USA to work in data science as a non-USA citizen?
Best practices for that outside of the USA, without a VISA to eventually immigrate to the USA for a data science, machine learning job.
Last updated on: Jan. 19, 2022
Leon
9 Reasons you should work at FAANG as a Data Scientist in 2022
Benefits of working as a FAANG data scientist: opportunities, network, data, income, business problems, visa, job security, matured process
Last updated on: Jan. 14, 2022
Leon
How I 14Xed my salary in 14 years as a data analytics / science professional
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: Jan. 6, 2022
Leon
Amazon Data Engineer job interview
Amazon data engineer job interview case study from an instamentor mentee: sample ETL, data modeling, SQL, data warehouse design questions.
Last updated on: Dec. 12, 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 odds of your dream jobs.
Last updated on: Dec. 8, 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. 30, 2021
Leon
Google Cloud Data Scientist Job Interview
Google Cloud Data Scientist job interview case study, statistics, AB testing, coding, Googliness, behavioral questions/leadership question.
Last updated on: Nov. 30, 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
Last updated on: Nov. 30, 2021
Leon
Amazon Economist Job Interview
Amazon Economist job interview case study, SQL coding, Time Series Analysis, Forecasting system design, leadership and behavioral questions
Last updated on: Nov. 29, 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
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
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