Syllabus

CS122 Using Relational Databases and SQL

Fall 2011
Computer Science Department
California State University, Los Angeles

Lectures:

Tuesday 1:30-3:10pm, in E&T A210

Lab:

Thursday 1:30-4:00pm, in E&T A210

Instructor:

Chengyu Sun
Email: csun@calstatela.edu
Office: E&T A317
Office Hour: MW 2-4pm and T 3:30-5pm, or by appointment

Course Description:

This is an introductory course about relational databases and the SQL query language. We will focus on using SQL to access data stored in relational databases, by expressing various search conditions, processing data from one or more tables, and formatting the results into user-friendly reports. In the latter part of the course, we will also discuss how to design databases for common application scenarios using the Entity-Relationship (ER) model.

Textbook(s):

SQL Essentials, by Gary Randolph and Jeffrey Griffin

Software Tools:

Required - Email and MySQL
Optional (for access online lecture notes) - Adobe Acroread and/or MS PowerPoint

Grading Policy:

Homework and projects 30%, Labs 30%, Midterm 20%, Final 20%

90 - 100
80 - 90
60 - 80
40 - 60
below 40

A
B
C
D
F

Schedule:

Week	Topics	Chapters
0	Administrative issues Using MySQL
1	Introduction to Relational Databases and SQL Single-table Selections	1 2
2	Joins	4
3	More on Joins	4
4	Functions	5
5	Aggregations	3
6	MIDTERM
7	Subqueries and Set Operations	5,6
8	DML and DDL	7,8
9	Introduction to Views, Indexes, and Transactions	7,8
10	Database Design
11	FINAL

Online Resources:

Class home page - http://sun.calstatela.edu/~cysun/www/teaching/cs122/index.html
Class forum - http://csns.calstatela.edu/forum/viewForum.html?forumId=31003

Academic Integrity:

Cheating will not be tolerated. Cheating on any assignment or exam will be taken seriously. All parties involved will receive a grade of F for the course and be reported to the Academic Senate.