CITE-240: Data Management

Course Information

• Course Code: CITE-240
• Course Title: Data Management
• Credits: 3
• Semester: 3

Program Context

This course is part of the Cyber Information Security Administration AAS program at North Idaho College.

Prerequisites

Completion of Semester 2 requirements for the Cybersecurity AAS program.

Course Description

Covers conceptual data modeling and introduces MySQL. Students will learn how to create simple to complex SELECT queries, including subqueries and joins, and how to use SQL to update and delete data. Topics covered in this course include exposure to MySQL; creating and modifying databases, tables, views, foreign keys and primary keys (FKs and PKs), and indexes; populating tables; and developing simple Select-From-Where (SFW) queries to complex 3+ table join queries.