Expand your technical skill set by learning how to manage Oracle databases and monitor performance with this practical ILX course. With live expert instruction and proactive labs, you’ll explore real-world DBA tasks across 12cR2, 18c, and 19c. This course is perfect for a range of scenarios, including working towards certification or upskilling for work purposes. Â
15% off eLearning, up to 20% off virtual courses - use code: NSWOCT25USA
View courses
adca6ddb-8d65-4562-ad28-035467621152
Oracle Database 12cR2 Administration
Select your learning method
Learn essential skills
Course overview
Optimise your Oracle database performance for career growth
Led by expert instructors in our virtual classroom, this course helps you build transferable Oracle DBA skills. You’ll explore how Oracle Database 12cR2 is structured, learning how memory, processes and storage interact to keep systems running smoothly. With targeted labs, you’ll put theory into practice by managing instances, tuning performance and automating key tasks.Â
Learning objectives
- Optimise database performanceÂ
- Handle instance administrationÂ
- Manage users and storageÂ
- Set up Oracle networkingÂ
- Solve locking issuesÂ
- Use auditing toolsÂ
- Schedule tasks efficientlyÂ
- Prepare backup and recovery plans
What you’ll learn
By the end of this practical, instructor-led course, you’ll be equipped to manage Oracle databases with confidence. From setting up secure user access and configuring system resources to fine-tuning performance and planning backup strategies, you’ll build the skills needed to keep critical systems running smoothly.Â
Undo management and flashback
Undo data is your essential system for resolving mistakes and handling transaction errors. In this course, you’ll learn how to manage undo tablespaces, configure retention settings and keep usage under control. You’ll also explore Flashback features, which let you undo changes to tables or even rewind the whole database to a point in time. Great for fixing accidental changes and speeding up recovery when things go wrong without having to do a full backup.Â
Data movement and external tools
Moving data in and out of Oracle doesn’t have to be complicated. You’ll learn how to use Data Pump to export and import data quickly and reliably; ideal for migrations or backups. SQL Loader helps you bring in large flat files, while external tables let you access outside data as if it were already integrated within your database. This course focuses on making data transfers cleaner, faster and less manual, whether you’re handling full environments or a handful of rows.Â
Job automation with Scheduler
Oracle Scheduler enables you to avoid database task repetition. You’ll learn how to create and manage automated jobs, run tasks on a set schedule or trigger them by events. From backups to reporting, everything can be streamlined. You’ll also discover how to group jobs, set priorities and monitor what’s running, saving time and making sure the right things happen according to appropriate scheduling. Â
What’s included
- 5 days of live online trainingÂ
- Interactive labs with real Oracle setupsÂ
- Friendly, expert ILX instructorsÂ
- Course notes to keep and use at workÂ
- ILX certificate of completionÂ
- Access to helpful follow-up resourcesÂ
- Private and flexible delivery optionsÂ
Key facts
Ideal for
Those working with Oracle databases and who want to manage them more effectively. You might already be in a DBA role or supporting Oracle 12cR2, 18c or 19c in your team.Â
Prerequisites
You’ll need a solid grasp of Oracle SQL and general database concepts. The course is run on Linux, but don’t worry if you’re not a Linux expert, your trainer will guide you.Â
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
If you’re working with Oracle databases and want to strengthen your database management skills across 12cR2, 18c and 19c, this course is ideal. With interactive live labs and expert instructors, you’ll explore technical elements that support current workflows and strong career progression. Â
Is the course content suitable for experienced DBAs?
Yes, this isn’t just a beginner-level course. While it does cover Oracle admin essentials, the hands-on format and up-to-date content mean experienced DBAs will benefit too. If you’ve worked mostly with older versions or haven’t used features like Flashback, Resource Manager or Scheduler in depth, this is a useful chance to refresh your skills. Â
Does this course include Oracle database backup and recovery?
Absolutely. You’ll explore Oracle’s built-in tools and strategies for managing backups and performing recoveries, including common scenarios like media failure, data corruption, and system outages.Â
What user access and security features are covered?
The course covers user management, role-based access control, password policies and Oracle’s auditing tools. You’ll learn how to track user activity and protect your database from unauthorised access or security risks.Â
Will I be able to manage Oracle storage after this course?
Yes. You’ll learn how to configure and manage tablespaces, datafiles and other storage elements. You’ll also understand how to optimise storage use while maintaining system performance and stability.Â
How is database instance management taught?
You’ll use tools like SQL*Plus and Oracle Enterprise Manager to start up and shut down databases, configure initialisation parameters, and explore the architecture of Oracle database instances in a practical setting.Â
What our customers say
‘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Â
‘The instructor was particularly good and very knowledgeable and anything he didn't know he would investigate and come with the explanation. That is not my first class with him and one of the reasons I book with this company.’Â
Caroline, GovernmentÂ
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!