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.
To complete this KU, students should 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
Related Knowledge Units
Original Knowledge Unit
Suggested academic readings
Sample knowledge test
Sample skills test
Sample abilities test
Additional notes or materials