C S 452
Download as PDF
Database Modeling Concepts
Course Description
Database models: relational, deductive, object-oriented. Integrity constraints, query languages, database design.
When Taught
Fall, Winter, and Spring
Min
3
Fixed/Max
3
Fixed
3
Fixed
0
Title
Database Design
Learning Outcome
Be able to design and develop relational database applications. This includes conceptual modeling and normalization theory.
Title
Current Challenges
Learning Outcome
Be familiar with some of the current challenges facing database professionals.
Title
Data Considerations
Learning Outcome
SQL - Become competent at querying SQL across leetcode problems (MySQL and PostgreSQL) AI - Agentic AI, retrieval augmented generation, and semantic search. High Velocity Data Systems - Recovery, scale out, resilience, availability, consistent hashing, NoSQL, data change notifications, and consistent stateful distributed systems relevant today Large Data Systems - Introduction to Spark, Kusto, Kafka, Data Warehousing, ETL Data Security - Theory, RLS on Supabase
Title
Motivation
Learning Outcome
Students will reflect on why God has led them to be in this class and learn these concepts. Students will explore potential applications of class-relevant technology that could bless the world - that they could be a part of. Students will choose an area of deep study and rigoursly and with much effort and dedication build something worth sharing.
