15% off eLearning, up to 20% off virtual courses - use code: NSWOCT25UK

b42b390f-43fe-4bf1-8efd-45bcae1d1050

Oracle Database 12cR2 Administration

Select your learning method

Learn essential skills
Course overview

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.  

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. 

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 

We're here to help
Speak to our learning experts

Not sure which course or study option is right for you? Get in touch with our team of advisors for personalised guidance and support throughout your learning journey.

Business transformation
Looking to develop your business or team?

Need to upskill your team? Our bespoke development solutions are designed to enhance team performance, retain talent, and drive organisational excellence. One of our development consultants would love to chat.

Quote request

Please complete the form to ensure your quote is accurate and we will contact you soon.

By submitting this form, you agree to ILX processing your data in line with our Privacy Policy. You can unsubscribe at any time by clicking the link in our emails or contacting us directly.

Page {{ step }} of 2

Back Next