Over five focused days, this compelling course enhances your technical understanding with the new features in Oracle 12cR2, 18c and 19c for non-container databases. It’s designed for experienced DBAs who want to handle upgrades better, sharpen performance and strengthen career progression.
Oracle Database 12cR2 - 18c and 19c New Features for Administrators
Handle complex Oracle database upgrades with confidence
This proactive five-day course gives you advanced practical experience with the most useful features in Oracle 12cR2, 18c and 19c. You’ll explore key changes and essential elements while learning how to apply new features for more efficient performance. If you’re looking to make smarter upgrade choices and run databases more smoothly, this course is ideal.
Learning objectives
- Install and upgrade to Oracle 19c
- Migrate data with Data Pump
- Use the latest RMAN tools
- Manage improved auditing and privileges
- Tune queries with new SQL tools
- Boost performance with in-memory features
- Work with better partitioning options
- Diagnose issues faster with TFA
What you’ll learn
Discover how to install Oracle Database 19c, create and configure databases, and prepare for upgrades. You’ll gain important practical skills in database creation, silent installations, and upgrade preparation to ensure efficient, secure and well-structured database environments.
Installation and upgrades
You’ll become proficient in being able to install Oracle 19c using both the graphical interface and silent modes. We’ll guide you through planning, pre-checks and setting environment variables so your setup is clean from the start. You'll also work with the Database Upgrade Assistant (DBUA) and Oracle’s AutoUpgrade tool, helping you streamline future upgrades with efficiency. There’s plenty of hands-on time to practise what you’re learning, so you leave the course ready to carry out upgrades on your own systems with confidence.
Security and auditing
We’ll guide you through how to make the most of Oracle’s improved auditing and security features, including unified auditing policies, privilege analysis and schema-only accounts. You’ll understand how to lock down inactive users, use SYSRAC properly and even export your audit trails with Data Pump. You’ll be able to focus on making sure your system is secure and compliant without slowing down work projects. This course explores the latest developments and how to make your database environment more secure for strong project management.
Performance tuning
This course enables you to examine how to make your database run more smoothly. You’ll work with tools like the Optimiser Statistics Advisor, explore adaptive query optimisation and see how new automatic indexing features can save you time. We’ll also show you how to make smarter decisions about SQL plans and give you the confidence to apply tuning techniques in real-world situations. By the end of the course, you’ll be able to recognise slow queries and learn how to avoid them for improved system performance.
What’s included
- 5 days of live virtual instructor-led training
- Live labs in a real Oracle environment
- Step-by-step practical exercises
- Course materials for future reference
- Access to session recordings after the course
- Expert trainers with real-world Oracle experience
- Certificate of completion
- Small groups for more personal support
Key facts
Ideal for
DBAs who already know their way around Oracle 12.1 and want to become familiar with newer versions.
Prerequisites
You should have hands-on experience with Oracle Database 12.1 administration tasks and be comfortable working in a Linux or UNIX environment.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one. (Do not change this copy)
FAQs
Over a thorough five days, this course guides you through the latest updates in Oracle 12cR2, 18c and 19c. It’s particularly relevant for DBAs who want practical experience applying new features across real administration tasks.
Will this course help me plan an upgrade to Oracle 19c?
Yes, absolutely. We cover both manual and automated upgrade methods using tools like AutoUpgrade and DBUA. You’ll also learn how to handle pre-checks, test planning and the signs of any potential issues. Whether you're moving from 12.1 or an earlier 12c version, this course gives you the knowledge to plan and carry out the upgrade smoothly.
Does this course focus on container databases or pluggable databases?
Not in detail. You’ll have a quick overview of multitenant architecture, but the main focus is on non-container database features in 12cR2, 18c and 19c. If you're looking for deep coverage on containers and pluggables, we’d recommend our Oracle Multitenant Administration course instead.
How does this course address performance and security enhancements?
You’ll explore new Oracle features for performance tuning, including Optimiser Statistics Advisor and adaptive query optimisation, alongside enhanced security tools such as Unified Auditing, Privilege Analysis and Transparent Data Encryption (TDE).
Will I learn how to migrate databases between different versions of Oracle?
Yes. The course covers multiple migration techniques, including using Data Pump, transportable tablespaces and network-based imports. You’ll practise moving data between different Oracle versions and platforms, enabling you to handle migrations confidently in your workplace.
What our customers say
‘Very well laid out and John does an amazing job of explaining things in detail.’
Ali, Operations Technical Service Analyst - Utilities
‘This is now my second course with John at StayAhead and once again the delivery was simply excellent. I was a little bit worried coming in that I wouldn't have the requisite knowledge; however, I found that it was just about the perfect level between being able to understand the concepts and stretching the grey matter.’
Ashley, AppOps Engineer (Jr DBA) - 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