CMPT 354 Description
This course provides an introduction to
Database Management Systems (DBMSs). We focus on the most widely used model:
the relational data model. Students will become familiar with the design of
database applications and use of databases. We study design tools, database
modeling and query languages, including the Structured Query Language (SQL).
Entity-Relationship Model
Relational Data Model
Relational Algebra and Calculus
Introduction to SQL
Constraints and Triggers
Database Application Development
Normalization
Introduction to OLAP
Introduction to NoSQL
John Edgar (johnwill@sfu.ca)