Oracle DBA Syllabus

I am interested in the field of Database and decided to do Oracle DBA certification want details related to this Oracle DBA course. Will you please provide me complete Syllabus for Oracle DBA and also provide me name of some books for this Oracle DBA?

[Kiran Chandar]

Oracle Database also known as Oracle RDBMS or simply as Oracle is an object-relational database management system produced and marketed by Oracle Corporation.

The Oracle Certification Program, a professional certification program, includes the administration of Oracle Databases as one of its main certification paths.

It contains three levels:

Oracle Certified Associate (OCA)
Oracle Certified Professional (OCP)
Oracle Certified Master (OCM)

Syllabus for Oracle DBA:

1. Introduction
2. SQL *PLUS Overview
3. Modifying Data
4. Managing Constraints
5. Managing Views
6. User Access and Security
7. Oracle Overview and Architecture
8. Managing Oracle
9. Control and Redo Log Files
10. Managing Tables, indexes and Constraints
11. Managing Users and Security
12. Introduction to Network Administration
13. Backup and Recovery Overview
14. Introduction to performance tunin

Oracle DBA Syllabus






Some text books for this course:

1. [CD] C.J. Date, Database Systems, Addison Wesley, 2000

2. [BT] Chip Dawes, Biju Thomas, Introduction to Oracle 9i SQL, BPB, 2002

3. [BB] Bob Bryla, Biju Thomas, Oracle 9i DBA Fundamental I, BPB, 2002

4. [DS] Doug Stums, Matthew Weshan, Oracle 9i DBA Fundamental I, BPB, 2002

5. [JJ] Joseph C. Johnson, Oracle 9i Performance Tuning., BPB, 2002