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

SQL vs NoSQL | Difference between SQL vs NoSQL | SQL Vs NoSQL Tutorial | SQL vs NoSQL system design
Today i am covering very important System Design Interview question, which is
SQL vs NoSQL, it has been asked in many big product based companies HLD round like Amazon, Google, Facebook, Microsoft etc.
SQL databases
SQL (structured query language) databases are essentially relational databases, meaning that data is organized in terms of their relationships with other data.
NoSQL databases
NoSQL (not only SQL) databases, on the other hand, are non-relational. There are several types of NoSQL databases, such as column-oriented, graph-based, document-oriented, and key-value store databases
I have also discussed, which DB to choose and what criteria we need to see before choosing the particular type of DB.
You will also get to know about Advantage and Disadvantage of SQL and NoSQL both.
Join this channel to get access to perks:
/ @conceptandcoding
#systemdesign #interviewpreparation #interviewquestions
#SQL #nosql

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

[@aadityapanchal8551]

great Explanation

[@belalahmedkhan4619]

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

[@shubhamarora7966]

Thank you so much for great content.

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

[@tarunkundhiya5196]

Great video !! Awesome explanation without any confusion!

[@ConceptandCoding]

Thank you

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

[@harshitagarwal2682]

👍👍

[@praveenkrdas72]

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

[@ConceptandCoding]

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

[@suryakantsoni8809]

Lovely content Shreyansh, keep up the good work.

[@ConceptandCoding]

Thank you

[@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?

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

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

[@ThePomelo09]

awesome ty!

[@ConceptandCoding]

Thanks 😊

[@motivation_hubPJ]

Thanks for the video really nice explaination

[@ConceptandCoding]

Thank you

[@asktostranger8296]

Bus bahya podh do Details course bana ke 😍💘

[@ConceptandCoding]

Thank you 🙏

[@suheabkhan2546]

Great video !!

[@ConceptandCoding]

Thank you

[@suheabkhan2546]

Next video should be indepth details of caching

[@ConceptandCoding]

Noted :)

[@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. :)

[@VibewithRax]

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

[@pramodkrverma8092]

Thank you🥰

[@ConceptandCoding]

You’re welcome 😊

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

[@SatyamKumar-bw4vi]

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

[@ConceptandCoding]

Hare Krishna, thanks a lot 🙏

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

[@user-zi1bn3kc2p]

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

[@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?

[@LavikshaSoni]

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

[@ConceptandCoding]

Noted

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

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

[@Prashantkumar-pn6qq]

First view :)

[@ConceptandCoding]

Hope you find the content useful

[@Prashantkumar-pn6qq]

@@ConceptandCoding Yes, sure i did!

[@anupampandey3758]

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

[@ConceptandCoding]

interview questions solution, is available for members only buddy

[@princeraheja8737]

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

[@user-ph5ek8tg5l]

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

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

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

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

[@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?

[@Traveler99]

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

[@HA-ky5vd]

kyun tu uksa rishtedar lgta hai, jhaatu ?

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

[@mrprime557]

i love u nature preet singh ....