Sep 28, 2023  
2018-19 Catalog 
2018-19 Catalog [ARCHIVED CATALOG]

Add to Favorites (opens a new window)

DBA 232 - Database Administration

5 CR

Develops the concepts and skills required to perform the duties of Database Administrator (DBA) in organizations using large relational databases. Students develop coherent plans for security, disaster recovery, backup and restore, replication and other administrative functions, including the creation and use of SQL scripts to automate administrative tasks.

Prerequisite(s): DBA 130  with a C- or better. Placement by assessment into ENGL 101  or ENGL 092  or ENGL 093  with a C- or better.

Course Outcomes

  • Describe the SQL Server architecture.
  • Evaluate an installation plan to install SQL Server, and its related services.
  • Configure related components and manage files and databases.
  • Select the appropriate security scheme for a business situation and configure security and permissions.
  • Develop a backup plan for production databases.
  • Use industry best practice to establish database policy and documentation.
  • Monitor and maintain SQL Server performance.
  • Explain the role of disaster recovery and high availability.

Find out when this course is offered

Add to Favorites (opens a new window)