Go back:

Keehyung Kim | University of Oklahoma

Courses

<aside> <img src="/icons/megaphone_gray.svg" alt="/icons/megaphone_gray.svg" width="40px" /> Welcome to “Database and Big Data Management”! 😊

This course was taught by me between 2017 and 2023 for Masters students enrolled in MSc in Business Analytics, MSc in Information Technology Management, and MBA programs at CUHK Business School. Note that only part of the course materials are shared here. Some materials were offered exclusively to enrolled students. Also, some materials here might be outdated by now.

If you use any part of the materials, please kindly reference this site (http://keehyung.com) and the author (Keehyung Kim). Enjoy!

</aside>

Course Instructor


Course Description


This course focuses on both traditional business data and contemporary big data modelling and management. We will examine the different natures of traditional data and big data, selection and representation as well as use of suitable methods and tools for storing and accessing them. Topics such as DBMS, Relational Data Modeling, SQL, Big Data, NoSQL, and Data Visualization are covered.

Specifically, we will achieve the following goals: (1) Discuss database design and data management in the context of relational systems and big data (2) Develop competence in data modeling with Entity-Relationship Diagram (ERD) (3) Gain hands-on experiences with database systems management using MySQL (4) Introduce NoSQL and big data management through hands-on exercises using MongoDB (5) Understand the difference between relational database and NoSQL, and their real-world applications

Please check “Course Outline” pdf file for more details.

Course Schedule & Contents


#1: Course Introduction

#2: Conceptual Data Modeling with Entity-Relationship Diagram (ERD)