LLD Most asked interview questions
Day Topic Question List // Asked In
Resource
1. Revision of LLD
Introduction to LLD | HLD vs LLD | https://vimeo.com/
Objection-Oriented Programming | UML 801558774/7c96c
Diagram 8a89e
Design Pattern VS Design Principles | SOLID https://vimeo.com/
(S.O.L.) 801559721/896ea
108cb
SOLID (I.D.) + DRY + KISS https://vimeo.com/
801559553/43b40
911a9
Design Patterns Type | Creational Design https://vimeo.com/
Patterns 801559126/0cff3a
c099
Structural & Behavioral Design https://vimeo.com/
811169733/c47bd0
9bb3
For DB Management
ER Diagram | SQL Queries | Transactions
Intro to DBMS & ER Model https://vimeo.com/
857773373/c340a
458b9?share=cop
y
Relational Model & Functional https://vimeo.com/
Dependency 857773264/64690
6d0c1?share=copy
Normalisation https://vimeo.com/
857777673/61057
4ae58?share=cop
y
SQL 1 https://vimeo.com/
857775294/fb69be
9c9b?share=copy
SQL 2 https://vimeo.com/
858535181/0355d
1ce20?share=copy
SQL 3 https://vimeo.com/
861138187/1066f7
17ab?share=copy
Transaction management + concurrency https://vimeo.com/
control 861137995/2dee9
3090d?share=cop
y
Indexing: B & B+ Tree https://vimeo.com/
862295499/58fcb2
ea91?share=copy
For API Design
Basics of API - Rest API, GraphQL, gRPC https://www.youtube.c
om/watch?v=mdB8m
9tCv5k&list=PLw41H
P7SUoAW9fWEl3NS
X25HoVLg5AFL5&in
dex=1
Input format, Output format https://www.youtube.c
om/watch?v=mdB8m
9tCv5k&list=PLw41H
P7SUoAW9fWEl3NS
X25HoVLg5AFL5&in
dex=1
Defining APIs, Arguments, return type https://www.youtube.c
om/watch?v=mdB8m
9tCv5k&list=PLw41H
P7SUoAW9fWEl3NS
X25HoVLg5AFL5&in
dex=1
Day Topic Question List // Asked In
Resource
2. 3 Types of LLD Questions:
#1) Design Class Diagram (This is mostly
asked in interviews)
Parking Lot Design https://vimeo.com/
848417132/2fd3e4
4e4b
ATM Design https://vimeo.com/
795500506/2c4c0
5f798
#2) Define DB Diagram (ER Diagram, SQL
Queries Writing)
#3) API Design
Design FIle System Design File Ser…
Day Topic Question List // Asked In
Resource
3. [Class Diagram + API Design] Design a coupon https://leetcode.com/d Amazon
and voucher managment iscuss/interview-quest
ion/1003648/Low-Lev
el-Design-Question-(
Amazon)
Design a Webcrawler which can crawl https://leetcode.co DataBricks
upto depth h m/discuss/intervie
w-question/175949
7/Low-level-design
-SDE3-Databricks
Design a Messenger (DB Management) https://leetcode.co LinkedIn
m/discuss/intervie
w-question/177202
0/LinkedIn-or-Phon
e-or-System-Desig
n-Messenger
Day Topic Question List // Asked In
Resource
4. [Class Diagram] Design Cricket Match https://leetcode.co Udaan
Dashboard m/discuss/intervie
w-question/99022
7/udaan-assignme
nt-cricket-match-d
ashboard
[Class Diagram + API Design] Event https://github.com/ Flipkart
Calendar kumaransg/LLD/bl
ob/main/Event_cal
endar_flipkart/Eve
nt%20Calendar.pd
f
Instagram Home Feed https://leetcode.co InterviewVecto
m/discuss/intervie r + Amazon
w-question/22007
60/Low-level-desig
n-(lld)
Day Topic Question List // Asked In
Resource
5. Stock Trading https://leetcode.co Goldman
m/discuss/intervie Sachs
w-question/40905
63/Low-Level-Desi
gn-or-Stocks-Tradi
ng
Shopping Cart Service https://leetcode.com/ Amazon
discuss/interview-qu
estion/2594594/Ama
zon-Low-Level-Desig
n-roundor-Bangalore
Splitwise https://leetcode.com/ Microsoft
discuss/study-guide/
2154270/Low-Level-
Design-of-Splitwise
Day Topic Question List // Asked In
Resource
6. Design Meeting Scheduler https://leetcode.com/di Amazon
scuss/interview-questi
on/490962/Design-Me
eting-Scheduler
TinyUrl https://leetcode.com/ Flipkart
discuss/interview-qu
estion/4047665/2023-
or-Flipkart-R1-or-Lo
w-Level-Design-or-L
LD-or-Rejected
Food ordering System https://docs.google.co Flipkart
m/document/d/1Bmkz
9omByHqVvwU45cvk
BRSwJAPKw9yaDsRl
EnCg_lg/edit#heading
=h.g4ms7p50hwuz
Day Topic Question List / Asked
Resource In
7. Stock Exchange https://github.com/ku Navi
maransg/LLD/tree/mai
n/StockExchange
Leetcode Platform Flipkart
Blog Platform DB Design Microsoft
