MGT6790
Applied Database Management
This course will explore the foundations of database management to support organizational and administrative processes. A variety of crucial topics will be addressed. Topics may include the following: the concept of database management systems (DBMSs); DBMS security, integrity, recovery, and concurrency considerations; DBMS data models; data manipulation; and database design. Principles studied will be reinforced through application as students will build, populate, and query a database.
PREREQUISITE:
NONE
COURSE COMPETENCIES:
UPON COMPLETION OF THE COURSE, THE STUDENT WILL BE COMPETENT IN:
- Understanding data concepts in a database management system (DBMS) environment.
- Comparing and contrasting the different types of database management systems (DBMS) that exist.
- Understanding all aspects of the database development process.
- Understanding the needs and concerns related to different database environments.
- Applying modern database management principles to develop and implement a database system using appropriate technology.
- Applying modern database management principles to perform database functions.
- Describing the implementation of database concepts within database systems.
- Comparing and contrasting the popular database management systems that exist to include Microsoft Access, MySQL, and MongoDB among others.
- Understanding the linkage between databases and data analytics.