CSCI 240 - Databases and SQL

Credit(s): 3

This course focuses on the concepts of relational databases. Topics include entity relationship diagrams, design process and normalization, table creation, records and typed fields, primary and foreign keys, and a thorough coverage of Structured Query Language (SQL) to create, query and change a relational database. (Intermittently)

Course Learning Outcomes: Upon completion of the course, students will be able to

Design and create tables based on rules of normalization.
Create Entity Relationship Diagrams.
Utilize SQL effectively to create, query and change a relational database.
Explain primary, secondary, and foreign keys.
Utilize the SAL join statement.