Dr. Ning Zhang
425 Ambrose Hall
https://zhangningsau.github.io
ZhangNing@sau.edu
563-333-6144
Office Hours
Materials and Resources
Learning MySQL(Textbook) - Downloads
Lecture Videos
WebEx Meeting Link
https://stambrose.webex.com/join/zhangning
Course Outline
| Week | Reading and Announcements | Homework Assignments | |
|---|---|---|---|
| 17 | Week of 5/16 |
The final exam will be on Thursday, May 19, from 10:00 — 11:50 AM See the Registrar's Final Exam Schedule |
|
| 16 | Tue 5/10 | Quiz 3 (Chapters 8 and 9) | |
| Thu 5/12 | Study day | ||
| 15 | Tue 5/3 |
Chapter 9 One Grant Option Problem in XAMPP 8 |
Homework 8 for Chapter 9 |
| Thu 5/5 | Study Day | ||
| 14 | Tue 4/26 | Chapter 9 | |
| Thu 4/28 | Quiz 2 (Chapters 5,6, and 7. For chapter 5, INNER JOIN, INSERT, DELETE, UPDATE) | ||
| 13 | Tue 4/19 | Chapter 9 | |
| Thu 4/21 |
Let's talk about HW6 Hints for HW6 |
||
| 12 | Tue 4/12 | Chapter 8 | |
| Thu 4/14 | Chapter 8 | Homework 7 for Chapter 8 | |
| 11 | Tue 4/5 | Chapter 7 | |
| Thu 4/7 |
Chapter 7 Chapter 8 |
Homework 6 for Chapter 7 | |
| 10 | Tue 3/29 | Chapter 7 | |
| Thu 3/31 | Chapter 7 | ||
| 9 | Tue 3/22 | Spring Break | |
| Thu 3/24 | Spring Break | ||
| 8 | Tue 3/15 | Chapter 7 | |
| Thu 3/17 | Midterm (Chapters 123, 4,5,6) | ||
| 7 | Tue 3/8 | Chapter 6 | |
| Thu 3/10 | Chapter 6 | Homework 5 for Chapter 6 | |
| 6 | Tue 3/1 |
Chapter 5 Chapter 6 |
Homewok 4 for Chapter 5 Part II |
| Thu 3/3 | Chapter 6 | ||
| 5 | Tue 2/22 | Chapter 5 | |
| Thu 2/24 | Quiz 1 (Chapters 123, 4, and 5. For chapter 5, only SELECT on one database, no JOIN, no INSERT, DELETE, UPDATE) | ||
| 4 | Tue 2/15 | Chapter 5 | Homework 3 for Chapter 5 Part I |
| Thu 2/17 | Chapter 5 | ||
| 3 | Tue 2/8 | Chapter 4 | Homework 2 for Chapter 4 |
| Thu 2/10 | Chapter 5 | ||
| 2 | Tue 2/2 |
Chapters 1,2,3 Chapter 4 |
Homework 1 for Chapters 1,2,3 |
| Thu 2/4 | Chapter 4 | ||
| 1 | Tue 1/25 |
Syllabus
Chapter 0: Introduction to Databases |
|
| Thu 1/27 |
Chapter 0: Introduction to Databases
Chapters 1,2,3 |
Homework 0 | |