Database Design Tips | Choosing the Best Database in a System Design Interview

One of the most important things in a System Design interview is to choose the right Database for the right use case. Here is a cheat sheet that can help you choose the right DB for most of the use cases that you can encounter.  

Summary of the video: https://www.codekarle.com/system-desi...

Author: LinkedIn: sandeep1904

We do over some important topics like which database you should use, in what scenarios, in a System Design Interview. Some comparisons between SQL and NoSQL databases, how to use multiple databases together in a real-world system, etc.

Chapters

0:00 - Intro
1:05 - Things that matter
1:45 - Caching
3:20 - File storage
4:22 - CDN
5:11 - Text search engine
6:30 - Fuzzy text search
8:25 - Timeseries databases
10:11 - Data warehouse / Big Data
11:17 - SQL vs NoSQL
11:24 - Relational DB
14:28 - NoSQL - Document DB
16:28 - NoSQL - Columnar DB
18:23 - If none of these are required
19:03 - Combination of DBs - Amazon case study.

#codekarle #databases #systemdesign #system #design #interview #amazon #faang

• #education
• #system_design
• #system_architecture
• #interview
• #codekarle
• #code_karle
• #system
• #architecture
• #design
• #database
• #sql
• #nosql
• #elastic_search
• #solr
• #cassandra
• #mysql
• #mongodb
• #system_design_tutorial
• #tutorial
• #system_design_interview_question
• #grokking
• #faang
• #interview_questions
• #software_engineer
• #software
• #db