Systems Design : Correct Database for an Application | Database to choose while designing a System

#SystemDesign
Software Systems design interview preparation for cracking the coding job interview includes knowledge of software design patterns. System design interview questions target on object oriented programming language test and algorithms.
This System design video will deal with the database you should choose while designing an application.
Each application has different requirement and you should choose the database as per the requirement that you have.
In this video I have explained, what kind of database will solve which kind of problem.
In a system design round of interview in big tech like google, facebook, microsoft and amazon, it is important that you discuss these problems and the come up with the correct database which justifies the solution to the problem.
Video covers the relation that CAP theorem will have and which databases will be applicable for CA, CP and AP cases as per CAP theorem
Video will also talk about sql vs nosql,
RDBMS,NOSQL and various category of NOSQL like document based database, columnar based database, key value paired database, graph database.
BTW elastic search database is document oriented database

[TheTechGranth]

Watch at 1.25x or 1.5x as per convenience

[shazaalyyy]

Very well concise and clear explanation, thank you

[PraneethV-yzkx]

Hi, Great video. Can you also make a video on how to do data modelling? In an interview, I was asked to write/draw data modelling for a scenaro and I'm not sure how to proceed.

[aakash]

Thanks for the video
In a nutshell :
if data is structured -> go for SQL database
if data is unstructured -> look at the problem and the use case and tell the interviewer that I want a kind of database that supports AP or CP right?

[art-has-love]

so helpful! Thank you for the video :)