Provides an overview of fundamental concepts of databases and database management. These concepts include aspects of database design, database management systems, data models, normalization, the standard relational database query, SQL, basic database security and relational database alternatives.
Learning Objectives
Identify database concepts and their uses. Compare data types and types of databases. Describe a database management system (DBMS) and the services a DBMS provides for users. Demonstrate an understanding of various database design models. Describe the normalization process and define normal forms. Define and be able to use data definition language, data manipulation language, and database triggers as they apply to SQL and for a specified application. Compare relational database alternatives. Demonstrate an understanding of the database administration function. Understand the basics of data integrity and database security.
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
Work Roles
Feedback
If you would like to provide feedback on this course, please e-mail the NICCS team at NICCS@hq.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.