This five-day immersive course from ILX guides you through the essential new features in Oracle 12cR2, 18c and 19c. Aimed at experienced DBAs, it's perfect for those looking to manage upgrades with ease and get more out of their Oracle environments.Â
15% off eLearning, up to 20% off virtual courses - use code: NSWOCT25USA
View courses
f1c0f0ce-eab8-4581-944d-184cabbdbded
Oracle Database 12cR2 - 18c and 19c New Features for Administrators
Select your learning method
Learn essential skills
Course overview
Master Oracle Database creation, configuration and upgrade preparation
Learn how to use the most useful updates in Oracle 12cR2, 18c and 19c over five focused and engaging days. This expert-led, practical course shows you the latest Oracle Database changes and how to apply key aspects in your own systems. Ideal if you’re looking to upgrade smoothly and improve Oracle performance.Â
Learning objectives
- Install and configure Oracle Database 19cÂ
- Create and manage container and non-container databasesÂ
- Perform upgrades using DBUA and AutoupgradeÂ
- Migrate databases with Data Pump and transport methodsÂ
- Implement enhanced auditing and privilege managementÂ
- Utilise new RMAN backup and recovery featuresÂ
- Optimise SQL with advanced performance toolsÂ
- Apply updated partitioning strategies and optionsÂ
- Leverage in-memory features for faster queriesÂ
- Diagnose issues with Trace File AnalyzerÂ
What you’ll learn
On this course, you’ll explore Oracle Database 12cR2, 18c and 19c’s most impactful new features through practical, real-world scenarios. From installing and upgrading databases to fine-tuning performance, securing data, and troubleshooting issues, you’ll leave confident in applying these tools directly in your environment.Â
Data tools and movement
You’ll gain valuable experience with Oracle’s data movement tools: Data Pump, SQL*Loader and external tables, and learn how they’ve improved in recent versions. Whether you’re shifting a whole database or just a few key tables, we’ll guide you through how to complete these actions quickly and reliably. You’ll learn how to use new features that make moving data easier and save time on more complex jobs. With guided labs and clear examples, you’ll leave knowing how to tackle migrations and data transfers confidently, using tools you’ll likely need for current or future projects. Â
Diagnostics and availability
Keeping things running smoothly is easier when you know how to spot problems early. In this part of the course, you’ll get to grips with Trace File Analyser and Oracle’s updated diagnostic tools. We’ll show you how to use RMAN more effectively and take advantage of the latest Data Guard updates to boost your system’s reliability. From tracking down issues to planning smarter backups, you’ll come away knowing how to keep your environment healthy, and what actions to take when a potential issue arises. Â
Further performance features
You’ll explore the efficacy of tools like the Optimiser Statistics Advisor, adaptive query optimisation and auto indexing, all designed to save you time and reduce delay across workflows. You’ll learn how to spot performance issues and fix them before they become a problem, using features built into the latest Oracle releases. With clear explanations and real examples, we’ll help you build a toolkit you can rely on, whether you’re fixing slow queries or planning improvements.Â
What’s included
- Five days of live, online trainingÂ
- Hands-on practice using real Oracle lab environmentsÂ
- Step-by-step exercises to build your confidenceÂ
- Course materials you can keep and use for future projectsÂ
- Access to recorded sessions after the courseÂ
- Trainers who’ve worked with Oracle in the real worldÂ
- ILX certificate of completionÂ
- Small group sizes Â
Key facts
Ideal for
DBAs who’ve worked with Oracle 12.1 and want to become more familiar with new elements in 12cR2, 18c and 19c, especially if you’re responsible for upgrades or day-to-day database management.Â
Prerequisites
You should have some hands-on experience with Oracle Database 12.1 administration tasks and feel comfortable using Linux or UNIX. Â
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 ILX-led, five-day live virtual classroom course equips experienced DBAs with the knowledge to implement and manage the most valuable new features in Oracle Database 12cR2, 18c and 19c, with a strong focus on real-world application.Â
Is this course only for people doing upgrades?
Not at all. While it’s great for anyone planning an upgrade to Oracle 19c, there’s plenty in here for DBAs looking to improve how they manage their systems day to day. We cover features that help with security, performance tuning, diagnostics and data movement, so even if you’re not upgrading tomorrow, you’ll still gain valuable, practical knowledge.Â
Do I need to know everything about Oracle 12c before joining?
Definitely not. If you’ve worked with Oracle 12.1 and feel comfortable doing basic administration tasks, you’ll be comfortable on this course. We won’t assume you’re an expert on every feature, everything is explained clearly, and there’s plenty of time for hands-on practice. If something’s new to you, our trainers will make sure you’re supported as you advance through the course. Â
Does this course cover in-memory features and SQL performance tools?
Yes, it does. We spend time on the in-memory column store and how it can boost performance in real-world scenarios. You’ll also gain robust experience with Oracle’s SQL tuning tools, like the Optimiser Statistics Advisor and automatic indexing. If performance tuning is part of your job, this part of the course will be very useful.Â
Does the course include security and compliance features?
Absolutely. We cover enhanced auditing, privilege analysis, Transparent Data Encryption improvements, and schema-only account security, giving you the skills to strengthen compliance and reduce risk.Â
What our customers say
‘Tarn is an excellent instructor. Everything was clearly communicated. One of the best courses I have attended in recent years.’ Â
Simon, Senior DBA – GovernmentÂ
‘Thoroughly enjoyed the course, very informative and a good balance between instruction and practical work.’Â
Megan, TransportÂ
Why study with ILX
500,000+ learners
Join the half a million learners developing their skills with our trainingÂ
5,000+ businesses
A trusted partner to thousands of organisations worldwideÂ
96% customer satisfaction
Our passionate team goes above and beyond to support customer needsÂ
Quote request
Please complete the form to ensure your quote is accurate and we will contact you soon.
For the best prices, get in touch!