Assignment 1: Table Joins

In this assignment, you will investigate the methods of combining data tables in order to extract data from a database. Specifically, you will learn about two types of joins to combine tables-inner and outer joins. Once you complete this assignment, you would have gained an understanding of when to use each type of join.

Tasks:

Using the Argosy University online library resources, your course textbook, and the Internet, conduct research on joins. Based on your research, respond to the following questions:

What are the differences between an inner join and an outer join? Describe in your own words.

When would you use one type of join versus the other? Provide at least two examples of each type of join.