This is an introductory course appropriate for students with no experience in database management systems and with no knowledge of Structured Query Language (SQL). 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.
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.
The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.