10. SQL vs NoSQL | Difference between SQL & NoSQL | SQL Vs NoSQL Tutorial | SQL, NoSQL system design

[@lakshyasharma9914]

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 👍

[@ConceptandCoding]

Thanks a lot

[@TheRoamingCompassOfficial]

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

[@ConceptandCoding]

Yes

[@kunalsevkani1601]

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?

[@dhruvkaran9724]

bro u just nailed , wish you healthy life bro

[@aadityapanchal8551]

great Explanation

[@shubamgoswami]

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

[@ConceptandCoding]

That's a very good and genuine feedback Shubham. Let me do that from next time

[@priyadarshinir9730]

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.

[@ConceptandCoding]

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

[@priyadarshinir9730]

@@ConceptandCoding Thanks for the consideration.

[@sayanroy9161]

@@ConceptandCoding any update on this?

[@adityagupta375]

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.

[@ConceptandCoding]

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

[@adityagupta375]

Yes it has added value definitely thanks for video and for the response too☺️

[@TechkyDroidRIK]

@@ConceptandCoding Hi Shrayansh any update on the additional session ?

[@ConceptandCoding]

@@TechkyDroidRIK i need to plan for it. Thank you for the reminder. I will update.

[@TechkyDroidRIK]

@@ConceptandCoding Thanks a lot. :)

[@asktostranger8296]

Bus bahya podh do Details course bana ke 😍💘

[@ConceptandCoding]

Thank you 🙏

[@deepakphul7585]

Happy Teachers day, Shreeyansh

[@suheabkhan2546]

Next video should be indepth details of caching

[@ConceptandCoding]

Noted :)

[@VikasBagri-t2y]

thanks for this amazing tutorial

[@tarunkundhiya5196]

Great video !! Awesome explanation without any confusion!

[@ConceptandCoding]

Thank you

[@rhythmjayee9707]

TBH I did not find any video on YT this detailed. Thanks🙇‍♂

[@ConceptandCoding]

Thanks

[@Peaceinhills]

Brother go for computer science 6 sem syllabus you will find everything on KZbin

[@sahilseewal5509]

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.

[@ConceptandCoding]

Noted

[@motivation_hubPJ]

Thanks for the video really nice explaination

[@ConceptandCoding]

Thank you

[@praveenkrdas72]

Great work Shrayansh.Keep Posting such an Informational videos like these 😍😍🤩🤩🥰🥰

[@ConceptandCoding]

Thank you, pls do share it with your connections 🙏🙂

[@shubhamagarwal1434]

Very well explained...awsome!!!

[@SatyamKumar-bw4vi]

Hare Krishna Bhaiya..! I will make a post on LinkedIn & tag you there. Amazing content..!!!!

[@ConceptandCoding]

Hare Krishna, thanks a lot 🙏

[@suryakantsoni8809]

Lovely content Shreyansh, keep up the good work.

[@ConceptandCoding]

Thank you

[@arabazsoudagar4566]

Bro membership hata do na

[@suheabkhan2546]

Great video !!

[@ConceptandCoding]

Thank you

[@shubhamarora7966]

Thank you so much for great content.

[@piyushmathpal4244]

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?

[@piyushmathpal4244]

Any update on this?

[@aloksahoo7852]

May be they use Sharding to handle such huge data

[@arpitsangotra3322]

They logically && physically shard the data to multiple clusters and each cluster has multiple nodes, that is how they scale

[@arishtajain8372]

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).

[@pramodkrverma8092]

Thank you🥰

[@ConceptandCoding]

You’re welcome 😊

[@charan7240]

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).

[@ConceptandCoding]

Hi Charan, sure, I have to switch between HLD and LLD, as need to cover both.

[@ThePomelo09]

awesome ty!

[@ConceptandCoding]

Thanks 😊

[@Watcher46]

Content is good but since the previous video requires membership it is difficult to understand and follow

[@LavikshaSoni]

Please create notification system design (like facebook events) if possible

[@ConceptandCoding]

Noted

[@hariommewada3768]

hey shreyansh you have done marketiing by telling that your vedios are free. but you have made most important vedios private.

[@amitbansal7754]

True bhai. Sabko paisa chahiye.

[@PradeepKumarIIITD]

bhai 20k ka course 199 m mil rha h karlo and padhlo and aage badho thank him later.

[@PradeepKumarIIITD]

@@amitbansal7754 netflix ko nhi bola bhai apne ye..

[@amitbansal7754]

@@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.

[@AnkitaMishra-e1i]

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.

[@ConceptandCoding]

I haven't saved it buddy sorry

[@arishtajain8372]

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.

[@VibewithRax]

NoSQl supports advanced custom queries as well,eg via N1QL queries in couchbase/mongodb

[@yaseenmohammad1928]

If anyone has notes of this playlist, please post the link in comments that would be truly helpful. Thanks in advance!

[@beyondtheordinary3160]

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

[@abhijeetkarmakar7792]

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

[@princeraheja8737]

15:29 Previous video is only for members only , thats very sad.

[@VIJAYMAMORIA-c8m]

You can turn sadness to happiness just by paying 200Rs for a month.

[@harshalgarg9656]

What is difference between document and column wise db? as column , value is same as key value

[@ConceptandCoding]

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.

[@harshalgarg9656]

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?

[@anupampandey3758]

Nice, but why the key value store video is members only?

[@ConceptandCoding]

interview questions solution, is available for members only buddy

[@Prashantkumar-pn6qq]

First view :)

[@ConceptandCoding]

Hope you find the content useful

[@Prashantkumar-pn6qq]

@@ConceptandCoding Yes, sure i did!

[@harishaseri]

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]

Vertical Sharding means increasing more spaces. Do you mean horizontal Sharding?

[@harishaseri]

​@@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.

[@harishaseri]

@@ConceptandCoding I think vertical scaling is increasing more spaces right ?

[@harshalgarg9656]

bhaiji how to handle concurrency in Nosql? Say to update request to a document at same time

[@ConceptandCoding]

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

[@mridul1075]

sir can i access member only content by choosing join for appreciation option...ie 59 rupees?

[@ConceptandCoding]

with 159Rs one JAVA playlist will get open and Rs199 everything LLD, HLD and JAVA get open.

[@happygamerroe8072]

Dude why have you made these important videos in the series private. Can you please make them accessibile to everyone. Thanks

[@BeyondTheFamiliar_2023]

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.

[@ConceptandCoding]

Yes some are member only videos buddy.

[@niharikavallambatla8301]

@Concept && Coding i payed for membership two days back. still iam unable to access members-only videos

[@ConceptandCoding]

To access the playlist you need "unlock LLD, HLD and Java" membership access buddy

[@harshitagarwal2682]

👍👍

[@tp_pm]

Its soft state, not safe state...

[@tanvighildiyal8068]

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.

[@Traveler99]

Hi Shreyansh can you please help me get referral in PayPal.

[@HA-ky5vd]

kyun tu uksa rishtedar lgta hai, jhaatu ?

[@mrprime557]

i love u nature preet singh ....