CS122 Using Relational Databases and SQL

Summer 2008

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

Announcements

8/18 - FINAL will be from 8:00am to 10:30am on Thursday, August 28 in E&T A220.
7/11 - MIDTERM will be from 9:10am to 11:30am on Thursday, July 24 in E&T A220.
6/13 - Please send an email to csun@calstatela.edu and ask for an account on the CS3 server before the lab on Thursday 6/19. You have to be already enrolled in the class in order to get an account.

Lecture Notes	Assignments
Syllabus Introduction to Relational Databases and SQL (ppt) (pdf) MySQL Setup and Configuration Using MySQL (ppt) (pdf) The Store Database (ppt) (pdf) Single-table Selections (ppt) (pdf) Joins (ppt) (pdf) Common Functions in MySQL (ppt) (pdf) Aggregations (ppt) (pdf) Subqueries and Set Operations (ppt) (pdf) DDL and DML (ppt) (pdf) Introduction to Entity-Relationship Diagram (ppt) (pdf) Views, Indexes, and Transactions (ppt) (pdf)	Lab 1. MySQL and Single-table Selections Lab 2. Joins Lab 3. More Joins Lab 4. Functions Lab 5. Aggregations Lab 6. Subqueries and Set Operations Lab 7. Updates Lab 8. Database Design Using ER Diagram Homework 1 Due: Monday, July 21 Homework 2 Due: Wednesday, August 13 Homework 3 Due: Wednesday, August 20
Additional Course Materials	Exams
CS3 Server Information Lyric Music Database Design (thanks to Dr. Huiping Guo) LyricMySQL.sql, RemoveLyric.sql store.sql, selection.sql, join.sql, function.sql aggregation.sql, subquery.sql, update.sql Additional SQL Exercises	Midterm, Thursday, July 24 Final, Thursday, August 28