SLOs

Week 05: April 13–17¶

At the end of this week, you should be able to:

1. Explain conceptually how a JOIN combines rows from multiple tables.

2. Write an INNER JOIN to retrieve only rows with matching values in both tables.

3. Write a LEFT OUTER JOIN to include all rows from the left table, with NULL for unmatched rows on the right.

4. Write a RIGHT OUTER JOIN and explain its symmetry with LEFT OUTER JOIN.

5. Write a FULL OUTER JOIN to include all rows from both tables regardless of matches.

6. Write a CROSS JOIN and explain when it is useful.

7. Use table aliases to write cleaner and more readable multi-table queries.

8. Join more than two tables in a single query.

9. Write a self-join to compare rows within the same table.