CS122 Relational Databases and SQL, Fall 2013

Instructor: John Hurley

General Information

About This Course

CS122 Relational Databases and SQL is an introductory course in the use of relational databases. This course will also introduce some elementary programming elements through the use of the Structured Query Language, SQL, which we will use to extract data from several databases. The course also introduces students to database modeling, entity-relationship modeling, and Data Definition Language.

At the end of the course, students will be able to:

  1. Set up and use one mainstream database management system, MySQL.
  2. Use the SQL query language to express simple and compound search conditions, combine and process data from multiple columns and tables, and format query results into user-friendly reports.
  3. Design and implement a database schema from an entity-relationship diagram.

Location

Monday-Wednesday Section
Day Time Room Type
Monday 1:30 PM - 4:00 PM ET-A220 Lab
Wednesday 1:30 PM - 3:10 PM ET-A220 Lecture
Tuesday-Thursday Section
Day Time Room Type
Tuesday 9:50 AM-11:30 AM ET-A220 Lecture
Thursday 9:00 AM - 11:30 AM ET-A220 Lab

Prerequisite:

Computer Literacy

REQUIRED Textbook:

SQL Essentials (E-book) by Gary Randolph and Jeffrey Griffin

Databases


Software


Grading Allocations:


Late Work:

Accepted with penalty until the day of the final exam. After the deadline has passed, CSNS will not accept work so you must email it to me. Any work turned in any way other than by CSNS will be treated as late, even if it is on time.

Grading Scale:


Resources:


Schedule