This course is an introductory database course appropriate for students who have basic knowledge about information organization. Although several database models are briefly presented, the course focuses on the relational model, the basis for most currently installed production database management systems (DBMS). The course covers the principles of database design and implementation including relational concepts, data modeling, conceptual and logical database design, use of SQL as a data- manipulation language, and current issues in database administration.
Learning Objectives
- Summarize the advantages/disadvantages of the relational model in resolving users’ needs for storing, organizing, accessing, and protecting data.
- Explain relational theory as the conceptual basis for relational database management systems.
- Analyze organizational artifacts to identify entities, attributes, relationships, and constraints.
- Create an entity-relationship diagram in Universal Modeling Language (UML).
- Develop a normalized schema from an entity-relationship diagram.
- Construct an operational database in a database management system.
- Write SQL statements for data manipulation, retrieval, and organization.
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.