STM 301 Database Systems

Students design relational schemas, write SQL queries, and configure transactions, indexes, and constraints to meet application needs. Students evaluate normalization trade-offs and explore non-relational data models when appropriate. Students also encounter AI-relevant storage patterns such as feature stores and vector databases/embeddings and consider data governance for model training.