INFO.4530 Database Administration II: Advanced Oracle 11g (Formerly 90.453)

Description

Building upon the skills students learned in Database Administration I, this course focuses on advanced concepts of managing enterprise-scale Oracle 11g databases. Students are introduced to advanced concepts used to analyze, troubleshoot, and resolve performance, backup and recovery, and configuration-related problems. Students closely examine Oracle 11g diagnostic, resource and data protection methodologies including interrogating dynamic and static system views, alert log, thresholds and traces, 11g flashback of critical/non-critical data, 11g automatic storage management, 11g automatic shared memory tuning, and 11g data pump import and export utilities. Students will also utilize the 11g Enterprise Manager Database and Grid Control web-based interface to perform advanced database maintenance and configuration Successful completion of this course prepares students for the Oracle Database Administration II certification exam and also qualifies as an oracle 11g DBA OCP Hands-On Approved Course. Prerequisite: 90.450 or related experience. Credits: 3.0

Course prerequisites/corequisites are determined by the faculty and approved by the curriculum committees. Students are required to fulfill these requirements prior to enrollment. For courses offered through online or GPS delivery, students are responsible for confirming with the instructor or department that all enrollment requirements have been satisfied before registering.