Database Fundamentals in 9 Minutes (Disk, Pages, Indexing)
Shubh Patel
0:00 / 0:00
Database Fundamentals in 9 Minutes (Disk, Pages, Indexing)
2 089 просмотров · 5 месяцев назад
Shubh Patel
10,7 тыс. подписчиков
2 089 просмотров · 5 месяцев назад
Ever wondered why databases store data on disk instead of memory, even though memory is much faster? 🤔
Or why some queries take forever while others are lightning fast?
In this video, we break down *database fundamentals* in a simple and intuitive way:
📌 Why databases use disk instead of RAM
📌 How data is stored internally using pages
📌 Why queries become slow (full table scans explained)
📌 How indexing dramatically improves performance
If you're a developer, student, or preparing for system design interviews, this video will give you a solid foundation of how databases actually work under the hood.
🚀 By the end, you'll understand:
Why your queries are slow
How databases retrieve data
How to optimize performance using indexing
👍 Don’t forget to like, share, and subscribe for more deep dives into system design and backend engineering!
⏱️ Timestamps:
00:22 — Where data is stored?
02:08 — How data is stored?
05:17 — Why data retrieval is slow?
07:31 — Why index?
#Database #SystemDesign #Indexing #BackendDevelopment #SQL #Programming