CSCI 240 - Databases and SQL

Credit(s): 3

This course introduces the concepts and practice of relational database design and querying. Students learn to model data with entity-relationship diagrams (ERDs), apply the design process and normalization, and implement schemas with appropriate primary and foreign keys. The course provides thorough coverage of Structured Query Language (SQL) for creating, querying, and modifying relational databases, including joins, subqueries, and updates. (Intermittently)

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

Design and create tables using the rules of normalization and sound schema design.
Produce clear, correct Entity-Relationship Diagrams (ERDs) from real-world requirements.
Explain and apply primary, secondary, and foreign keys to enforce relational integrity.
Utilize SQL effectively to create, query, update, and delete data in a relational database.
Write and interpret SQL join statements (e.g., INNER and OUTER joins) to combine data across tables.