Week 3 (January 29 – February 4)

Tuesday, January 31 (6:30 P.M. – 7:30 P.M., Blackboard Collaborate) Optional Session
Online Office Hours	Every Tuesday evening, I will be holding Online Office Hours using the Blackboard Collaborate platform. You are invited to join us to discuss questions and issues concerning the class. Meet in the Drop In Room of the Blackboard Collaborate platform. Join the Kevin Trainor Office Hours breakout room. Please use a headset.

Wednesday, February 1 (6:30 P.M. – 9:00 P.M., Blackboard Collaborate) Class Session 3
Topics	How to retrieve data from two or more tables (Chapter 4)
Computing Setup	Install Database for My Guitar Shop Exercises Description: Before starting your work on the coding assignment due this week, you will need to download the starter files for the My Guitar Shop case and run the database creation script. Links to the starter files and to a tutorial video are included below. Tutorial Video - Install My Guitar Shop Database My Guitar Shop Database starter files
Required Readings	Murach: Chapter 4 (How to retrieve data from two or more tables)
Other Resources	Murach Chapter 4 Slides w3schools.com (2017). SQL JOIN w3schools.com (2017). SQL INNER JOIN w3schools.com (2017). SQL LEFT JOIN w3schools.com (2017). SQL RIGHT JOIN w3schools.com (2017). SQL FULL OUTER JOIN
Coding Assignments Due	Chapter 3 My Guitar Shop Exercises Description: Exercises 1 - 8 Submit to: Chapter 3 My Guitar Shop Exercises Exercises Tutorial Video: Murach 2e Chapter 3 Demo Tutorial Video - Complete and Submit My Guitar Shop Exercises Grading rubric

Weekly Course Schedule – Spring 2017