Lesson 7: Working with Databases and MySQL

✢ Required Reading

 • Text - Chapter 7
 • Chapter Summary - ppt

✢ Videos

Please note that recorded lecture videos require IE and the appropriate add-ons in order to replay.
Please let the instructor know if any of the third party videos are pulled by the origination server. Thank you.

 • Lecture - Lesson 07
 • Past Lecture (Reference Only - course logistic material will not apply) Lecture Lesson 2011


*Please note that all media in this course are used in accordance with the TEACH Act and remain the property of their respective copyright holders.

✢ Deliverables

Reading Comprehension Questions (Text) - Chapter 7

Complete the odd numbered comprehension check questions at the end of the assigned chapter.


   • Submission Form

Threaded Discussion
Discussion threads provide you the opportunity to interact with your fellow students by asking questions and providing help. One of the best ways to learn is to teach. Please use appropriate language and be civil. Each discussion post in this class requires you to ask a relevant question about the assignment and to answer at least one of the questions posted by your peers.


   • Discussion Link

Development Assignments

Complete these assignments in MySQL monitor locally. Submit final products at the indicated spots for each exercise using a .swf video or equivalent. [JING is a free, simple screen capture tool from techsmith.com that can be used for this purpose.]

  1. Exercise 7-1: end of exercise (part 9)
  2. Exercise 7-2: starting at 6 show parts 6, 7, 8, and 9
  3. Exercise 7-3: parts 5 and 6
  4. Exercise 7-4: show the four query results
Submission: Submit in a chapter folder within your citpt227 folder on your server space, i.e. http://citpt.lcsc.edu/yourusername/citpt227/chapter07/
Quiz
   • Quiz Lesson 7 (timed)