CS 221CD Database Management Systems
Offers comprehensive examination of the design and implementation of relational database management systems (DBMS). Teaches the logical organization of databases, E_R design, normalization and use of SQL for data description and retrieval, including triggers and stored procedures; concurrency and security issues and typical solutions. Includes building a web interface to databases using PHP and MySQL. Introduction to major NoSQL models, the CAP theorem and discussion of architectures and concurrency choices for distributed databases. Major project using MongoDB. Discussion of the Life Cycle of Data, including practical and ethical decisions about what data is collected and how it is managed.