Course Description
Provides a basic understanding of data management in organizations and, specifically, the design and use of database systems. Main topics include data modeling, relational databases, structured query language, database structure, storage, and integrity. In addition, recent developments related to big data (and tools for their analysis) will be introduced.
Athena Title
Database Management
Equivalent Courses
Not open to students with credit in or MIST 7600
Non-Traditional Format
This course will be taught 95% or more online.
Prerequisite
CSCI 1301-1301L or permission of department
Semester Course Offered
Offered fall
Grading System
A - F (Traditional)
Course Objectives
Upon successful completion of this course, students will be able to: 1. understand the organizational issues involved in data management 2. develop a valid data model for a business system of medium complexity 3. build and use a normalized relational database 4. formulate complex relational database queries 5. understand the different data structures and recommend one 6. understand the different data storages and recommend one 7. manage and use spatial and temporal databases 8. understand data integrity and how to maintain it 8. discuss issues related to managing "big data" 9. use R for data analtyics 10. use R for data visualization and dashboards
Topical Outline
1.The organizational perspective on data management 2.Data modeling 3.Relational DBMS 4.Structured query language 5.Data structure and storage 6.Spatial and temporal databases 7.Data integrity 8.Big data 9.Introduction to R 10.Data visualization and dashboards
Syllabus