Database Management Systems (2020)
From CyberEdWiki
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.
Contents
Outcomes[edit]
After completing the KU, students will 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.
Topics[edit]
- 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:
- Inference
- Aggregation
- Injection
- Hashing and encryption
- Data corruption
- Unauthorized access
- Database access controls (DAC, MAC, RBAC, Clark-Wilson)
Skills[edit]
MySQL, PostgreSQL, Microsoft SQL Server, Microsoft SQL Server Management Studio, Oracle Database
NICE Framework Categories[edit]
CSEC 2017 Categories[edit]
Specialization Areas[edit]
See also[edit]
Related Knowledge Units
Original Knowledge Unit
Further reading[edit]
Suggested textbooks[edit]
- Basta, A., Zgola, M. “Database Security”, Centage Learning. 2012.
Suggested academic readings[edit]
Sample knowledge test[edit]
Sample skills test[edit]
Sample abilities test[edit]
Additional notes or materials[edit]
Contacts[edit]
Reference ID[edit]
DMS