SQL, Python, and Career Tutorials - Page 10

Oct 17, 2026 Career

Yelp Product Data Scientist Job Interview

Yelp product data scientist job interview case study, sample questions, SQL, Python, product sense, statistics, and machine learning

Leon Wei

SQLPad Author

Oct 17, 2026 Career

LinkedIn Staff Data Scientist Interview

LinkedIn Staff data scientist job interview case study, sample questions, SQL, Python, product sense, statistics, and machine learning

Leon Wei

SQLPad Author

Oct 17, 2026 Career

Redfin Data Analyst Interview Case Study

Redfin data analyst job interview case study, sample questions, take home assignment, SQL, product sense, ab testing

Leon Wei

SQLPad Author

Oct 17, 2026 Career

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.

Leon Wei

SQLPad Author

Oct 17, 2026 Career

SQL Interview Concepts: Keys, Joins, NULLs, and Transactions

Answer SQL concept questions accurately with tested examples for WHERE and HAVING, foreign keys to unique keys, and NULL-aware counting.

Leon Wei

SQLPad Author

Oct 17, 2026 Career

Walmart Data Scientist Interview Case Study

Walmart Labs personalization team Data Scientist case study. Sample coding questions including Python, SQL, Machine Learning modeling.

Leon Wei

SQLPad Author

Oct 17, 2026 Career

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.

Leon Wei

SQLPad Author

Oct 17, 2026 Career

Lyft Data Scientist Interview | Case Study

Lyft senior data scientist job interview case study including sample questions in SQL, Product Sense, leadership, statistics.

Leon Wei

SQLPad Author

Oct 17, 2026 Career

Facebook Data Engineer Case Study: Four Worked Python Prompts

Read a historical data engineer interview account and practice four complete Python solutions with explicit ordering, missing-value, and tie rules.

Leon Wei

SQLPad Author

Oct 17, 2026 Career

Facebook product data scientist interview: case study

Facebook product data scientist interview: case study, sql, product sense, sample questions.

Leon Wei

SQLPad Author

Apr 29, 2024 SQL

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

Leon Wei

SQLPad Author

Apr 29, 2024 SQL

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.

Leon Wei

SQLPad Author

Oct 17, 2026 Career

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

Leon Wei

SQLPad Author

Oct 17, 2026 Career

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

Leon Wei

SQLPad Author

Apr 29, 2024 Career

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.

Leon Wei

SQLPad Author

Oct 17, 2026 SQL

Install PostgreSQL 16 on Apple Silicon with Homebrew

Install a fresh PostgreSQL 16 development server on Apple Silicon, verify the actual instance, and preserve existing clusters during setup and upgrades.

Leon Wei

SQLPad Author

Oct 17, 2026 AI

Deploy a Django ML API to Heroku: Settings and Verification

Prepare the Django sentiment API for Heroku with explicit secrets, host and HTTPS settings, a Procfile, local smoke tests, release checks, and rollback.

Leon Wei

SQLPad Author

Oct 17, 2026 AI

Serve a Machine Learning Model with a Django API

Build a small Django sentiment API with supplied training data, explicit labels, bounded JSON input, bearer authentication, and executable error checks.

Leon Wei

SQLPad Author