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

Подписаться 131 тыс.

Просмотров 41 тыс.

50% 1

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

Опубликовано:

14 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 101

@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

@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

@kunalsevkani1601 7 месяцев назад

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?

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

@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

@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

@VikasBagri-t2y 12 дней назад

thanks for this amazing tutorial

@aadityapanchal8551 6 месяцев назад

great Explanation

@shubhamagarwal1434 12 дней назад

Very well explained...awsome!!!

@asktostranger8296 Год назад

Bus bahya podh do Details course bana ke 😍💘

@ConceptandCoding Год назад

Thank you 🙏

@suheabkhan2546 Год назад

Next video should be indepth details of caching

@ConceptandCoding Год назад

Noted :)

@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 7 месяцев назад

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

@arishtajain8372 4 месяца назад

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

@tarunkundhiya5196 Год назад

Great video !! Awesome explanation without any confusion!

@ConceptandCoding Год назад

Thank you

@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 🙏🙂

@rhythmjayee9707 Год назад

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

@ConceptandCoding Год назад

Thanks

@Peaceinhills 5 месяцев назад

Brother go for computer science 6 sem syllabus you will find everything on RU-vid

@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

@deepakphul7585 Месяц назад

Happy Teachers day, Shreeyansh

@suryakantsoni8809 Год назад

Lovely content Shreyansh, keep up the good work.

@ConceptandCoding Год назад

Thank you

@arabazsoudagar4566 2 месяца назад

Bro membership hata do na

@VibewithRax Год назад

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

@beyondtheordinary3160 5 месяцев назад

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 3 месяца назад

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

@shubhamarora7966 9 месяцев назад

Thank you so much for great content.

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

@LavikshaSoni Год назад

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

@ConceptandCoding Год назад

Noted

@suheabkhan2546 Год назад

Great video !!

@ConceptandCoding Год назад

Thank you

@SatyamKumar-bw4vi 10 месяцев назад

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

@ConceptandCoding 10 месяцев назад

Hare Krishna, thanks a lot 🙏

@pramodkrverma8092 Год назад

Thank you🥰

@ConceptandCoding Год назад

You’re welcome 😊

@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 7 месяцев назад

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

@ConceptandCoding 7 месяцев назад

interview questions solution, is available for members only buddy

@ThePomelo09 Год назад

awesome ty!

@ConceptandCoding Год назад

Thanks 😊

@harshalgarg9656 10 месяцев назад

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

@ConceptandCoding 10 месяцев назад

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

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

@arishtajain8372 4 месяца назад

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.

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

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

@hariommewada3768 9 месяцев назад

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

@amitbansal7754 4 месяца назад

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.