5 credits
The database administrator plays an integral role in ensuring that the information on which organizations rely is organized, efficient, and secure. In this course, students identify the range of tasks a database administrator performs, including disaster recovery, performance analysis and tuning, data dictionary maintenance, data modeling and optimization, and database and user management and monitoring. They also assess the techniques, tools, and best practices used in managing a relational database. Students apply concepts presented in the course to practical exercises involving installation, management, performance monitoring, creation of users and user privileges, backup, and recovery.