CS122 Using Relational Databases and SQL

Fall 2011

Lectures	T 1:30 - 3:10pm
Lab	R 1:30 - 4:00pm
Room	E&T A210
Instructor	Chengyu Sun, csun@calstatela.edu
Office Hours	MW 2-4pm and T 3:30-5pm, or by appointment, in E&T A317

Announcements

11/29 - Final will be from 1:30pm to 4pm on Tuesday, December 6 in E&T A210.
10/24 - Midterm will be from 1:30pm to 3:30pm on Thursday, November 3 in E&T A210.

Lecture Notes	Assignments
Syllabus Using MySQL (ppt) (pdf) Introduction to Relational Databases and SQL (ppt) (pdf) (video) The Store Database (ppt) (pdf) (video) Single-Table Selections (ppt) (pdf) (video) Joins (ppt) (pdf) (video1), (video2) Common Functions in MySQL (ppt) (pdf) (video) Aggregations (ppt) (pdf) (video) Subqueries and Set Operations (ppt) (pdf) (video) DDL and DML (ppt) (pdf) (video) Introduction to Database Design Using ER Diagram (ppt) (pdf) (video) Views, Indexes, and Transactions (ppt) (pdf) (video)	Lab 0. Using MySQL Lab 1. Single-Table Selections (Discussion) Lab 2. Joins (Discussion) Lab 3. More Joins Lab 4. Functions Lab 5. Aggregations (Discussion) Lab 6. More Aggregations Lab 7. Subqueries and Set Operations Lab 8. Updates Lab 9. Database Design Using ER Diagram Homework 1 Due: Monday, October 31 Homework 2 Due: Wednesday, November 23 Homework 3 Due: Wednesday, November 30
Additional Course Materials	Exams
CS3 Server Information LyricMySQL.sql, RemoveLyric.sql store.sql, selection.sql, join.sql function.sql, subquery.sql, update.sql Additional SQL Exercises	Midterm Sample Final