Databases (2020)

The intent of the Databases Knowledge Unit is to teach students how database systems are used, managed, and issues associated with protecting the associated data assets.

Outcomes

After completing the KU, students will be able to:

1. Compare and contrast database types including relational, hierarchical, distributed, and other models.
2. Outline different types of databases and cases where they may be used.
3. Outline common structures for storing data in a database management system.
4. Use basic SQL statements to manipulate data and data structures.
5. Design and deploy a simple database for a specified application.

Topics

To complete this KU, all topics and sub-topics must be completed

1. Outline different types and structures of modern database management systems and their application, such as:
   • Relational Databases
   • Hierarchical
   • No SQL Databases
   • Object-Based
   • Object-Oriented
   • Distributed (Hadoop, Mongo, etc.)
2. Overview of database types - advantages and disadvantages
   1. Flat
   2. Relational
   3. Network
   4. Hierarchical
   5. Object-Oriented
   6. Object-based
   7. Key-value
   8. Distributed
3. SQL Data Manipulation Language
   1. SELECT
   2. INSERT
   3. DELETE
   4. UPDATE
4. SQL Data Definition Language

Vocabulary

database, server, client, tables, SQL, query, DBMS

NICE Framework Categories

Securely Provision (SP)

Operate and Maintain (OM)

Oversee and Govern (OV)

Protect and Defend (PR)

CSEC 2017 Categories

Data Security

System Security

Specialization Areas

• Data Management Systems Security
• Health Care Security

See also

Related Knowledge Units

• Database Management Systems
• Data Administration

Original Knowledge Unit

• Databases (2014)

Reference ID

DAT