Most Popular System Design Questions — Mega Compilation
Just for your reference…

Welcome back peeps. This post is for the students who are preparing for their tech interviews. While I’m sitting on the other side of the table as an interviewer now; I know how daunting the prep journey can be. Use it just as a reference/practice resource.
Projects Videos —
All the projects, data structures, SQL, algorithms, system design, Data Science and ML , Data Analytics, Data Engineering, , Implemented Data Science and ML projects, Implemented Data Engineering Projects, Implemented Deep Learning Projects, Implemented Machine Learning Ops Projects, Implemented Time Series Analysis and Forecasting Projects, Implemented Applied Machine Learning Projects, Implemented Tensorflow and Keras Projects, Implemented PyTorch Projects, Implemented Scikit Learn Projects, Implemented Big Data Projects, Implemented Cloud Machine Learning Projects, Implemented Neural Networks Projects, Implemented OpenCV Projects,Complete ML Research Papers Summarized, Implemented Data Analytics projects, Implemented Data Visualization Projects, Implemented Data Mining Projects, Implemented Natural Leaning Processing Projects, MLOps and Deep Learning, Applied Machine Learning with Projects Series, PyTorch with Projects Series, Tensorflow and Keras with Projects Series, Scikit Learn Series with Projects, Time Series Analysis and Forecasting with Projects Series, ML System Design Case Studies Series videos will be published on our youtube channel ( just launched).
Subscribe today!
Tech Newsletter —
If you are interested, you can join my newsletter through which I send tech interview tips, techniques, patterns, hacks — Software Development, ML, Data Science, Startups and Technology projects to more than 30K readers. You can subscribe to Tech Brew :
System Design Case Studies — In Depth
Design Instagram
Design Netflix
Design Reddit
Design Amazon
Design Messenger App
Design Twitter
Design URL Shortener
Design Dropbox
Design Youtube
Design API Rate Limiter
Design Web Crawler
Design Amazon Prime Video
Design Facebook’s Newsfeed
Design Yelp
Design Uber
Design Tinder
Design Tiktok
Design Whatsapp
Most Popular System Design Questions
Mega Compilation : Solved System Design Case studies
Complete Data Structures and Algorithm Series
Github —
Advanced SQL Series
Day 2 : SQL Basics, Query Structure, Built In functions Conditions
Day 4 : Set Theory Operations, Stored Procedures and CASE statements in SQL
Day 6 : Subqueries, Group by, order by and Having clauses in SQL and Analytical Functions
Day 7 : Window Functions, Grouping Sets and Constraints in SQL
Day 8 : BigQuery Basics, SELECT, FROM, WHERE and Date and Extract in BigQuery
Day 9 : Common Expression Table, UNNEST Clause, SQL vs NoSQL Databases
Day 10 : Triggers, Pivot and Cursors in SQL
Day 14 : MySQL in Depth
Day 15 : PostgreSQL inDepth
All the Complete System Design Series Parts —
6. Networking, How Browsers work, Content Network Delivery ( CDN)
For complete tech interview compilation -
- Design a Credit Card Authorization System
- Design a chat service
- Design a ride-sharing service
Complete System Design Series — System Design Made Easy
- Design a URL shortening service
Python projects —
- Design a social media service
- Design a social message board
- Design a system to store time series data
- Design a concurrent Hashmap
- Design an ATM Machine system which can support massive amount of transactions
- Design Airport Baggage system
Part 1 of this mega series ( Day 0 — Day 20) can be found here —
- Design Flight Information Display system
- Design a conference room booking system
- Design newsfeed feature of Facebook
- Design an efficient Mail delivery system
- Design like/dislike feature at Youtube scale.
- Design Instagram.
Part 2 of this mega series ( Day 21 — Day 35) can be found here —
- Design Tik-Tok
- Design twitter
- Design Uber
- Design a logging system
- Design Google Maps
- Design a Video Conferencing System
- Design a file storage service
- Design a video streaming service
Part 3 of this mega series ( Day 36 — Day 48) can be found here —
- Design a smart meter system
- Build Cart as a service
- Design metas newsfeed with live posts
- Design a Limited Time Deals
- Design Twitter’s trending topics
- Design a system that counts the number of clicks on YouTube videos
- Design Gmail
- Design a global system to upgrade software on a fleet of machines
- Design a recommendation system
- Design a food sharing application
- Design an API for a tic tac toe game
- Design payment module for Uber app
Complete Data Preprocessing and Data Visualization with Projects — Mega Compilation Part 2
- Design Truecaller type of system
- Design performance management system (appraisal workflow system) that can be used across companies.
- Design comment system
- Design flight system
- Design Tinder
- Design survey site like surveymonkey
- Design a geographically partitioned multi-player card game.
- Design a kind of kindle fire application
The Most Hilarious Code Comments Ever
- Design a realtime Video chat like Google Duo
- Design News paper & Magazine subscription system
- Design a system like Hackerrank/Top Coder
- Design an API Rate Limiter
- Design a proximity server
- Design a Type-Ahead service
- Design a traffic control system
- Design amazon’s frequently viewed product page
Build Machine Learning Pipelines( With Code)
- Design a toll system for highways.
- Design URL Shortener.
- Design Instant Messenger.
- Design a CDN network
- Design a Google document system
- Design a random ID generation system
- Design a key-value database
- Design the Facebook news feed function
Recurrent Neural Network with Keras
- Design a forum-like systems like Quora, Reddit or HackerNews.
- Design the Facebook timeline function
- Design a function to return the top k requests during past time interval
- Design an online multiplayer card game
- Design an online poker game for multiplayer.
- Design a graph search function
- Design a picture sharing system
- Design an API Rate Limiter system for GitHub or Firebase sites
- Design a search engine
- Design a recommendation system
- Design What’s up
- Discussion and designing LRU cache.
Custom Layers in Keras
- Design a garbage collection system.
- Design a system to capture unique addresses in the entire world.
- Design a recommendation system for products.
- Design a tinyurl system
- Design Paypal
- Design Air traffic control system
- Design Google Maps
- Design Grammarly
- Design AirBNB
- Design a vending machine in Java
- Design a traffic control system
- Design a limit order book for trading systems
Most Popular Coding Questions — Company Wise List : Part 1
- Design an elevator system?
- Design an e-commerce website
- Design an e-commerce website using microservices
- Design a website like Pastebin.
- Design Google’s Web Crawler
- Design Zoom
- Design Twitter
- Design Online Examination Portal
- Design RedBus
- Design BookMyShow
Curated List — The Top & Most Frequently Asked Coding Questions You Should Practice
- Design Domain Backdooring system
- Design Amazon Locker
- Design Movies Review Aggregator System
- Design offline caching system for Ecommerce platform
- Design Amazon E-commerce
- Design Online chess game/Multiplayer game
- Design gaming platform.
- Design a last-mile delivery platform
- Design Foodpanda/Zomato/Swiggy/
- Design Meeting Calendar system
Most Popular Coding Questions — Company Wise List : Part 2
- Design Spotify
- Design Promo Code API
- Design Vending machine
- Design splitwise
- Design Google pay at scale
- Design a Job schedular
- Design Meeting Scheduler
- Design Debugger
- Design Automatic Parking System
- Design malloc, free and garbage collection system.
- Design a system for collaborating over a document
- Design election commission architecture
ANN, Linear Regression, Decision Tree Regression and Random Forest with a project
- Design a garbage collection system
- Design a scalable web crawling system
- Design the Facebook chat function
- Design a trending topic system
- Design a url compression system
- Design Elevator system.
Transfer learning and Text Classification
- Design distributed caching system.
- Design Amazon Locker Service.
- Design Amazon Best Seller Item Service
- Design a global chat service like Whatsapp or a facebook messenger.
- Design dropbox’s architecture.
- Design a picture sharing website.
- Design a news feed
- Design a product based on maps
- Design commenting system
- Design a ranking system.
- Design Amazon Cart system
Natural Language Processing and Convolutions
- Design Google Search
- Design Twitter
- Design Facebook
- Design Snapchat
- Design Instagram
- Design App-store
- Design a music player application
- Design a distributed LRU Cache
- Design Dropbox or Google Drive
Bidirectional Encoder Representations from Transformers ( BERT) with a project
- Design subscription based sports website
- Design Netflix
- Design a Latency Management System
- Design a Library Management System
- Design a Notification service
- Design ESPN/Cricinfo/Cricbuzz
- Design Uber
- Design Whatsapp
Quick Recap : 30 days of Natural Language Processing ( NLP) with Projects Series
- Design Quora
- Design Lookahead system
- Design Google Docs/ Collaborative Editing service
- Design URL Shortner service
30 days of Data Analytics Series —
Day 1 : Data Analytics basics and kickstart of Data analytics with projects series
Day 3 : Data Analytics Ecosystem — Data Life Cycle, Data Analysis complete process ( most important things)
Day 5 : Statistics
Day 6 : Basic and Advanced SQL
Day 8 : Pandas and Numpy
Day 9 : Data Manipulation
Day 10 : Data Visualization — Part 1
Day 11 : Project 1 : Data Visualization — Part 2
Day 12 : Data Visualization — Part 3
Day 13: Tableau — Part 1
Day 14: Tableau — Part 2
Day 15: Tableau — Part 3
Day 16 : Data Analysis Project 2
Day 17 : Data Analysis Project 3
Day 18: Data Analysis Project 4
Day 20 : Data Analysis Project 6
Day 21 : Data Analysis Project 7
Take Complete Hands On Tableau Course : Link
Advanced SQL Series
Day 2 : SQL Basics, Query Structure, Built In functions Conditions
Day 4 : Set Theory Operations, Stored Procedures and CASE statements in SQL
Day 6 : Subqueries, Group by, order by and Having clauses in SQL and Analytical Functions
Day 7 : Window Functions, Grouping Sets and Constraints in SQL
Day 8 : BigQuery Basics, SELECT, FROM, WHERE and Date and Extract in BigQuery
Day 9 : Common Expression Table, UNNEST Clause, SQL vs NoSQL Databases
Day 10 : Triggers, Pivot and Cursors in SQL
Day 14 : MySQL in Depth
Day 15 : PostgreSQL inDepth
Anyways, For Day 15 of 15 days of Advanced SQL, we will cover —
PostgreSQL inDepth
Github for Advanced SQL that you can follow —
All the projects, data structures, algorithms, system design, Data Science and ML, Data Engineering, MLOps and Deep Learning videos will be published on our youtube channel ( just launched).
Subscribe today!
System Design Case Studies — In Depth
Complete Data Structures and Algorithm Series
Github —
Some of the other best Series —
How to solve any System Design Question ( approach that you can take)?
30 days of Data Structures and Algorithms and System Design Simplified
Data Science and Machine Learning Research ( papers) Simplified **
100 days : Your Data Science and Machine Learning Degree Series with projects
Complete Data Visualization and Pre-processing Series with projects
Tech Newsletter —
If you are interested, you can join my newsletter through which I send tech interview tips, techniques, patterns, hacks — Software Development, ML, Data Science, Startups and Technology projects to more than 30K readers. You can subscribe to Tech Brew :
More Projects —
Complete Python And Projects — Mega Compilation
Complete Data Preprocessing and Data Visualization with Projects — Mega Compilation Part 2
Maths —
Statistics for Data Science and Machine Learning with Code Implementation
Maths for Data Science and Machine learning
In this post we covered Maths for ML . Topics like Linear Algebra, Calculus, Matrix and Vectors, Bayes Theorem and Cheatsheets etc are covered in detail.
For other projects, tune to —
Build Machine Learning Pipelines( With Code)
Recurrent Neural Network with Keras
Custom Layers in Keras
Follow for more updates, stay tuned and of-course let me end this post with a quote by Steve Jobs ;)
“Your time is limited, so don’t waste it living someone else’s life.”





