ITEC474 -Database Administration in ORACLE

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.