•    Employment
  •    Academia
  •    Research
    • NICE Framework
    • CAE Program

Database Management Systems

The intent of the Database Management Systems Knowledge Unit is to provide students with the skills to utilize database management system to solve specific problems.

Topics

  1. SQL Data Manipulation Language
  2. SQL Data Definition Language
  3. SQL Database Administration
  4. Database Security
  5. Overview of database types with advantages and disadvantages
  6. Overview of database types with advantages and disadvantages a. Flat b. Relational c. Network d. Hierarchical e. Object-Oriented f. Object-based g. Key-value h. Distributed
  7. Database concepts a. Indexing, Inference, Aggregation, Polyinstantiation
  8. Database concepts
  9. a. Indexing, Inference, Aggregation, Polyinstantiation
  10. How to protect data (confidentiality, integrity and availability in a DBMS context)
  11. Vulnerabilities (e.g., SQL injection)

Outcomes

  1. Compare and contrast database types including relational, hierarchical, distributed, and other models.
  2. Describe the role of a database, a DBMS, and a database server within a complex system supporting multiple applications.
  3. Apply SQL to create and administer databases and to manipulate the data they contain.
  4. Describe DBMS access controls, privilege levels, and security principles and apply them to a simple database.
  5. Outline common structures for storing data in a database management system.
  6. Design and deploy a simple database for a specified application.
  7. Design and deploy a simple database for a specified application
  8. Describe the role of a database, a DBMS, and a database server within a complex system supporting multiple applications
  9. Describe DBMS access controls, privilege levels, and security principles and apply them to a simple database

KSA-T

Below are the Knowledge, Skills, Abilities and Tasks (KSA-T) identified as being required to perform this work role.
Learn More about the KAS-T's.

  • Knowledge
  • Skills
  • Abilities
  • Tasks
ID DESCRIPTION
K0069 Knowledge of query languages such as SQL (structured query language).
K0024 Knowledge of database systems.
K0038 Knowledge of cybersecurity and privacy principles used to manage risks related to the use, processing, storage, and transmission of information or data.
K0095 Knowledge of the capabilities and functionality associated with various technologies for organizing and managing information (e.g., databases, bookmarking engines).
K0007 Knowledge of authentication, authorization, and access control methods.
K0033 Knowledge of host/network access control mechanisms (e.g., access control list, capabilities lists).
K0373 Knowledge of basic software applications (e.g., data storage and backup, database applications) and the types of vulnerabilities that have been found in those applications.
K0009 Knowledge of application vulnerabilities.
K0211 Knowledge of confidentiality, integrity, and availability requirements.
K0278 Knowledge of current and emerging data remediation security features in databases.
K0420 Knowledge of database theory.
ID DESCRIPTION
S0013 Skill in conducting queries and developing algorithms to analyze data structures.
S0037 Skill in generating queries and reports.
S0028 Skill in developing data dictionaries.
S0029 Skill in developing data models.
S0030 Skill in developing operations-based testing scenarios.
ID DESCRIPTION
ID DESCRIPTION