CMPS1171 - Introduction to Databases (L Augustine)

This course provides a rigorous introduction to the fundamental principles of database systems, focusing on data modeling, relational database theory, and query languages. Students will learn to design and implement relational databases using Entity-Relationship (ER) modeling, normalization, and Structured Query Language (SQL). The course also covers conceptual-to-physical database design, integrity constraints, transactions, and simple analytics on large datasets. Through lectures, hands-on SQL practice, and a structured semester-long project, students will gain practical and theoretical skills necessary for modern data-driven applications.

Pre-requisite: CMPS1131 - Principles of Programming I