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.
- 1 Outcomes
- 2 Topics
- 3 Vocabulary
- 4 Skills
- 5 NICE Framework Categories
- 6 CSEC 2017 Categories
- 7 Specialization Areas
- 8 See also
- 9 Further reading
- 10 Sample knowledge test
- 11 Sample skills test
- 12 Sample abilities test
- 13 Additional notes or materials
- 14 Contacts
- 15 Reference ID
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.
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
- No SQL Databases
- Distributed (Hadoop, Mongo, etc.)
- Overview of database types - advantages and disadvantages
- SQL Data Manipulation Language
- SQL Data Definition Language
database, server, client, tables, SQL, query, DBMS
NICE Framework Categories
CSEC 2017 Categories
Related Knowledge Units
Original Knowledge Unit
Suggested academic readings
Sample knowledge test
Sample skills test
Sample abilities test
Additional notes or materials