This course introduces students to the concepts and terminology used in the field of data management. They will be introduced to Structured Query Language (SQL) and will learn how to use Data Definition Language (DDL) and Data Manipulation Language (DML) commands to define, retrieve, and manipulate data. This course covers differentiations of data-structured vs. unstructured and quasi-structured (relational, hierarchical, XML, textual, visual, etc); it also covers aspects of data management (quality, policy, storage methodologies). Foundational concepts of data security are included. This course prepares students for Data Management – Applications
- Introduction to Information and Data: The graduate explains how data, databases, and data management are used in today’s organizations.
- The Relational Model of Data: The graduate analyzes the relational model of data.
- The Fundamentals of SQL: The graduate implements SQL concepts and coding.
- Data Modeling: The graduate demonstrates an understanding of the concepts involved in the modeling of data.
- Normalization: The graduate demonstrates appropriate strategies to normalize data.
- Business Intelligence: The graduate interprets the concepts of analytical processing within the context of business intelligence.
Coronel, C., & Morris, S. (2017). Database systems: design, implementation, and management (12th ed.). Boston, MA: Cengage Learning. ISBN: 978-1-305-62748-2.