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:
-
Set up and use one mainstream database management system, MySQL.
-
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.
-
Design and implement a database schema from an entity-relationship diagram.
Location
| Monday-Wednesday Section |
| Day |
Time |
Room |
Type |
| Monday |
1:30 PM - 3:10 PM |
ET-A309 |
Lecture |
| Wednesday |
1:30PM - 4:00 PM |
ET-A309 |
Lab |
| Tuesday-Thursday Section |
| Day |
Time |
Room |
Type |
| Tuesday |
1:30 PM - 3:10 PM |
ET-A309 |
Lecture |
| Thursday |
1:30PM - 4:00 PM |
ET-A309 |
Lab |
Prerequisite:
Computer Literacy
REQUIRED Textbook:
SQL Essentials (E-book) by Gary Randolph and Jeffrey Griffin
Databases
Software
Grading Allocations:
-
Labs: 45%
-
Midterm: 20%
-
Final: 25%
-
Quizzes: 10%
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.
-
Up to two days late: 15% penalty
-
Two days to one week late: 20% penalty
-
Turned in during finals week: additional 10% penalty
Grading Scale:
-
A: 94 to 100
-
A-: 90 to 93
-
B+: 85 to 89
-
B: 80 to 84
Graduate students will receive NC (No Credit) for scores below 80
-
B-: 75 to 79
-
C+: 70 to 74
-
C: 65 to 69
Undergraduates will receive NC (No Credit) for scores below 65
Resources:
Lab Assignments
Schedule
-
Week 1: Introduction to Relational Databases, SQL, MySQL, and Schemas
-
Week 2: Primary Keys and Single Table Selections
-
Week 3: Joins Part I and Foreign Keys
-
Week 4: Joins Part II
-
Week 5: Functions
-
Week 6: Midterm Week
-
Week 7: Grouping Data; HAVING; Set Operations; Scripts; Views
-
Week 8: Subqueries
-
Week 9: Defining and Altering Tables using DDL and DML
-
Week 10: Entity Relationship Model and ER Diagrams;
Databases and Applications; Next Steps
-
Week 11: Final Exam
Extra Documents
Some of these documents are difficult, but if you want to learn more about the relational
data model, Edgar F. Codd, and SQL, these are great places to start.
