Brief Course Description
1. Course Title:
Database Management System
2. Language of Instruction:
Tiếng Việt
3. Course Code:
TEC550032
4. Credits:
3
5. Course Objectives:
The objective of this course is to equip students with fundamental knowledge of database management systems (DBMS) by helping them understand the basic concepts and main components of DBMS, as well as master the methods of data storage organization and index structure. Students will be trained in query processing and optimization skills through the application of algorithms and concurrency control techniques, along with data recovery methods. In addition, the course also helps students develop the ability to design and manage Datawarehouse, using OLAP techniques to analyze and process data. Students will learn how to apply MapReduce and Hadoop in processing big data, including both structured and unstructured data, to improve their skills in advanced data computing. In particular, the course deals with transaction processing techniques and concurrency control management, as well as data recovery methods in multi-user application environments. The ultimate goal of the course is to help students become database professionals with the ability to effectively manage, optimize and analyze data in a modern business environment.
6. Brief Description of Course Content:
This course provides knowledge of the concepts and practical problems associated with database management systems. Course content includes relational database modeling (callback) and extensible query language, modeling, Datawarehouse design, OLAP techniques. Data-intensive computation with MapReduce/Hadoop (structured and unstructured data). The course then addresses issues and techniques for dealing with multi-user application environments: transaction processing problems, concurrency control, and data recovery problems.