Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Join Algorithms: Hash, Sort-Merge, Nested Loop Joins - Lecture 12

CMU Database Group via YouTube

Overview

Explore the fundamental join algorithms used in database systems, including hash joins, sort-merge joins, and nested loop joins, in this comprehensive lecture from Carnegie Mellon University's Intro to Database Systems course. Delve into the intricacies of each algorithm, understanding their strengths, weaknesses, and optimal use cases. Learn how these join techniques impact query performance and efficiency in relational database management systems. Gain insights from Professor Andy Pavlo's expertise as he breaks down complex concepts and provides practical examples. Access accompanying slides and notes for further study and reference.

Syllabus

#12 - Join Algorithms: Hash, Sort-Merge, Nested Loop Joins (CMU Intro to Database Systems)

Taught by

CMU Database Group

Reviews

Start your review of Join Algorithms: Hash, Sort-Merge, Nested Loop Joins - Lecture 12

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.