• 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 4 hours.

    • 10.1: Introduction

    • 10.2: Inner Joins

    • 10.3: Outer Joins

    • 10.4: The Group By Clause

    • 10.5: Assessment

    • Unit 10 Assessment