Google SWE teaches systems design | EP1: Database Design

Hope this was insightful! Feel free to give me any comments/concerns. Next video I'll do is SQL vs NoSQL and go through the pros and cons of the most popular options for distributed databases.

Recommended Reading:
Designing Data Intensive Applications, Chapter 3

Timestamps:
00:00 - Channel Intro
01:42 - Database Intro
06:03 - Hash Indexes
06:54 - SSTables + LSM Trees
12:30 - B-Trees

[sujayyaji]

I love this video for two reason
1. Dry humor
2. Dry humor, great content, loved the sarcasm and the knowledge. Thanks for putting this up

[hsmafro]

I love the dry humor and the knowledge, you got yourself a new sub

[ryanbannon]

Have watched a few of your videos, definitely subbed and going to work through them. I really appreciate the point you made that other videos don’t dive deep enough into the inner workings of a system. “For the backend we will use a MySQL database and a Redis cache…” and they stop there lol. This channel is just what a lot of people are looking for, please keep it up the videos are appreciated 👍

[prakharrai]

Chose this playlist over netflix and enjoying this so far!

[TheMazanec]

This channel is a goodmine, thanks for the amazing work!

[bazejmarciniak]

Wow, this is such a great summary of some chapters of the book you recommended at the end. Love your style of presenting, clear, concise, with a funny twist! Thanks for your work!

[benshapiro]

I wish I found your profile soooner, I would have LOVED to learn from your content during my dbms class last semester.... anyways, 5 minutes in and it is great so far, thank you for making this level of learning freely available. Godspeed and have a good day sir, keep up the good work

[ruchikasalwan]

This is a great resource! Learnt a ton! Btw I like the sound of your voice too! 🤩

[rodrigoalvesvieira]

Another great video. Appreciate the humor as well. Thank you for this content

[alexanderbalasky]

This is clutch af my guy. I was literally just thinking of starting a channel like this bc no content on youtube actually talks about how to build real world systems and its uber frustrating. Wild that the best stuff so far is someone who’s incoming/just joined. New engineer myself and system design is my jam. Keep up the great work and hope you’re enjoying google 😎

[jewishbag]

Excellent content! Learned a ton thanks for making this

[lloydlasrado]

Would you please do similar in depth videos for Algo and DS as well. Your teaching style is unique and world will benefit from it..

[aria]

I like your introduction and the attitude to dive deep!

[korean]

This is a truly epic video and I am glad I found your channel

[roywastaken]

I struck GOLD.
Thank you Jordan for having no life.

[jealr]

Great video! Will be watching the rest!

[hinata]

B- Tree is stored in disk but is usually kept in memory for faster access. In case the B- Tree is too big to fit in memory, we keep root and internal nodes in memory. So, write operations are performed in memory and persisted in data file which is similar to buffer flush in SSTables and LSM tree. In the video it is mentioned that we perform write operation on disk. Please correct me if I am wrong.

[sibasisbhattacharjee]

Thank you for these videos. Great work.

[prashlovessamosa]

Just started with your playlist great explanation

[firewater]

I just watched like 10 times, also took some notes.