Databases (2020)
From CyberEdWiki
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.
Contents
Outcomes[edit]
After completing the KU, students will be able to:
- Compare and contrast database types including relational, hierarchical, distributed, and other models.
- Outline different types of databases and cases where they may be used.
- Outline common structures for storing data in a database management system.
- Use basic SQL statements to manipulate data and data structures.
- Design and deploy a simple database for a specified application.
Topics[edit]
To complete this KU, all topics and sub-topics must be completed
- 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.)
- Overview of database types - advantages and disadvantages
- Flat
- Relational
- Network
- Hierarchical
- Object-Oriented
- Object-based
- Key-value
- Distributed
- SQL Data Manipulation Language
- SELECT
- INSERT
- DELETE
- UPDATE
- SQL Data Definition Language
Vocabulary[edit]
database, server, client, tables, SQL, query, DBMS
Skills[edit]
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]
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]
DAT