► ProgramsOracle Database 11g: Administration Workshop I

Oracle Database 11g: Administration Workshop I

Overview

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students 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, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

Prerequisites

  • Working knowledge of SQL
  • Oracle Database 11g:  Introduction to SQL
  • Performance-Based Objectives
  • Describe Oracle Database Architecture
  • Install and configure Oracle Database 11g
  • Configure Oracle Net services
  • Manage the database storage structures
  • Create and administer user accounts
  • Perform basic backup and recovery of a database
  • Manage users and schemas
  • Manage data and concurrency
  • Monitor and administer undo data
  • Backup and recover a database
  • Monitor performance
  • Use the database diagnostic monitor

Certification Exam

This course is designed to prepare students to become an Oracle Database 11g Administrator Certified Associate.

Schedule

14 days

Alert Me

If you would like to be notified of future classes for this course, please click on Alert Me and complete the short form.

Group Training Available

UMBC Training Centers can deliver any of our courses in a group training environment at our facilities or yours. Group training can be an effective and economical method to quickly assure competency and consistency of knowledge and skills within an organization or department.
© 2014 UMBC Training Centers, 6996 Columbia Gateway Drive, Suite 100, Columbia, MD 21046 ipR.gif 443-692-6600