On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(International 01) 908.233.8900
  400+ Course Offerings:


Search for Course:

OR5510 Oracle Database Administration
 
 
Duration 5 Days
Delivery Method Instructor Led, Hands-on Workshops
Public Price $2950.00


DESCRIPTION (Return to Top)

This course provides students with the skills needed to administer and maintain an Oracle database. Included in the course are detailed instructions on the facilities available for database design, administration, and daily operation including user management and logical backup and recovery. The issues involved in creating a new instance and database are also presented. The Data Dictionary is examined in detail to create an awareness among participants of the wealth of system information available to the informed user of the system. Dynamic performance tables are also examined to provide access to additional information about a database and instance.

Numerous workshops serve to reinforce and expand upon topics presented during lectures.

This course can be taught for any Oracle version.



AUDIENCE (Return to Top)

Database Administrators responsible for the administration of an Oracle database.



TOPICS (Return to Top)
  • Overview of Oracle Architecture
  • Manageability Features
  • Tablespaces & Data Files
  • User Administration
  • Tables
  • Indexes
  • Clusters
  • Documenting Objects
  • Synonyms
  • Sequences
  • Views
  • Managing UNDO Data
  • Utilities
  • Resumable Space Allocation
  • Online Data Evolution
  • Overview of Oracle’s Client-Server Architecture


PREREQUISITES (Return to Top)

OR5450 Oracle SQL or equivalent experience.