Welcome to SQLPad Tutorials 📖️

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

How to install MySQL on Mac with Apple M1 chip?
...

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

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

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

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, Data Processing, A/B testing, Statistics, Probability, Behavioral

Last updated on: Aug. 30, 2022

SQL Window Functions for Job Interviews
...

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

Apple Data Scientist Interview
...

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

Spotify data scientist interview
...

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

How to move to the USA to work in data science as a non-USA citizen?
...

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

9 Reasons you should work at FAANG as a Data Scientist in 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

How I 14Xed my salary in 14 years as a data analytics / science professional
...

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

Amazon Data Engineer job interview
...

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

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 odds of your dream jobs.

Last updated on: Dec. 8, 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. 30, 2021

Google Cloud Data Scientist Job Interview
...

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

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

Last updated on: Nov. 30, 2021

Amazon Economist Job Interview
...

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

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

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

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