Prerequisites: COMP 400B.
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.
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.
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.
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.