Skip to main content

CS403: Introduction to Modern Database Systems

Unit 10: The Join Statement
Programmers frequently join data from a number of different tables in order to obtain more information. They also--perhaps even more frequently--build queries to obtain information from more than one table in order to generate better information. In this section, we will learn about SQL Joins, which allow us to create complex queries, combine data from different tables, and obtain a new result set that can provide us with a better understanding of the data and maximize database flexibility.

Completing this unit should take you approximately 23 hours.
- Unit 10 Learning Outcomes Page
- 10.1: Introduction
  - Michael Fudge's "Understanding the JOIN Clause in the SELECT Statement Page
    Watch this video.
  - W3Schools: "SQL Joins" URL
    Read this page.
- 10.2: Inner Joins
  - W3Schools: "SQL INNER JOIN Keyword" URL
    Read this page.
- 10.3: Outer Joins
  - 10.3.1: Left Outer Joins
    W3Schools: "SQL LEFT JOIN Keyword" URL
    Read this page.
  - 10.3.2: Right Outer Joins
    W3Schools: "SQL RIGHT JOIN Keyword" URL
    Read this page.
  - 10.3.3: Full Outer Joins
    W3Schools: "SQL FULL JOIN Keyword" URL
    Read this page.
- 10.4: The Group By Clause
  - Stanford University: "Aggregation" Page
    Watch this video.
  - W3Schools: "SQL GROUP BY Statement" URL
    Read this page.
- 10.5: Assessment
  - W3Schools: "SQL Quiz" URL
    Take this quiz to assess your understanding of the materials presented in this unit.