Oracle Database Administration

Oracle Database Administration introduces Oracle database administration concepts, including database architecture, environment, management, networking, storage, security, maintenance, performance, and backup and recovery.

This course comprises 14 lessons covering Oracle database administration. Each lesson includes a combination of Wikipedia and Oracle readings, YouTube videos, and hands-on learning activities. The course also assists learners in preparing for Oracle Database Administration I certification.

Preparation

This is a third-semester, college-level course. Learners should already be familiar with Oracle SQL Fundamentals.

Lessons

1. Environment
2. Instances
3. Network
4. Architecture
5. Storage
6. Undo Data
7. Data Concurrency
8. User Security
9. Database Security
10. Maintenance
11. Performance
12. Moving Data
13. Backup and Recovery
14. Support

See Also

• Oracle SQL Fundamentals
• Oracle: Database 2-Day DBA (HTML) (PDF)
• Oracle: Database 2-Day + Security Guide (HTML) (PDF)
• Oracle: Database 2-Day + Performance Tuning Guide (HTML) (PDF)

References

• Oracle: Database 11g: Administration I Exam Topics
• Watson. OCA Oracle Database 11g Administration I Exam Guide: Exam 1Z0-052. Oracle Press. ISBN 9780071591027