Applied Database III

Learning Outcomes

By the end of this course, the students will be able to: Explain memory and space the Database; Demonstrate the tools in Oracle; Explain architecture Oracle; Create the responsibility, backup, restore, and recovery in Oracle

Topics

1. Linux
2. Introduction & Installing the Oracle Database Software
3. Creating an Oracle Database & Managing the Instance
4. Managing Database Storage Structures & Administering User Security
5. Managing Schema Objects
6. Managing Data and Concurrency
7. Managing Undo Data & Implementing Oracle Database Security
8. Configuring the Oracle Network Environment
9. Proactive Maintenance
10. Performance Management
11. Backup and Recovery Concepts & Performing Database Backups
12. Performing Database Recovery
13. Performing Flashback & Moving Data
14. Introduction Admin II & Configuring Recovery Manager
15. Using Recovery Manager
16. Database Recovery & Flashback
17. Dealing with Database Corruption & Monitoring and Managing Memory
18. Automatic Performance Management
19. Managing Schema Objects & Managing Storage
20. Automatic Storage Management
21. Managing Resources
22. Automating Tasks with the Scheduler
23. Database Security
24. Using Globalization Support & Workshop