Database Management Systems (2020)

From CyberEdWiki
Jump to: navigation, search

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.

Outcomes[edit]

To complete this KU, students should be able to:

  1. Describe the role of a database, a database management system (DBMS), and a database server within a complex system supporting one or more applications.
  2. Outline different types of databases and cases where they may be used.
  3. 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.
  4. Describe DBMS access controls, privilege levels, and security principles and apply them to a simple database.

Topics[edit]

  1. SQL Database Administration
    • User creation/deletion, permissions and access controls)
  2. Database concepts
    • Indexing, Inference, Aggregation, Polyinstantiation
  3. Database Security
    • How to protect data (confidentiality, integrity and availability in a DBMS context)
    • Vulnerabilities (e.g., SQL injection)
  4. 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


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