Database Administration II ITS 229AD

ITS 229AD advances students’ knowledge of database administration. In this class, students will learn how to configure a database server for multilingual applications. They will practice various methods of recovering the database using RMAN and Flashback technology. Database performance monitoring tools will be covered, in addition to the steps to take to resolve common problems and improve performance. Students will also learn how to administer a database efficiently by using database technologies such as the Resource Manager, the Scheduler, Automatic Storage Management (ASM), and VLDB features. They will set up a secure database using Virtual Private Database, and learn how to efficiently move data from database to database.

Correlated Learning Outcomes

  • IT. 12. Differentiate between public and private data.
  • IT. 13. Discuss applications of data analytics.
  • IT. 14. Discuss issues relevant to dealing with very large data sets, both structured and unstructured.
  • IT. 15. Identify database administration tasks.