Syllabus

CS122 Using Relational Databases and SQL

Spring 2004
Computer Science Department
California State University, Los Angeles

Lectures:

Tuesday 6:10-7:50pm, in E&T A220

Lab:

Thursday 6:10-8:40pm, in E&T A220

Instructor:

Chengyu Sun
Email: csun@calstatela.edu
Office: E&T A317
Office Hour: MTWR 2:00-4:00pm, or by appointment

Course Description:

This is an introductory course about relational databases and the SQL query language. We will cover almost every aspect of SQL, from simple selection queries to joins and aggregations, as well as various language features such as functions and set operations. In the latter part of the course we will also discuss some basic database design issues.

Textbook(s):

Learning SQL: A Step-by-Step Guide using Access, by Sikha Bagui and Richard Earp

Software Tools:

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

Grading Policy:

Exercises 15%
Assignments 25%
Midterm 30%
Final 30%

Schedule:

Week	Topics	Chapters
1	Administrative issues Introduction to relational databases and MS Access	0, 1, 3
2	Selections	2
3	Joins	4
4	Aggregations	9
5	Functions	5
6	MIDTERM
7	Set operations	7
8	Table creation and updates	3
9	Introduction to database design	0, 11
10	Views, temporary tables, and more about subqueries	6, 8, 10
11	FINAL

Online Resources:

Class home page - http://www.calstatela.edu/faculty/csun/teaching/cs122/index.html
Sample database used in the textbook - Student.mdb (540k) or Student.zip (50k)
Online SQL tutorials (by Google)

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.