CS122 Using Relational Databases and SQL

Summer 2007


Lectures
T 9:50 - 11:30am
Lab
R 9:00 - 11:30am
Room
E&T A220
Instructor
Chengyu Sun, csun@calstatela.edu
Office Hours
M 1:30-3:30pm and TR 2-4pm, or by appointment, in E&T A317


Announcements
  • 8/14 - FINAL will be from 8:00am to 10:30am on Thursday, August 30.
  • 7/15 - MIDTERM will be from 9:00am to 11:30am on Thursday, July 26 in E&T A220.
  • 7/2 - There's another problem with the LyricMySQL.sql script (this time it's related to date values). So again, please use RemoveLyric.sql to remove the tables in your database and then use the updated LyricMySQL.sql to re-create them.
  • 6/24 - LyricMySQL.sql is updated - all 'Null' are replaced with Null. Please use RemoveLyric.sql to remove the tables in your database and then use LyricMySQL.sql to re-create them again.
  • 6/18 - Please send an email to csun@calstatela.edu and ask for an account on the CS3 server before the lab on Thursday. You have to be already enrolled in the class in order to get an account.
Lecture Notes
Assignments
Additional Course Materials
Exams