Please read carefully

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.

Submission Details:

• By Saturday, July 16, 2016, post your response to the appropriateDiscussion Area.
• Through Wednesday, July 20, 2016, review and comment on at least two of your classmates' responses. Consider the following in your response:
• Provide a statement of clarification or a point of view with rationale.
• Challenge a point of discussion or draw a relationship between one or more points of the discussion.

Discussion Grading Criteria and Rubric

All discussion assignments in this course will be graded using a rubric. This assignment is worth 40 points. Download the discussion rubric and carefully read it to understand the expectations.