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