CS 235 - Introduction to Database Design and Theory

Credits: 1-5
LEC hours per week: 5
This course offers in-depth study of database theory and concepts including data modeling, database design, normalization, and data integrity and security. Includes a survey of one or more modern database management systems (DBMS) and their associated query mechanisms.
Recommended: CS 110.
Course Outcomes:

Demonstrate knowledge of database fundamentals.
Demonstrate an understanding of data models.
Create databases using different database models.
Employ entity-relationship (ER) modeling.
Construct effective Structured Query Language (SQL) queries.
Construct effective SQL joins and NoSQL aggregation pipelines.
Demonstrate an understanding of SQL and NoSQL DBMS.

Course Topics:

Database management systems (DBMS) and architecture
The relational model
Introduction to SQL and NoSQL; contrasts of SQL & NOSQL database operations for speed, updates, and scaling
Table, document and graph type databases
Methods of Node.js based Create, Read, Update and Delete (CRUD) functions in SQL and NoSQL frameworks
Database abstractions of application
Building database agnostic abstractions
Data normalization

Course Attribute(s): None