Day 1 of System Design Case Studies Series
Build large systems…
Welcome back peeps. After completing System Design series with examples, we are starting System Design Case Studies Series where the entire focus is on how to build large systems ( read case study questions below).
Note : Please read System Design Important Terms you MUST know before reading this post.
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!
Github -
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 :
Solved System Design Case Studies — In depth
Design Google Drive
Design Instagram
Design Quora
Design Foursquare
Design Flipkart
ML System Design
Design Tiny URL
Design Netflix
Design Messenger App
Design Twitter
Design Reddit
Design Amazon
Design Dropbox
Design URL Shortener
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
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
We will be covering —
- General System Design Case studies
- ML System Design Case studies
- Research papers based on these large systems ( follow Ignito for the Research Papers)
Pre-requisite :
Complete System Design Series —
6. Networking, How Browsers work, Content Network Delivery ( CDN)
Github —
What not to expect from this Series?
Please read the theory and examples from the pre-requisite given above as we will not be covering a lot of theory! You can dig the theoretical concepts as and when it’s required.
What are we going to cover?
We will be designing large systems and studying the research papers along with that will be brainstorming the pros and cons of each system design techniques. To make it more objective, I’ll try to make it as esoteric as possible with diagrams.
Case study questions will be ( ML System Design Questions will be shared later)—
- Design Dropbox or Google Drive
- Design subscription based sports website
- Design Netflix
- Design a Notification service
- Design Uber
- Design a news feed
- Design a product based on maps
- Design commenting system
- Design a ranking system.
- Design Amazon Cart system
- 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 Whatsapp
- Design Quora
- Design a Latency Management System
- Design a Library Management System
- Design Lookahead system
- Design Google Docs/ Collaborative Editing service
- Design URL Shortner service
- Design a Credit Card Authorization System
- Design a chat service
- Design a ride-sharing service
- Design a URL shortening service
- 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
- 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.
- 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
- 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
- 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 kind of kindle fire application
- 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
- 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
- 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.
- 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
- 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
- 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
- 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
- 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.
- 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.
That’s it for now!
Day 2 :
Subscribe/ Follow, Like/Clap and Stay Tuned!!
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 —
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
Exceptional Github Repos — Part 1
Exceptional Github Repos — Part 2
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 :
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
For Python Projects —
For complete 60 days of Data Science and ML : Day 1 — Day 60 : Quick Recap of 60 days of Data Science and ML
Follow for more updates. Stay tuned and keep coding! Disclosure: Some of the links are affiliates.
For other projects, tune to —
Build Machine Learning Pipelines( With Code)
Recurrent Neural Network with Keras
Clustering Geolocation Data in Python using DBSCAN and K-Means
Facial Expression Recognition using Keras
Hyperparameter Tuning with Keras Tuner
Custom Layers in Keras





