COMP 305: Database Administration

Business and scientific institutions increasingly use large commercial data base systems. This course teaches the theory and practice for the definition, security, backup, tuning, and recovery of these systems.

Credit Hours

3

Description

Businesses and scientific institutions have started using commercial grade database servers increasingly. Hence it has become important to install, configure, and manage the servers in an efficient manner to increase productivity. A number of tasks involved in maintaining a database server is quite different from say administering a computer system or a network. Deeper knowledge of the storage aspects of the server and how different server processes work are needed for successful administration of the server. Typically, the database administrator cares for security of data, backup and recovery, and space management. This course takes a user through the stages of setting up a database server environment, to design of a database, and finally tuning.

Outcome

Students will be able to use theory and pragmatic approaches to define and implement realistic solutions for large database administration environments.

Syllabi

Semester/Year Instructor URL
Spring 2014 Dr. Dordal https://luc.box.com/s/xtuvk5iqlqrchhe2y8u3rtu8z89xui0u