Databases (2020)

From CyberEdWiki
Jump to: navigation, search
Database1.jpg

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[edit]

To complete this KU, students should 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[edit]

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[edit]

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

Skills[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