important topics:
Why do we need DBMS https://www.youtube.com/watch?v=T7AxM7Vqvaw
File management system vs DBMS https://www.youtube.com/watch?v=ZtVw2iuFI2w
Data abstraction https://www.youtube.com/watch?v=5fs1ldO6B5c
ER model, relational model https://www.youtube.com/watch?v=VJUk-_CsqKw
https://www.youtube.com/watch?v=UWNOchMUh8U
SQL and important keywords used Already done
SQL queries Already done
Joins and its types Already done
Views https://www.youtube.com/watch?v=8jU8SrAPn9c
Indexing https://www.youtube.com/watch?v=fsG1XaZEa78
sanchit jain
Normalization basic definitions and usage Sanchit jain
Transactions (Lock based protocol for concurrency control)
ACID properties
https://www.youtube.com/watch?v=75T6muWuEFI&list=PLbKVlnc3OmnwG-2-EeoheUZxBHwJh
RaZ-
SQL vs NoSQL https://www.youtube.com/watch?v=ZS_kXvOeQ5Y
Deadlock in DBMS
Starvation
https://youtu.be/Y80mas3B62M?list=RDCMUC-x_kRNcI1102UR5SmXOrpg
https://www.youtube.com/watch?v=loe4ERAI_3o
Questions on what database to be used
Scaling in databases
Cache and in-memory database
Also, practice standard interview questions from:
Most Standard topics : SQL queries, Normalization, transactions
[https://prepinsta.com/database-management-system-dbms/ ]Revision:
https://www.geeksforgeeks.org/last-minute-notes-dbms/
Interview questions:
https://www.geeksforgeeks.org/commonly-asked-dbms-interview-questions/
https://www.geeksforgeeks.org/commonly-asked-dbms-interview-questions-set-2/
DonneMartin book:
https://github.com/donnemartin/system-design-primer#database