Database Management Systems (2020)
The intent of the Database Management Systems Knowledge Unit is to provide students with the skills to utilize database management system to solve specific problems.
To complete this KU, students should be able to:
- Describe the role of a database, a database management system (DBMS), and a database server within a complex system supporting one or more applications.
- Outline different types of databases and cases where they may be used.
- Identify and describe common security concerns in databases and database management systems.# Apply SQL to create and administer databases and to manipulate the data they contain.
- Describe DBMS access controls, privilege levels, and security principles and apply them to a simple database.
- SQL Database Administration
- User creation/deletion, permissions and access controls)
- Database concepts
- Indexing, Inference, Aggregation, Polyinstantiation
- Database Security
- How to protect data (confidentiality, integrity and availability in a DBMS context)
- Vulnerabilities (e.g., SQL injection)
- Overview of database security models and concerns, such as:
- Hashing and encryption
- Data corruption
- Unauthorized access
- Database access controls (DAC, MAC, RBAC, Clark-Wilson)
MySQL, PostgreSQL, Microsoft SQL Server, Microsoft SQL Server Management Studio, Oracle Database
Related Knowledge Units
Original Knowledge Unit
- Basta, A., Zgola, M. “Database Security”, Centage Learning. 2012.
Suggested academic readings
Sample knowledge test
Sample skills test
Sample abilities test
Additional notes or materials