The finish line

Joining Data in SQL

Maham Faisal Khan

Senior Content Developer, DataCamp

Types of joins

  1. INNER JOIN, or just JOIN
  2. Outer join
    • LEFT JOIN
    • RIGHT JOIN
    • FULL JOIN
  3. CROSS JOIN
  4. Semi join / anti join
  5. Self join
Joining Data in SQL

Set operations

A figure showing three Venn diagrams: UNION, INTERSECT, and EXCEPT. The UNION diagram has two overlapping circles, fully colored in green. The INTERSECT diagrams has two overlapping circles, but only the overlapping part is colored in green. The EXCEPT diagram only has the part of the left circle that has nothing in common with the right circle colored in green.

Joining Data in SQL

Types of basic subqueries

  • Subqueries inside SELECT clauses
  • Subqueries inside WHERE clauses
  • Subqueries inside FROM clauses
Joining Data in SQL

WHERE to from here?

  • DataCamp's Intermediate SQL course
  • Projects, practice exercises and competitions
  • Workspace
Joining Data in SQL

The finish line!

Joining Data in SQL

Preparing Video For Download...