Oracle Database 12c: Administration - Install and Upgrade (Accelerated)
The Oracle Database 12c: Administration Install and Upgrade (Accelerated) course is an intensive, hands-on program designed to equip participants with the skills required to install, configure, upgrade, and manage Oracle Database 12c environments efficiently. Oracle Database is developed by Oracle Corporation and Oracle Database 12c introduced major architectural innovations such as Multitenant (CDB/PDB), enhanced security, and improved manageability. This accelerated course focuses on practical administration tasks, enabling participants to quickly gain competence in deploying and upgrading Oracle databases in enterprise environments. The course emphasizes best practices, real-world scenarios, and streamlined administration techniques, making it ideal for professionals who need to manage Oracle installations and upgrades with minimal downtime and risk. Course Objectives By the end of this course, participants will be able to: Understand Oracle Database 12c architecture and components Install Oracle Database 12c software on supported platforms Create and configure databases using Oracle tools Understand Multitenant architecture (CDB and PDBs) Perform database upgrades from earlier Oracle versions Apply post-installation and post-upgrade best practices Manage basic administrative tasks securely and efficiently
Course Curriculum
1
- Overview of Oracle Database editions
- Key features of Oracle Database 12c
- Database architecture overview
- Administrator roles and responsibilities
2
- Oracle instance and database structures
- Memory architecture (SGA and PGA)
- Background processes
- Storage structures
3
- Hardware and software requirements
- Pre-installation planning and checklists
- Operating system configuration
- Oracle Optimal Flexible Architecture (OFA)
4
- Oracle Universal Installer (OUI)
- Silent and interactive installations
- Software-only installation
- Applying patches and updates
5
- Database Configuration Assistant (DBCA)
- Creating Container Databases (CDBs)
- Creating and managing Pluggable Databases (PDBs)
- Database templates and customization
6
- CDB and PDB concepts
- Managing PDB lifecycle
- Resource management in multitenant environments
- Common use cases
7
- Configuring database services
- Network configuration (Oracle Net)
- Listener configuration
- Security and user setup
8
- Upgrade planning and assessment
- Supported upgrade paths
- In-place vs out-of-place upgrades
- Pre-upgrade checks and tools
9
- Using Database Upgrade Assistant (DBUA)
- Manual upgrade overview
- Multitenant upgrade considerations
- Minimizing downtime during upgrades
10
- Post-upgrade validation
- Performance checks
- Updating statistics and recompiling objects
- Resolving upgrade issues
11
- Managing users and privileges
- Startup and shutdown procedures
- Monitoring database health
- Backup considerations (overview)
12
- Securing Oracle installations
- Password and privilege management
- Auditing basics
- Administrative best practices
13
- Common installation errors
- Upgrade failure scenarios
- Log file analysis
- Recovery strategies
14
- Installing Oracle Database 12c
- Creating CDBs and PDBs
- Performing a sample upgrade
- Validation and troubleshooting exercises
15
- Instructor-led classroom or virtual training
- Accelerated hands-on lab sessions
- Guided demonstrations and exercises
16
- Oracle Database Administrators (DBAs)
- System and infrastructure administrators
- IT professionals supporting Oracle environments
- Database engineers and technical support staff
17
- Basic understanding of databases and SQL
- Familiarity with operating systems (Linux/Unix or Windows)
- Prior Oracle exposure is beneficial
18
- Hands-on lab exercises
- Practical installation and upgrade tasks
- Knowledge checks and quizzes
This course includes
- 18+ Activity Modules
- 40 hours + lessons
- Lifetime access
- Certificate of completion
- Available on desktop and mobile
What Our Participants Say
Hear from participants who have experienced our training.
The facilitator’s wealth of experience was both striking and beneficial. He really helped translate concepts to real life.
The practical session where step by step of the lecture is broken down in visual and practice
I enjoyed the interactivity. It was also very direct, pointing out to us the key things to look for in the bidding, tender and proposal administration process, while also ensuri...
The practical session of the class which helped in giving a live run through of the necessary bidding and tender platform
The atmosphere was very pleasant, as it was an interactive and engaging session, which I personally enjoyed.
Some of Our Partners
