CS122 - Using Relational Databases and SQL

                                                        Syllabus

                                                      Fall 2009
Course Web page: www.calstatela.edu/faculty/hpguo/Teaching/Fall09/CS122/CS122_f09.htm
Lectures: Tuesday 11.40 -- 1:20pm,   ET C159
Labs: Thursday 11:40 -- 2:10pm,   ET C159
       
Instructor: Huiping Guo
  hpguo@calstatela.edu
  323-343-6673
  ET A325
       
Office Hours:

Monday:      9:10 -- 9:50am

Tuesday:     9:00 -- 11:40am

Wednesday:   9:10 -- 9:50am        

       
Course Description: This is an introductory course to relational databases and SQL query language. Topics include basic selection queries, aggregate calculations, subqueries, joins, data definition and manipulation languages.  
Course Goals: At the end of the course, students are able to:
  1. Use a database management system: MySQL
  2. Design  complex queries which involve multiple columns and tables.
  3. Modify databases and define constraints
  These course goals contribute to the success of Student Learning Outcomes 1.d, 5, and 6.
   
Prerequisites: Computer literacy
       
Textbook(s):  “SQL Essentials”  by Gary Randolph and Jeffrey Griffin  Franklin Beedle & Associates,   ISBN: 1590280296                 
Reference(s): 1. SQL: Visual Quick Start Guide,  by Chris Fehily
  2. Learning SQL: A Step-by-Step Guide using Access, by Sikha Bagui and Richard Earp  
  3. SQL Fundamentals, by John J. Patrick
  4. Beginning SQL, by Paul Wilton and John Colby 
       
Topics:

1. Introduction to relational databases and SQL
 

2. Selections
  3. Aggregations
  4. Joins
  5. Functions and set operations
  6. Subqueries
  7. Table creation and updates
       
Grading policy: Assignment               40%  
Lab                            10%  
Midterm                    20%  
Final                           30%  
     

Letter

grade:

 A        90-100  
A-       85-89  
B        70-84  
C        60-69  
NC     <60  
       
Final exam:

  12/08 Tuesday, 10:45 -- 1:15pm
       
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.