Database Security
CIT 51600/ 3 Cr.
This course provides an advanced training and hands-on experiences in database security and auditing. The course addresses everything from infrastructure to audit lifecycle and describes how to apply security measures in a holistic manner. It covers the basic topics, such as profiles, password policies, privileges and roles. It also explores advanced topics in database transaction security issues and provides proven techniques for designing, implementing, and certifying secure Oracle Database systems in a multitenant architecture.
- Available Online: No
- Credit by Exam: No
- Laptop Required: Yes
Prerequisites/Co-requisites:
Graduate Status and (CIT 21400 or basic database background and SQL experience)
Software
- Oracle and MS SQL Server
Outcomes
CIT Student Outcomes (What are these?)
(i) An ability to design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs.
(ii) An ability to function effectively on teams to accomplish a common goal.
(iii) An ability to identify and analyze user needs and take them into account in the selection, creation, evaluation and administration of computer-based systems.
(iv) An understanding of best practices and standards and their applicationTopics
- Security Architecture
- Operating System Security Fundamentals
- Administration of Users
- Database User Profiles, Password Policies, Privileges and Roles
- Design and Implement Database Application Security Models
- Virtual Private Database
- Design and Implement Database Auditing Models
- Application Data Auditing
- Auditing Database Activities
- Research in Database Security and Auditing