BCS 390: Database Administration and Security

This course provides the knowledge necessary to handle database administration and database security. Topics studied may include installation and configuration of a database, managing and securing user resources and privileges, data integrity, networking, optimization, and backup and recovery. Hands-on activities with a major commercial DBMS will be assigned to complement the lectures and written work and to develop practical skills.  Credits: 3.0

Prerequisite

BCS 260 and BCS 215 with a grade of C or higher.

Course Objectives

At the completion of this course, students will be able to do the following with representative commercial and open source database management systems:

• Install and configure the DBMS
• Start and stop database servers
• Create and manage user accounts
• Grant and revoke privileges
• Configure and manage data storage and log space
• Monitor storage usage
• Perform backups and restores of database data

Textbooks

• High Performance MySQL: Optimization, Backups, and Replication Third Edition, Schwartz, Zaitsev and Tkachenko. ISBN-13: 978-1449314286
• OCA Oracle Database 12c Installation & Administration Exam Guide (Exam 1Z0-062) (Oracle Press), by Watson. ISBN-13: 978-0071829236