Welcome to SQLPad Tutorials 📖️

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

What a typical SQL interview looks like at a FAANG company
...

Leon


What a typical SQL interview looks like at a FAANG company

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: Jan. 6, 2021

7 Steps to Prepare a Data Scientist Job Interview in Silicon Valley in 2021. Analytics & Inference Track
...

Leon


7 Steps to Prepare a Data Scientist Job Interview in Silicon Valley in 2021. 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: Dec. 31, 2020

5 Quick Tips to Make Your Data Scientist Resume Stand Out in 2021
...

Leon


5 Quick Tips to Make Your Data Scientist Resume Stand Out in 2021

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: Dec. 31, 2020

4 Essential SQL Window Functions and Examples for a Data Scientist Interview in 2021
...

Leon


4 Essential SQL Window Functions and Examples for a Data Scientist Interview in 2021

Step by step tutorial for 4 major families of SQL window functions: aggregate functions, ROW_NUMBER/RANK, NTILE, LAG/LEAD with real interview questions examples

Last updated: Dec. 31, 2020

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: Dec. 30, 2020

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: Dec. 30, 2020