Connect Tables - JOIN - Intro

By this point, you already know how to perform various kinds of SELECT commands a single table. 🎉

But the main advantage and feature of SQL databases is being able to handle related data, to connect or "join" different tables together. Connecting rows in one table to rows in another.

Let's see how to manage connected data, using JOIN 🤝

Info

We have a brief overview of SQL JOINs here.

We're kind of in the beating heart of working with relational databases here, so fasten your seat belts and let's go!

We'll first create connected tables🚀

Then we'll read connected data🚀

Next we'll focus on primary and foreign keys🚀

Tip

CoLang Workshop participants - we'll save the last tutorial👇 until after we've learned the basics of UPDATE🚀 and DELETE🚀 with one table at a time.

Eventually we'll learn how to insert, update and delete information in multiple tables🚀