DBA 233 - Advanced Database Administration

5 CR

Provides students with advanced concepts and hands-on practice in database administration. Topics include: creating and managing indexes, multi-user issues (locks, data integrity), replication, data warehousing, data analysis services, advanced Data Transformation Services, full text search and English query.

Prerequisite(s): DBA 232 with a C- or better or entry code.

Course Outcomes

Define the role of indexes in optimizing database performance (clustered, non-clustered and columnstore)
Use advanced options to maintain SQL Server Identify and resolve concurrency problems by analyzing troubleshooting data
Describe and evaluate disaster recovery plans
Describe and evaluate high availability plans
Use SQL Server for data analysis and reporting

Find out when this course is offered