The main aim of this
course is to provide advanced database management topics using a technology
component for database administration. The advanced database management topics
consist of discussion lectures on advanced areas of database management in
industry. The technology component focuses mainly on Oracle tools for database
administration and advanced database management SQL commands. The course covers
architecture of a DBMS, responsibilities and tasks of a DBA, installation,
logical DB layouts, physical DB layouts, query processing, indexing, and
transaction management, data concurrency, logging, managing the development
process, user security , flashback recovery and backup / recovery.
