Course Details:
Oracle Database 12c Administration Work Shop I
This Oracle Database 12c : Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle instructor will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.
Learn To:
â?¢ Install Oracle Database Software
â?¢ Create and manage users.
â?¢ Install and configure an Oracle Database.
â?¢ Create and manage storage structures.
â?¢ Administer the Oracle Database.
â?¢ Understand the Oracle database architecture and how its components work and interact with one another.
â?¢ Perform backup and recovery.
Oracle Database 12c: Administration Workshop I is an instructor-led course featuring lecture and hands-on exercises. Online demonstrations and written practice sessions reinforce the concepts and skills introduced, along with industryâ??s best practices.
Software's for Oracle DB on Linux using virtualization
1. Oracle Virtual Box
2. Oracle Linux 7.4 OS
3. Oracle Database for Linux 12c R2
4. Winscp
5. Putty
6. Xming
course content
1. Introduction.
2. Installing the Oracle Database Software
3. Creating an Oracle Database
4. Managing the Oracle Instance
5. Managing Database Storage Structures
6. Administering User Security
7. Managing Schema Objects
8. Managing Data and concurrency
9. Managing Undo Data
10. Implementing Oracle Database Security
11. Configuring the Oracle Network Environment
12. Proactive Maintenance
13. Performance Management
14. Backup and Recovery Concepts
15. Performing Database Backups
16. Performing Database Recovery
17. Performing Flashback
18. Moving Data