CIT 178 - Relational Databases

Course Description

This course introduces students to core database concepts including data, data types, and relationships. Students will interpret and create relational data structures and use SQL language to perform basic create, read, update, and delete operations. Students will perform, administrative, backup and security functions. Students will recognize the value of optimized data and produce normalized designs. Course content is mapped to the MTA 98-364 Database Fundamentals learning objectives and students enrolled in this course will take the certification exam. Group 2 course.

Credit Hours

3

Contact Hours

4

Lecture Hours

2

Lab Hours

2

General Education Outcomes supported by this course

Critical Thinking - Direct

Course Learning Outcomes

Knowledge:
  • Distinguish DML, DDL and DCL commands.
Application:
  • Create a normalized database with multiple tables, relationships, views, procedures, user-defined functions and triggers.
Integration:
  • Design relational databases: construct tables, relationships, fields and keys.
Human Dimension:
  • Give and receive feedback in an appropriate manner.
Caring - Civic Learning:
  • Explain the legal and ethical issues of data sharing.
Learning How to Learn:
  • Engage in self-directed learning.