Databases types: SQL, NoSQL, Column, Search, Key Value | System Design Tutorials | Part 6 | 2020

This is the sixth video in the series of System Design Primer Course. We talk about one of the most important components of System Design: Databases in a system. We want software engineers and aspiring software engineers to develop basics and get ready for the world of interviews as well as excelling as a Software Engineer.

Useful Links:
Chapter 3, Designing Data Intensive Applications by Martin Kleppman
Chapter 4, Designing Data Intensive Applications by Martin Kleppman

Quiz for this video.
Which data store you would use to store images for an image sharing system like Instagram? Try to answer or wait for a video on this ;)

------------------------------------------------------------------
Recommendations
------------------------------------------------------------------
Our full courses on youtube:

Some paid courses that we recommend:

------------------------------------------------------------------
About Us
------------------------------------------------------------------
Created and Instructed by:
Yogita Sharma

Post-production(editing, thumbnail etc) managed by:
CiKi

Colors and design by:
Naini Todi

Both Arpit and Yogita are software engineers and want to help other software engineers become better by providing high quality and well researched content by adding their creativity and teaching twist.

------------------------------------------------------------------
Join Us
------------------------------------------------------------------
Hangout with sudoCode:

For business:

[sudocode]

At 16:38, in the last point about non-relational DB towards the bottom right, read it as - "Different types of non relational DBs are used for different purposes". Thanks. Happy learning :)

[zahid]

In a video when she told.."these are your homework." Like a primary class student my hand was extended unconsciously to grab a piece paper to write the home-tasks on it.

Later, blissfully she retraced her order like a kind-hearted class-teacher who sometimes grants much loved breaks.

Bless you, madam. You have a good flair for teaching.

[pranjalgusain]

This video is GOLD! Save her at any cost.

[sky_kryst]

Hey, thank you so much for being our source of knowledge on SDE. For a self-taught dev like me it is extremely helpful and understandable source before getting into heavy books. One small requests, I'm lazying my way out of this, just watching the videos and grasping the concepts. I can already tell I wont be able to retain all the information. Do you mind making notes or ppt of your points? I don't mind paying for this course from Udemy or something if notes are available.

[mostinho]

Done Thanks for sharing your knowledge
Types of non relational db
Key value store
Document db
Column db
Search db

[wonderweebwoman]

I started this playlist today and I am finding this to be better than a lot of standard materials that were previously suggested to me. I'll surely recommend this channel when asked. Thanks for the quality content!

[luispalacios]

This can be the best explanation I have seen for the differences between different kinds of databases. Awesome video.

[lordbadass]

Consistency - State of the database before and after the transaction should be maintained.

This is different from the consistency in CAP theorem and it is not read consistency as you mentioned... Correct me if I'm wrong

[sandeep-kool]

Wow.. What a video... With lot of information and effective communication.. Thank you for sharing knowledge in youtube.. And the best part is you never asked for likes/shares..it will be informed decision from user.. All the best.. Keep doing like this, you ll be top youtuber..

[abhishekmehta]

Hi Mam, 1'st of all thank you very much for all this informative video that you are creating. Really really helpful. I am from NON IT Background and still i can understand all of this.

Regarding Quiz : We will use search database like S3 or Buckets Beacuse it helps in storing the Audio/Video data.

[sujeetbadnale]

God Has Blessed You Sister. Thank you for the videos especially for starting with absolute basics. It truly helps.😊

[ninonazgaidze]

Thanks so much! You are perfect! Everything was explained so simply and logically, just appreciated!

[simranthadani]

I'm eagerly waiting for the next parts in this series. I have an assignment submission this week and your videos are extremely helpful. Keep creating! I hope you can upload the remaining parts FAST though :3 Thank you

[SachinKumar-qvfj]

This series on system design I am hoping is going to be amazing and till now I found it amazing. Thanks for sharing your valuable content and knowledge with others, you are helping others to become a better Software Engineer. Can you please suggest a book on system design?

[rishabhmendiratta]

Hi Yogita thanks for the video, there is a minor review at 12:55 - 12:57 it should be heavy writes I think and not heavy reads while you speak. Just a suggestion 🙂

[rachanaramesh]

Clear and crisp explanation. Loved it!

[jessicacabrera]

You have saved my life! Very clear explanation! Thank you, teacher! :)

I'm from Brazil

[ankurbhanot]

ap padate bht strict teacher jaise ho but end me smile bdi cute si dedete ho .... but thanks for using realy crisp and concrete videos. may be one more point. Relational DB are for faster writes and OLTP and non releation are for faste reads and OLAP.

[jksharma]

In the beginning I was NOT sure But you delivered a well balance information. Thank you.

[shivanshvish]

Clean and crystal clear explaination, keep it up with this consistency.