CIT 172 - Database Essentials in Amazon Web Services

Prerequisite: CIT 101 or CIT 114
Transfers to: CSU

This course provides students with an introduction to core concepts in data and information management in traditional and cloud systems. The course centers around the fundamental skills of identifying organizational information requirements, modeling requirements using conceptual data modeling techniques, converting conceptual data models into relational data models, and verifying structural characteristics with normalization techniques. The course also takes up implementing and utilizing a relational database using an industrial-strength database management system in Amazon Web Services (AWS). The course covers basic database administration tasks and key concepts of data quality and data security. In addition to developing database applications, the course helps students understand how large-scale packaged systems are highly dependent on the use of database management systems (DBMS). Building on the transactional database understanding, the course provides an introduction to data and information management technologies that provide decision support capabilities under the broad business intelligence umbrella.