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
Some of Our Partners
