Enhance your technical skills with this Oracle Database 12cR2 Administration immersive course. You’ll learn to manage, monitor, and troubleshoot Oracle databases through expert guidance and live labs. This course covers core Oracle 12cR2 administration skills, ideal if you're preparing for certification or want to boost your capabilities across 12cR2, 18c and 19c.
Oracle Database 12cR2 Administration
Build fast, efficient and powerful Oracle databases
Over five days, this live virtual course helps you acquire practical Oracle DBA skills you can use straight away in current work projects. You’ll expand your knowledge of important Oracle architecture, learning how to evolve performance and manage core administration tasks confidently. These technical abilities help to reduce downtime and keep critical systems running smoothly.
Learning objectives
- Administer Oracle database instances effectively
- Monitor database performance metrics
- Manage and configure storage structures and user permissions
- Configure and troubleshoot the Oracle network environment
- Identify and resolve lock conflicts
- Apply security and auditing features
- Schedule and automate jobs with Oracle Scheduler
- Manage backup and recovery settings
What you’ll learn
Led by Oracle experts, you'll build confidence managing an Oracle database from the foundations to more advanced configurations. With proactive lab exercises, you'll tackle real-world administration challenges, like tuning performance, managing storage and users, and learn how to keep systems secure and stable.
Database architecture and instance management
Understanding how an Oracle database works gives you the confidence to manage it effectively. You’ll explore how memory, processes, and storage work together to keep things running smoothly. Using tools like SQL*Plus, SQL Developer, and Enterprise Manager, you’ll learn how to start up and shut down the database, manage initialisation parameters, and get familiar with the key elements of Oracle architecture. This course provides you with valuable Oracle performance and management skills to keep your database environment stable, efficient, and under control.
Performance tuning and resource management
Understand how to maintain optimal database performance using Oracle’s built-in tools. This module explores practical techniques for monitoring and diagnosing performance issues, including the use of Automatic Workload Repository and SQL Tuning Advisor. You’ll also learn how to manage workloads effectively with Resource Manager, ensuring fair system resource distribution and avoiding performance bottlenecks. From resolving locking problems to fine-tuning memory allocation, you’ll build the skills needed to keep your database environment running smoothly, even under pressure.
Security, auditing and user access
Managing which users have access and what actions they can take is a key aspect of database security. You’ll learn how to create, modify and monitor user accounts, assign roles, and use profiles to enforce password and resource limits. The course also introduces Oracle’s auditing features, helping you track activity, maintain accountability, and meet compliance standards. You’ll be able to implement controls that keep your systems secure without slowing down your users, so the right people have the right access at the right time.
What’s included
- Five days of live online training
- Focused lab exercises using real Oracle setups
- Guidance from expert Oracle-certified trainers
- Practical courseware you can use for future reference
- StayAhead certificate of completion
- Access to post-course support and resources
- Flexible scheduling and private group options
Key facts
Ideal for
Anyone who is responsible for keeping Oracle databases running smoothly. It’s also a solid choice if you support Oracle 12cR2, 18c or 19c and want to sharpen your skills.
Prerequisites
You should already be comfortable with Oracle SQL and basic database concepts. While we run the course on Linux, you don’t need to be a Linux expert. We’ll guide you through anything you need.
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
This course is tailor-made for DBAs who want hands-on experience managing Oracle databases. It covers everything from user access and performance tuning to job automation and backups: real skills you can use right away.
Does this course cover Oracle 18c and 19c?
Yes. Although the focus is on Oracle Database 12cR2, the course is designed to support professionals working with 18c and 19c too. You’ll learn administration practices that apply across these versions, including architecture, performance tuning, and security. This course is ideal if you need cross-version Oracle DBA training with a strong practical focus.
Do I need to know Linux?
No, but a bit of Linux familiarity helps. The course is delivered on a Linux environment since Oracle databases often run on UNIX-based systems. However, you won’t need deep knowledge to understand the content. Your instructor will explain the commands and steps you need as part of the course.
What Oracle performance tuning tools will I learn on this course?
You’ll gain hands-on experience with tools like Automatic Workload Repository (AWR), SQL Tuning Advisor and Resource Manager. These help you diagnose performance issues and allocate resources efficiently, so your Oracle database runs at its best.
Can I learn how to schedule jobs in Oracle using this course?
Yes. You’ll learn how to use Oracle Scheduler to automate regular tasks, manage job classes and priorities, and avoid performance bottlenecks caused by manual processes or poor timing.
What our customers say
‘The lecturer was amazing - so passionate and knowledgeable, which made the sessions really enjoyable and easy to follow. I learned a lot and felt supported throughout. I would definitely consider returning for future sessions and highly recommend StayAhead training to my colleagues.’
Kamila, Data Administrator - Retail / Hire
‘Very well laid out and John does an amazing job of explaining things in detail.’
Ali, Operations Technical Service Analyst - Utilities
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