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.
SQLPad Author
SQLPad Blog: Master Python, SQL, R, Career Insights, and Interview Strategy
Explore SQL, Python, and R tutorials, career guidance, job search strategies, and practical interview tips for data professionals.
Walmart Data Scientist Interview Case Study
Walmart Labs personalization team Data Scientist case study. Sample coding questions including Python, SQL, Machine Learning modeling.
SQLPad Author
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.
SQLPad Author
Lyft Data Scientist Interview | Case Study
Lyft senior data scientist job interview case study including sample questions in SQL, Product Sense, leadership, statistics.
SQLPad Author
Facebook data engineer interview case study and interview questions
Facebook data engineer interview case study with data engineer interview questions and data modeling interview questions.
SQLPad Author
Facebook product data scientist interview: case study
Facebook product data scientist interview: case study, sql, product sense, sample questions.
SQLPad Author
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
SQLPad Author
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.
SQLPad Author
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
SQLPad Author
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
SQLPad Author
Common Job Search Mistakes That Slow Down Strong Candidates
Avoid the process mistakes that drag out a data job search: generic resumes, weak pipelines, poor timing, and unstructured prep.
SQLPad Author
How to install Postgres on a Mac M1 with Homebrew in 5 minutes
Effortlessly install Postgres 14 on Apple Silicon (M1, M2, M3) Macs using Homebrew. This guide includes configuration tips for enhanced performance.
SQLPad Author
Django for Data Scientists Part 2: Deploy A Machine Learning Model RESTFul API to the Cloud (Heroku)
Step by step tutorial to create a RESTful API to serve a machine learning model with Python/Django, Scikit-Learn and Heroku
SQLPad Author
Django for Data Scientists Part I: Serving A Machine Learning Model through a RESTFul API
Tutorial on productionize a machine learning model by serving it through a RESTFul web API server with Django and Django cookie-cutter.
SQLPad Author
What a Modern SQL Interview Looks Like
How SQL interviews are run today, what interviewers score, the warehouse skills that matter, and how to practice the right way.
SQLPad Author
9 Behavioral Questions to Prepare for Data Interviews
Use a repeatable story structure to answer the behavioral questions that show up in analytics, data science, and product interviews.
SQLPad Author
5 Resume Upgrades That Help Data Candidates Get Interviews
A resume guide for data professionals: write for fast recruiter scans, ATS filters, and hiring-manager follow-up questions.
SQLPad Author
7 Steps to Prepare for a Modern Data Science Interview
A practical interview prep plan for data roles covering SQL, Python, experimentation, behavioral stories, and process management.
SQLPad Author
4 SQL Window Function Patterns You Need for Interviews
The window function patterns most data interviews test: running metrics, latest-row logic, ranking, and period-over-period analysis.
SQLPad Author