How do Databases Work? | System Design

Visit Our Website: https://interviewpen.com/?utm_campaig...
Join Our Discord (24/7 help):   / discord  
Like & Subscribe:    / @interviewpen  

This video goes over how databases work internally--specifically how they parse and execute SQL queries in the most efficient way possible.

If you liked this video and want to learn more about fundamental systems and how they can be used to solve problems, check out our full course on https://interviewpen.com/?utm_campaig... !

Table of Contents:
0:00 - Introduction
0:09 - What is a Database
0:37 - Declarative vs Imperative
2:10 - Query Execution Process
2:48 - Parser
3:37 - Query Planner
4:09 - Examples of Query Plans
8:04 - Query Planner Overview
8:37 - Query Execution
8:48 - Conclusion

Socials:
Twitter:   / interviewpen  
LinkedIn:   / interviewpen  
Website: https://interviewpen.com/?utm_campaig...