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:
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.