Syllabus

CS122 Using Relational Databases and SQL

Summer 2008
Computer Science Department
California State University, Los Angeles


Lectures:
 Tuesday 9:50-11:30am, in E&T A220
Lab:
 Thursday 9:00-11:30am, in E&T A220
Instructor:
 Chengyu Sun
Email: csun@calstatela.edu
Office: E&T A317
Office Hour: MW 3:30-5pm and F 3-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
1
 Administrative issues
Introduction to Relational Databases and SQL
Using MySQL
Single-table Selections
1

2
2
 Joins
3
3
 More on Joins
 3
4
 Functions 5
5
 Aggregations 4
6
 MIDTERM
7
 Subqueries and Set Operations 5,6
8
 DML and DDL 7,8
9
 Database Design using ER Diagram
10
 Introduction to Views, Indexes, and Transactions 7,8
11
 FINAL
Online Resources:
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.