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.
- 1 Outcomes
- 2 Topics
- 3 Skills
- 4 NICE Framework Categories
- 5 CSEC 2017 Categories
- 6 Specialization Areas
- 7 See also
- 8 Further reading
- 9 Sample knowledge test
- 10 Sample skills test
- 11 Sample abilities test
- 12 Additional notes or materials
- 13 Contacts
- 14 Reference ID
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.
- 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
NICE Framework Categories
CSEC 2017 Categories
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