This course examines relational database management systems using a typical, commercial DBMS, such as Microsoft Access and/or MySQL and Oracle. Topics include data modeling, database design, implementation, forms and reports, and remote access to databases. The goal of this course is to provide students with a basic understanding of database design, implementation, and management concepts and techniques.
Learning Objectives
- Explain the operation of Database Management Systems.
- Demonstrate a basic understanding of relational data modeling, using Entity-‐ Relationship diagrams.
- Design a relational database.
- Implement a database, using a database management system.
- Identify and use basic Data Manipulation Language (DML) such as insert, update, and delete records, using a database management system.
- Identify and use basic Data Definition Language (DDL) statements, such as create, drop, and alter database structures, using a database management system.
- Summarize a basic understanding of the Structured Query Language (SQL) through the use of database queries and other operations.
Framework Connections
The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):
Competency Areas
Feedback
If you would like to provide feedback on this course, please e-mail the NICCS team at NICCS@mail.cisa.dhs.gov. Please keep in mind that NICCS does not own this course or accept payment for course entry. If you have questions related to the details of this course, such as cost, prerequisites, how to register, etc., please contact the course training provider directly. You can find course training provider contact information by following the link that says “Visit course page for more information...” on this page.