Course Brief

The aim of this course is to introduce more advanced database concepts and provide the necessary knowledge and practical skills of creating and maintaining the database including database objects and data. It also teaches how to protect the database by designing a backup and recovery strategy; diagnose and tune common database performance problems.

  • This course is offered in 90 hours

On completing this course successfully you will be able to:

  • Critically evaluate the concepts and tools of the database management system.
  • Demonstrate systematic knowledge of the database architecture.
  • Design database backup and recovery strategy.
  • Develop critical awareness of issues relating to database management and practical skills to solve common database administration problems.

Exploring the database architecture; Creating the database; Managing the database instance; Managing database storage structures; Managing transactional processing and locking mechanism; Database security; Monitoring the database and using the advisors; Backup and recovery concepts; Investigating, reporting, and resolving problems.

Exam – 80%, Coursework – 20%, Pass mark 40%.