INT-2080 Fundamentals of Database Management

Credits: 3
Fundamentals of Database Management gives students a solid foundation in the fundamental concepts of relational database management. Students are introduced to database architecture, data migration and recovery, high availability techniques, database performance tuning, and basic database security tasks. Students will be able to install and configure relational database server and also run queries to retrieve data from the database. Upon completion of this course, students will be prepared to take Oracle’s MySQL Database Professional exam. This course may also be taken as TEC-533, Fundamentals of Database Management-Oracle Certified Professional.

Prerequisite(s): INT-1111.

Course Outcomes

Describe relational database architecture.
Perform basic database security tasks.
Implement database performance tuning.
Describe database high availability techniques.
Install a relational database on Linux and Windows operating systems.
Utilize metadata to diagnose performance problems.
Perform data migration from one mysql database location to another
Perform data recovery database backup