Week 4 (September 16 – September 22)

Monday, September 17 (6:30 P.M. – 9:00 P.M., Blackboard Collaborate Ultra) Class Session 3
Topics	Review Chapter 3 exercise solutions How to retrieve data from two or more tables
Computing Setup	Install My Guitar Shop (MGS) Database on Your Computer Description: Please follow the guidance provided in the tutorial video below to install the MGS database on your computer. The starter files provided below have already been modified to make them compatible with MySQL Version 8. Tutorial Video: Install My Guitar Shop Database REVISED My Guitar Shop Database starter files DON'T FALL DOWN IN FRONT OF THIS MONSTER EITHER. If you downloaded this zip file before I revised it, you may have trouble installing the my_guitar_shop database. This REVISED version of the zip file should solve those problems. AP Database EERD My Guitar Shop Database EERD
Required Readings	Murach Chapter 4
Other Resources	Murach Chapter 4 Slides
Coding Assignments Due	Chapter 3 My Guitar Shop Exercises Description: Exercises 1 - 8 Submit to: Chapter 3 My Guitar Shop Exercises Exercises Tutorial Video: How to Complete and Submit MGS Exercises Tutorial Video: How to Read a Grading Rubric for a Practice Assignment Grading rubric for Chapter 3 My Guitar Shop Exercises Tutorial Video: How to Read a Grading Feedback Report for a Practice Assignment

Thursday, September 20 (6:30 P.M. – 7:30 P.M., Our normal Blackboard Collaborate Ultra classroom) Optional Session
Online Lab Session	On Thursday evenings, we will have an optional Online Lab Session using the Blackboard Collaborate Ultra platform. These sessions are a great opportunity to get help with your coding assignments or with your final project. Lab Sessions will take place in our normal Blackboard Collaborate Ultra classroom. Please use a headset.

Weekly Course Schedule – Fall 2018