EasyEnv
MySQL
IntermediateLesson 6 of 1335 min · hands-on

Joins

Part of the MySQL course

Your users live in one table and their orders live in another, and the only thread connecting an order to the person who placed it is a number in a column. That split is deliberate: it means a user's name is written down exactly once, so changing it changes it everywhere.

A join is how you stitch them back together for the length of a single query. Joins are the single biggest reason SQL feels powerful, and also the place beginners lose the most time, almost always because rows silently vanished or silently multiplied. We will go slowly and use data designed to expose both. ...

Want to learn MySQL Joins in a real environment?

Click below, get a fresh Linux box with MySQL ready to go, and work through Joins hands-on with an AI tutor that knows your code.

Start this lessonJoins

What you'll learn

  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • No FULL OUTER JOIN
  • UNION workaround
  • Self-join
  • USING vs ON

Read this lesson in your language

All lessons in this course

13 lessons
  1. 1What is MySQL20 min
  2. 2The mysql CLI and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types30 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes30 min
  9. 9Transactions and Storage Engines35 min
  10. 10Stored Procedures and Triggers35 min
  11. 11EXPLAIN and Query Tuning35 min
  12. 12mysqldump and Restore25 min
  13. 13Capstone: Design an Ecommerce Schema50 min

Explore other courses

Joins - MySQL (English) | Engineering Courses