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.
General Education Outcomes supported by this course
Critical Thinking - Direct
Course Learning Outcomes Knowledge:
- Distinguish DML, DDL and DCL commands.
- Create a normalized database with multiple tables, relationships, views, procedures, user-defined functions and triggers.
- Design relational databases: construct tables, relationships, fields and keys.
Caring - Civic Learning:
- Give and receive feedback in an appropriate manner.
Learning How to Learn:
- Explain the legal and ethical issues of data sharing.
- Engage in self-directed learning.