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

Farmingdale State College

934-420-2000
Monday-Friday 8:30am-4:30pm