Database Administration
Knowledge of the configuration and management skills needed for successful administration of a database server. The database administrator manages hardware, backup, security, tables and indexes, performance monitoring, query performance and optimization, and transaction performance. This course takes a user through the stages of maximizing the performance of a database server.
Prerequisite: COMP 251 or COMP 271.
Outcomes: Students will learn how to manage database performance, including topics such as the query optimizer, SQL EXPLAIN, table statistics, concurrency and transaction isolation levels, and security.
Prerequisite: COMP 251 or COMP 271.
Outcomes: Students will learn how to manage database performance, including topics such as the query optimizer, SQL EXPLAIN, table statistics, concurrency and transaction isolation levels, and security.