This course prepares students with a firm foundation in basic database administration. It focuses on database administration (DBA) skills in general and specific skills needed to manage an enterprise level, large scale, relational database management system such as Oracle. The course takes a look at concepts underlying a database administration, among which are the database architecture, installation, configuration and operation. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, DBMS tuning and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices. This course prepares students for the corresponding certification examination (such as Oracle Certified Associate exam). This course will also expose students to industry’s experiences in administrating databases through sharing knowledge sessions and work-based learning activities with selected organization.
