Full Courses [In Depth] - [Final Part] DBMS in one go for Interviews & Placements

DBMS in one go for Interviews & Placements ------------------------------ This video is the final part of our DBMS series, first part you can refer in Full courses playlist or from this link:- https://www.youtube.com/watch?v=MxHWTtcLssA ------------------------------ In this video we will cover some intermediate to advanced topics (refer timeline):- - Instagram ER design and normalisation - Solving sql questions on leetcode live - going through btrees and b+ trees with examples - indexing and hashing internals - write ahead logs, bin logs, replication - replication lag, master replica architecture - acid properties, consistency and eventual consistency - interview questions and much more ------------------------------ 🚀 Follow on X for industry updates:- https://x.com/SinghDevHub 🚀 For project updates, opportunities and announcements, Join our whatsapp community:- https://whatsapp.com/channel/0029VaHqDEr0VycGSQHdmh1S 🚀 Applied Operating Systems for Engineers & Interviews:- https://www.youtube.com/playlist?list=PL7CBVLpg0zqfIdcwDNa5c2xbhvK4crNqc 🚀 Backend Mastery (Java, Python, Microservices, AWS, System Design, Spring boot and much more):- https://www.youtube.com/playlist?list=PL7CBVLpg0zqeJTCCuU99RW1TMn8_Ii15n ------------------------------ All notes compiled:- https://drive.google.com/file/d/1VyXc2OnQeLkxCUh4jerXzpB-LK7TMOvI/view?usp=sharing ------------------------------ timeline:- 00:00:00-00:01:40 Index 00:01:41-00:24:21 Let's design instagram 00:24:22-00:44:00 Normalization (1NF,2NF,3NF,BCNF,4NF,5NF) 00:44:01-00:53:30 Normalization on Instagram design 00:53:31-01:33:28 Solving SQL questions 01:33:29-01:58:00 Indexing (ordered, clustering, non-clustering index, primary secondary and more) 01:58:01-02:11:00 B+Trees, BTrees (examples, questions) 02:11:01-02:18:00 Hashing (closed, dynamic hashing) 02:18:01-02:23:00 ACID properties with examples 02:23:01-02:29:00 RDBMS vs NoSQL (eventual consistency, sharding) 02:29:01-02:33:35 Master Replica (async vs sync replication, replica lag, Bin logs) #dbms #interviews #placements