Oracle Database Administration

Categories: DATABASES
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

The objective of this course is to provide the day-to-day administration tasks required of an Oracle database administrator. This range from backup and recovery strategies, database performance tuning, security administration and the like.

Whenever appropriate this textbook demonstrates how an Oracle database installation integrates with its host environment, most commonly a Linux, Unix or MS Windows operating system platform. Extensive examples, workshop exercises and solutions are provided using the SQL command-line, the Enterprise Manager Database Express and the Enterprise Manager Cloud Control interfaces.

Course Content

Introduction: Managing The Database Instance

Introduction: Database Architecture Review

Introduction: Starting & Stopping Database Services

Introduction: Oracle Network Environment

Introduction: Diagnostics & Oracle Support

Storage: Tablespace Management

Storage: Advanced Tablespace Management

Storage: Data Files & Temp Files Management

Storage: Undo Data & Undo Tablespaces

Security & Schemas: Security Overview & Database Privileges

Security & Schemas: User Security

Security & Schemas: Database Auditing

Security & Schemas: Export & Import

Performance & Availability: Managing Performance & SQL Tuning

Performance & Availability: Data Concurrency

Performance & Availability: Backup & Recovery Concepts