Personal Docs

Private notes, for my own reference only.

Senior SQL: System Design & Problem-Solving Interview Guide

Reference for navigating production-grade SQL architecture decisions, based on real Amazon assessment scenarios.

August 14, 2026 · 12 min · 2384 words · Sushant Patil

SQL Interview Questions — MySQL Solutions (Part 2)

Real-world SQL interview questions from Stripe, Google, Visa, Amazon, Accenture, Facebook and more, with detailed MySQL solutions.

August 14, 2026 · 18 min · 3807 words · Sushant Patil

SQL System Design & Problem-Solving Master Report (Part 1)

Senior-level SQL interview prep covering core gotchas and fundamentals, starting with NULL-handling traps.

August 14, 2026 · 15 min · 3000 words · Sushant Patil

Deep Learning Interview Map

A master navigation doc tracing why neural networks exist, through CNNs, detection/segmentation, and generative/attention/sequence models.

August 8, 2026 · 68 min · 14386 words · Sushant Patil

All Tree Models — v1 (Comprehensive Intuition Guide)

A walk through every major tree-based model, where each section ends with the specific weakness that motivated the next algorithm.

July 22, 2026 · 99 min · 21067 words · Sushant Patil

Agentic Systems & GenAI Engineering: Production Depth

Interview-ready reference on agentic AI/GenAI engineering — framework choices (LangChain vs CrewAI vs AutoGen), multi-agent orchestration, tool-calling, RAG architecture, and production concerns.

July 19, 2026 · 22 min · 4606 words · Sushant Patil

Apache Airflow — ML Orchestration Skeleton

A translation layer mapping ZenML pipeline concepts onto Apache Airflow architecture, for demonstrating orchestration fluency in interviews.

July 19, 2026 · 13 min · 2756 words · Sushant Patil

AWS Data Ingestion Pipeline — Production Architecture

High-level walkthrough of an AWS-based IoT data ingestion pipeline for a manufacturing use case, and how the core services connect end-to-end.

July 19, 2026 · 9 min · 1846 words · Sushant Patil

Core Statistical Concepts for Senior ML Scientists

A worked-example-driven refresher on core statistics, using a running coin-toss example to build fast, genuine intuition.

July 19, 2026 · 25 min · 5206 words · Sushant Patil

Information Theory — Memory Map for Tree Models

A compact memory map connecting entropy, Gini impurity, and information gain to the specific interview questions they answer.

July 19, 2026 · 7 min · 1480 words · Sushant Patil