Oct 04, 2023  
2018-19 Catalog 
2018-19 Catalog [ARCHIVED CATALOG]

Add to Favorites (opens a new window)

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

Add to Favorites (opens a new window)