Database Fundamentals and Security Practices

Catalog description

This course provides a comprehensive overview of databases, database management systems (DBMS) and their applicable security concepts and controls. Students will explore various database models, including relational, hierarchical, distributed, and NoSQL databases, understanding their advantages, disadvantages, and use cases. The course emphasizes the importance of data administration throughout the data lifecycle, focusing on methods to protect data confidentiality, integrity, and availability. Students will gain hands-on experience with SQL for database creation, administration, and manipulation. Additionally, the course covers DBMS access controls, security principles, and common security concerns in databases such as SQL injection, data encryption, and access controls. Only one of C YBR 202 or C INF 202 may be taken for credit.