After completing this lesson, you should be able to do the following: • List the course objectives and explain the class structure • Review the Oracle Database 10g architecture | Introduction Lesson Objectives After completing this lesson, you should be able to do the following: List the course objectives and explain the class structure Review the Oracle Database 10g architecture Course Objectives In this course, you gain experience in: Using Recovery Manager (RMAN) for advanced backup and recovery Employing database monitoring practices for memory, performance, and storage Managing resources, job schedules, security, and globalization issues Suggested Schedule 1: Introduction 2: Configuring RMAN 3: Using RMAN 4: Non-Critical Recovery 5: Recovery 6: Flashback 7: Corruption 8: Memory 9: Performance 10: Schema 11: Storage 12: ASM 13: Resources 14: Scheduler 15: Security 16: Globalization 17: Workshop Appendixes What Is Covered in the DBAI Course 1. Introduction 2. Installation 3. DB Creation 4. Instance 5. Storage 6. Users 7. Schema 8. Data & Concurrency 9. Undo 10. Security 11. Network 12. Proactive Maintenance 13. Performance 14. Backup & Recovery Concepts 15. | Introduction Lesson Objectives After completing this lesson, you should be able to do the following: List the course objectives and explain the class structure Review the Oracle Database 10g architecture Course Objectives In this course, you gain experience in: Using Recovery Manager (RMAN) for advanced backup and recovery Employing database monitoring practices for memory, performance, and storage Managing resources, job schedules, security, and globalization issues Suggested Schedule 1: Introduction 2: Configuring RMAN 3: Using RMAN 4: Non-Critical Recovery 5: Recovery 6: Flashback 7: Corruption 8: Memory 9: Performance 10: Schema 11: Storage 12: ASM 13: Resources 14: Scheduler 15: Security 16: Globalization 17: Workshop Appendixes What Is Covered in the DBAI Course 1. Introduction 2. Installation 3. DB Creation 4. Instance 5. Storage 6. Users 7. Schema 8. Data & Concurrency 9. Undo 10. Security 11. Network 12. Proactive Maintenance 13. Performance 14. Backup & Recovery Concepts 15. Backup 16. Recovery 17. Flashback 18. Moving Data What Is Covered in the DBAI Course DBAI refers to the Oracle Database 10g: Administration Workshop I (Release 2) course. Course Examples: The HR Schema REGIONS REGION_ID (PK) REGION_NAME COUNTRIES COUNTRY_ID (PK) COUNTRY_NAME REGION_ID (FK) LOCATIONS LOCATION_ID (PK) STREET_ADDRESS POSTAL_CODE CITY STATE_PROVINCE COUNTRY_ID (FK) DEPARTMENTS DEPARTMENT_ID (PK) DEPARTMENT_NAME MANAGER_ID LOCATION_ID (FK) JOBS JOB_ID (PK) JOB_TITLE MIN_SALARY MAX_SALARY EMPLOYEES EMPLOYEE_ID (PK) FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID (FK) SALARY COMMISION_PCT MANAGER_ID (FK) DEPARTMENT_ID (FK) JOB_HISTORY EMPLOYEE_ID (PK) START_DATE (PK) END_DATE JOB_ID (FK) DEPARTMENT_ID (FK) REGIONS COUNTRIES LOCATIONS DEPARTMENTS JOBS EMPLOYEES JOB_HISTORY Course Examples: The HR Sample Schema The examples used in this course are from a human resources (HR) application, which can be created as part of the starter database. The following are some .
