Hi Shreyansh, Thanks for this video! it would have even more helpfull if u would have taken some system design examples and mentioned which one can be used with what in the end.
But Now NoSQL databases like mongoDB have caught up so well with complex queries in form of aggregation pipelines and schema validated collection to ensure structure. Do you think we need to revisit our understanding before the interview?
As per my understanding, Column wise mostly efficient when there are more read than write one reason for this is their have fixed format. While Document structure is very complex compared to column, I mean we can have documents within documents like that, so efficient read is not that great here.
The main difference is that if you want to achieve acid property go for sql else go for no sql. Interviewer will try to confuse you regarding replication and distribution it can be also achieved in sql. No sql is also preferable to storing huge data
you mention sql is preferably vertically scalable and not horizontal. Since scaling vertically has a limit, how does then bank and other security db handle enormous users?
They use distributed databases to scale, for eg. Cassandra, Yugabyte DB, which are specially designed to handle scalability. Distributed databases abstract the entire process of sharding, but internally the data is spread across multiple nodes (known as a cluster).
Hi Shreyansh, Following your content for sometime, and have to admit that you're addressing all the topics which are highly probable in an interview in a very structured format. It's also really great to see how you're balancing this with your office work. Keep up the good work, and I wish you good health 👍
quality is top notch but just one feedback from my side (as a engineer we are owl who do not sleeps at night and do all learnings at night ) this whiteboard gives a litte bit stress to the eyes beacuse i am following your lld playlist and watching uour videos for atleast 1 hr daily so please can you make future videos with greyish background it will be more effective
It would have been great if you could take some examples like a case study to explain your point regarding flexible query...a system where flexible query will be required and a system where it won't be required similarly for 2nd point of relational and non relational data.
Got it Aditya. Let me add this in my list, I will try to take one love session like I take for LLD and try to clarify this. But I hope this video has given some useful info? Hope
@@PradeepKumarIIITD I have no problem in him selling his courses. He is devoting his time and putting in effort so he should get money for this. But the point stands that he was marketing the course as free and now making it as paid for the essential videos required to understand system design. He could've simply created a v2 with better or more content and marked it completely as paid rather than making most of the videos of the current course for members only.
It is not entirely correct to say that SQL databases cannot be used when high availability and high performance are required. Distributed databases like Cassandra, Google Spanner are designed to scale SQL databases and offer high availability by replication, redundancy, and failover mechanisms. The most important determinant is the kind of data to be stored, and the relationship between the data. Modern day software solutions offer scalability options for both SQL and noSQL databases.
Few videos are showing locked, why? How will I complete the playlist then? for eg, key value store video is locked. Is there any membership to access it? If not please make it accessible to everyone.
bro, can you please continue the lld (suggestion), you made best content for lld in youtube, for hld there are many resources ( hld content is also good).
Hey Shreyansh, What kind of DB will be best for saving a 2D array in databse? and how to save the array to effective retrieval. I'm looking for solution to store data for a board game like mindsweeper
Hi Shreyansh, The video content is great. Thank you very very much. Do we by any chance have short notes for the videos so that we can go through quickly once again when required.
Optimistic and Pessimistic locking applicable for NoSql too. I have covered Concurrency Control in the later part of this HLD playlist, do check out. But i have covered specifically from MYSQL perceptive, but same Locking techinque applicable for NoSQL with minor change. i will cover in separate video
In sql nature , you mentioned that if you have 10 column then all of them will be present on the same server , what if we do vertical Sharding , in that case 5 column is present on one server and rest 5 will be on another right ?. correct me if I am wrong
@@ConceptandCoding I think there is a little confusion here . Sharding is an implementation of Horizontal scaling and this can be Horizontal Sharding or vertical Sharding . correct me if I am wrong.
Hi Shreyansh,
Thanks for this video!
it would have even more helpfull if u would have taken some system design examples and mentioned which one can be used with what in the end.
Yes, let me see if any one love session I can take and there we can discuss on this topic. Let me add this in my list. Thanks for the input
@@ConceptandCoding Thanks for the consideration.
@@ConceptandCoding any update on this?
But Now NoSQL databases like mongoDB have caught up so well with complex queries in form of aggregation pipelines and schema validated collection to ensure structure. Do you think we need to revisit our understanding before the interview?
Next video should be indepth details of caching
Noted :)
Bus bahya podh do
Details course bana ke 😍💘
Thank you 🙏
Great work Shrayansh.Keep Posting such an Informational videos like these 😍😍🤩🤩🥰🥰
Thank you, pls do share it with your connections 🙏🙂
Great video !! Awesome explanation without any confusion!
Thank you
Please create notification system design (like facebook events) if possible
Noted
What is difference between document and column wise db? as column , value is same as key value
As per my understanding, Column wise mostly efficient when there are more read than write one reason for this is their have fixed format.
While Document structure is very complex compared to column, I mean we can have documents within documents like that, so efficient read is not that great here.
Thanks. But then if column wise has fixed structure then is it like sql which can be shareded and with base property instead of acid?
sir can i access member only content by choosing join for appreciation option...ie 59 rupees?
with 159Rs one JAVA playlist will get open and Rs199 everything LLD, HLD and JAVA get open.
The main difference is that if you want to achieve acid property go for sql else go for no sql. Interviewer will try to confuse you regarding replication and distribution it can be also achieved in sql. No sql is also preferable to storing huge data
Yes
you mention sql is preferably vertically scalable and not horizontal.
Since scaling vertically has a limit, how does then bank and other security db handle enormous users?
Any update on this?
May be they use Sharding to handle such huge data
They logically && physically shard the data to multiple clusters and each cluster has multiple nodes, that is how they scale
They use distributed databases to scale, for eg. Cassandra, Yugabyte DB, which are specially designed to handle scalability. Distributed databases abstract the entire process of sharding, but internally the data is spread across multiple nodes (known as a cluster).
Hi Shreyansh,
Following your content for sometime, and have to admit that you're addressing all the topics which are highly probable in an interview in a very structured format. It's also really great to see how you're balancing this with your office work. Keep up the good work, and I wish you good health 👍
Thanks a lot
Dude why have you made these important videos in the series private. Can you please make them accessibile to everyone. Thanks
quality is top notch but just one feedback from my side (as a engineer we are owl who do not sleeps at night and do all learnings at night ) this whiteboard gives a litte bit stress to the eyes beacuse i am following your lld playlist and watching uour videos for atleast 1 hr daily so please can you make future videos with greyish background it will be more effective
That's a very good and genuine feedback Shubham. Let me do that from next time
It would have been great if you could take some examples like a case study to explain your point regarding flexible query...a system where flexible query will be required and a system where it won't be required similarly for 2nd point of relational and non relational data.
Got it Aditya. Let me add this in my list, I will try to take one love session like I take for LLD and try to clarify this.
But I hope this video has given some useful info? Hope
Yes it has added value definitely thanks for video and for the response too☺️
@@ConceptandCoding Hi Shrayansh any update on the additional session ?
@@TechkyDroidRIK i need to plan for it. Thank you for the reminder. I will update.
@@ConceptandCoding Thanks a lot. :)
hey shreyansh you have done marketiing by telling that your vedios are free. but you have made most important vedios private.
True bhai. Sabko paisa chahiye.
bhai 20k ka course 199 m mil rha h karlo and padhlo and aage badho thank him later.
@@amitbansal7754 netflix ko nhi bola bhai apne ye..
@@PradeepKumarIIITD I have no problem in him selling his courses. He is devoting his time and putting in effort so he should get money for this. But the point stands that he was marketing the course as free and now making it as paid for the essential videos required to understand system design.
He could've simply created a v2 with better or more content and marked it completely as paid rather than making most of the videos of the current course for members only.
Thanks for all your videos in HLD, they are really good. I will really appreciate if you can share these scribed notes that you use for explaining.
Noted
15:29 Previous video is only for members only , thats very sad.
You can turn sadness to happiness just by paying 200Rs for a month.
It is not entirely correct to say that SQL databases cannot be used when high availability and high performance are required. Distributed databases like Cassandra, Google Spanner are designed to scale SQL databases and offer high availability by replication, redundancy, and failover mechanisms.
The most important determinant is the kind of data to be stored, and the relationship between the data.
Modern day software solutions offer scalability options for both SQL and noSQL databases.
Happy Teachers day, Shreeyansh
Few videos are showing locked, why? How will I complete the playlist then?
for eg, key value store video is locked.
Is there any membership to access it? If not please make it accessible to everyone.
Yes some are member only videos buddy.
NoSQl supports advanced custom queries as well,eg via N1QL queries in couchbase/mongodb
bro, can you please continue the lld (suggestion), you made best content for lld in youtube, for hld there are many resources ( hld content is also good).
Hi Charan, sure, I have to switch between HLD and LLD, as need to cover both.
Hey Shreyansh, What kind of DB will be best for saving a 2D array in databse? and how to save the array to effective retrieval.
I'm looking for solution to store data for a board game like mindsweeper
Use sql with two columns as x and y and ... and x,y should be indexed as you are going to query most of the time based on their values
@Concept && Coding i payed for membership two days back. still iam unable to access members-only videos
To access the playlist you need "unlock LLD, HLD and Java" membership access buddy
Thanks for the video really nice explaination
Thank you
Hare Krishna Bhaiya..! I will make a post on LinkedIn & tag you there. Amazing content..!!!!
Hare Krishna, thanks a lot 🙏
Hi Shreyansh,
The video content is great. Thank you very very much.
Do we by any chance have short notes for the videos so that we can go through quickly once again when required.
I haven't saved it buddy sorry
First view :)
Hope you find the content useful
@@ConceptandCoding Yes, sure i did!
Great video !!
Thank you
TBH I did not find any video on YT this detailed.
Thanks🙇♂
Thanks
Brother go for computer science 6 sem syllabus you will find everything on RUclips
great Explanation
bhaiji how to handle concurrency in Nosql? Say to update request to a document at same time
Optimistic and Pessimistic locking applicable for NoSql too. I have covered Concurrency Control in the later part of this HLD playlist, do check out.
But i have covered specifically from MYSQL perceptive, but same Locking techinque applicable for NoSQL with minor change. i will cover in separate video
Lovely content Shreyansh, keep up the good work.
Thank you
Bro membership hata do na
Nice, but why the key value store video is members only?
interview questions solution, is available for members only buddy
Hi Shreyansh can you please help me get referral in PayPal.
kyun tu uksa rishtedar lgta hai, jhaatu ?
In sql nature , you mentioned that if you have 10 column then all of them will be present on the same server , what if we do vertical Sharding , in that case 5 column is present on one server and rest 5 will be on another right ?. correct me if I am wrong
Vertical Sharding means increasing more spaces.
Do you mean horizontal Sharding?
@@ConceptandCoding I think there is a little confusion here . Sharding is an implementation of Horizontal
scaling and this can be Horizontal
Sharding or vertical Sharding . correct me if I am wrong.
@@ConceptandCoding I think vertical scaling is increasing more spaces right ?
Thank you🥰
You’re welcome 😊
awesome ty!
Thanks 😊
👍👍
Thank you so much for great content.
Nice video, I want to participate in Tata Steel TomorrowLab challenge, can u please make a video on that. I heard they are giving good prizes.
i love u nature preet singh ....