OKSTEM College · AS Computer Science

CS 221: Database Systems

Design schemas, write SQL, and understand how databases store and retrieve data.

Start Course →

10 Lessons

Relational Model & Keys

Entity-Relationship Modeling

SQL Basics: SELECT, FROM, WHERE

Joins & Set Operations

Aggregation & Grouping

Subqueries & Views

Normalization: 1NF, 2NF, 3NF

Transactions & ACID Properties

Indexing & Query Optimization

NoSQL Databases

Learning Outcomes

Model data using the relational model and ER diagrams
Write complex SQL queries
Normalize schemas to 3NF
Understand transactions, ACID, and indexing