APPLIED DATABASE III (4 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: Explain memory and space the Database; Demonstrate the tools in Oracle; Explain the Oracle architecture; Create the responsibility, backup, restore, and recovery in Oracle.

Topics:

1. Linux;
2. Exploring Oracle Database Architecture;
3. Oracle Database Management Tools;
4. Managing the Database Instance;
5. Configuring the Oracle Network Environment;
6. Administering User Security;
7. Managing Database Storage Structures;
8. Managing Space;
9. Managing Undo Data;
10. Managing Data Concurrency;
11. Implementing Oracle Database Auditing;
12. Backup and Recovery: Concepts;
13. Backup and Recovery: Configuration;
14. Performing Database Backups;
15. Performing Database Recovery;
16. Moving Data;
17. Database Maintenance;
18. Managing Performance;
19. Managing Performance: SQL Tuning;
20. Using Database Resource Manager;
21. Using Oracle Scheduler to Automate Tasks;
22. Introduction & Configuration for Backup Recovery;
23. Configuring RMAN for Recoverability;
24. Using the RMAN Recovery Catalog;
25. RMAN Backup Strategies and Terminology;
26. Performing Backups;
27. Improving Your Backups;
28. Using RMAN-Encrypted Backups;
29. Diagnosing Failures;
30. Restore and Recovery Concepts;
31. Performing Recovery I;
32. Performing Recovery II;
33. RMAN and Oracle Secure Backup;
34. Using Flashback Technologies;
35. Flashback Database;
36. Transporting Data;
37. Performing Point-in-Time Recovery;
38. Duplicating a Database.