Our course equips database administrators with practical skills to install Grid Infrastructure, configure databases and upgrade earlier releases in Oracle 18c environments. Aligned with the official Oracle Database curriculum, it also supports your preparation for the Oracle Database Administration II: 1Z0-083 certification exam.
Oracle Database 18c Install & Upgrade
Optimise Oracle 18c environments with expert installation and upgrade skills
Over two days, you’ll gain the expertise to install Grid Infrastructure, configure databases and upgrade from earlier releases. You’ll also learn about key tools such as DBCA, Oracle Restart and Data Pump, helping you streamline installations, optimise upgrades and ensure robust, efficient Oracle database environments.
Learning objectives
- Explain multitenant architecture for efficient database management
- Install Grid Infrastructure for standalone Oracle environments
- Deploy Oracle Database software in interactive and silent modes
- Create databases with DBCA using interactive or silent modes
- Manage database components effectively with Oracle Restart
- Prepare, plan and perform database upgrades using DBUA or manually
- Complete post-upgrade tasks to optimise performance and stability
- Transfer and import data using Data Pump
What you’ll learn
During this Oracle Database 18c Install & Upgrade course, you’ll develop the expertise to install Grid Infrastructure, configure and create databases, and perform upgrades from earlier releases. You’ll also manage data migrations, optimise performance, ensure stability, and adapt systems to meet changing business demands.
Installing Oracle 18c software
Gain the skills to install Oracle Database 18c using the Oracle Universal Installer (OUI). You’ll perform pre-installation checks, set environment variables, and configure Oracle Inventory. You’ll also learn both interactive and silent installations, plus de-installation, ensuring you can deploy Oracle software efficiently and troubleshoot issues to maintain smooth, reliable database operations.
Database configuration with DBCA
Learn to create and configure Oracle Database 18c environments using the Database Configuration Assistant (DBCA). You’ll choose architecture types, storage options, and character sets, applying both interactive and silent modes. This course will also teach you how to quickly set up tailored, stable databases that meet your organisation’s performance, development, and production needs.
Preparing and planning for an upgrade
Develop the expertise to prepare for a seamless upgrade to Oracle Database 18c during this course. You’ll learn how to run pre-upgrade checks, assess compatibility, and plan the upgrade process for minimising downtime. Gain the skills to confidently move from earlier releases while maintaining database integrity, performance, and business continuity.
Performing upgrades with DBUA and manual methods
Understand both automated and manual upgrade techniques for Oracle Database 18c with this course. You’ll use the Database Upgrade Assistant (DBUA) in interactive and silent modes, as well as manual upgrade commands, to ensure flexibility and control. These skills will help you manage upgrades effectively within diverse operational environments.
What’s included
- Two days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
Key facts
Ideal for
Database administrators who need to install and configure Oracle 12cR2 or 18c, or upgrade earlier releases, while optimising database performance and reliability.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one
FAQs
This Oracle Database 18c Install & Upgrade course develops skills in installation, configuration, upgrades, and data migration, helping you optimise performance, maintain stability, and meet evolving organisational database requirements
Who should attend this course?
Our course is ideal for database administrators who need to install, configure, or upgrade Oracle 12cR2 or 18c databases. It’s also suitable for those managing migrations and performance tuning, and who want to strengthen their skills for professional advancement or certification preparation.
Does the course cover database upgrades from earlier versions?
Yes. The course includes planning, preparing, and performing upgrades to Oracle Database 18c from earlier versions. You’ll learn to use the Database Upgrade Assistant (DBUA) in interactive and silent modes, as well as manual upgrade methods, to suit different operational environments.
What operating system is used in the training?
The course is delivered on a Linux operating system to reflect real-world database environments. While basic Linux/UNIX knowledge is recommended, it is not essential, as all required commands and concepts are explained during the course.
What are the benefits of attending this course?
You’ll gain the expertise to install and configure Oracle databases, perform upgrades, manage migrations, and maintain optimal performance. These skills are critical for keeping business systems secure, stable, and responsive, enabling faster innovation and minimal disruption during change. It also helps Database Administrators improve operational efficiency and reduce downtime, helping you deliver measurable value to your organisation and advance your career.
What our customers say
"Great course. Alan has been courteous and informative throughout. Highly recommended, and will absolutely be coming back for more courses.”
Bradley, Software Engineer - Government
“John made the subject matter interesting. The pacing was spot on and he clearly knew what he was talking about and was able to communicate that easily. Very pleased and would highly recommend.”
Gavin, Government
Why study with StayAhead
96% customer satisfaction
We combine experience and passion to deliver training that meets the highest standards
30+ years’ experience
Industry-leading specialists delivering high-impact IT training
Experiential instructor-led training
Courses are delivered by experienced instructors using hands-on, practical live labs