System Design for SDE-2 and above: https://arpitbhayani.me/masterclass System Design for Beginners: https://arpitbhayani.me/sys-design Redis Internals: https://arpitbhayani.me/redis Build Your Own Redis / DNS / BitTorrent / SQLite - with CodeCrafters. Sign up and get 40% off - https://app.codecrafters.io/join?via=arpitbbhayani In this video, I delved into the essential concept of joins in databases, exploring the algorithms used for table joins. I explained the nested loop join, where each row from one table is matched with every row from the other. The merge join involves sorting tables on join attributes for efficient merging. Hash join uses hash functions to prepare and match rows based on the join attribute. SQL engines choose these algorithms based on table statistics. Understanding these join algorithms is key to optimizing database performance. Recommended videos and playlists If you liked this video, you will find the following videos and playlists helpful System Design: https://www.youtube.com/watch?v=o7qLKfILuD8 Designing Microservices: https://www.youtube.com/watch?v=JPj6mhVLQN0 Database Engineering: https://www.youtube.com/watch?v=-htbah3eCYg Concurrency In-depth: https://www.youtube.com/watch?v=2PjlaUnrAMQ Research paper dissections: https://www.youtube.com/watch?v=LXhgFAZroG8 Outage Dissections: https://www.youtube.com/watch?v=LeT_s-UFw-U Hash Table Internals: https://www.youtube.com/watch?v=jjW8w8ED3Ns Bittorrent Internals: https://www.youtube.com/watch?v=v7cR0ZolaUA Things you will find amusing Knowledge Base: https://arpitbhayani.me/knowledge-base Bookshelf: https://arpitbhayani.me/bookshelf Papershelf: https://arpitbhayani.me/papershelf Other socials I keep writing and sharing my practical experience and learnings every day, so if you resonate then follow along. I keep it no fluff. LinkedIn: https://linkedin.com/in/arpitbhayani Twitter: https://twitter.com/arpit_bhayani Weekly Newsletter: https://arpit.substack.com/ Thank you for watching and supporting! it means a ton. I am on a mission to bring out the best engineering stories from around the world and make you all fall in love with engineering. If you resonate with this then follow along, I always keep it no-fluff.