Our course builds real-world Oracle 18c administration skills, covering essential database tasks, configuration and performance. It gives you the confidence to administer, troubleshoot and secure Oracle databases, and supports preparation for the recognised Database Administration I: 1Z0-082 exam.
Oracle Database 18c Administration
Master Oracle 18c database administration capabilities
Over five-days, you’ll develop the skills to manage and maintain Oracle 18c databases effectively. Gain practical skills that help you to improve system performance and enhance data security, supporting your development, giving you the confidence to reduce risk through confident, capable database administration.
Learning objectives
- Administer an Oracle database
- Monitor and tune performance
- Manage users and security
- Schedule tasks with the Job Scheduler
- Resolve lock conflicts
- Perform backup and recovery
- Use Oracle auditing features
- Manage storage and undo data
What you’ll learn
Gain the skills to administer, monitor and secure Oracle 18c databases. Learn to manage storage, users, backups and performance, and build the confidence to apply tuning, troubleshooting, security best practices and recovery techniques across real-world database environments.
Administer Oracle databases
Learn how to confidently manage Oracle database instances using tools including SQL*Plus, SQL Developer and Enterprise Manager. Explore Oracle architecture, start and stop instances, and work with parameter files while gaining essential skills in configuration and monitoring for effective, real-world database administration.
Manage user access and security
Develop the skills to manage database users, roles and privileges while enforcing strong access controls. Learn how to secure accounts, apply Oracle profiles, and audit activity using both standard and unified frameworks. This will equip you with the knowledge to meet compliance needs and manage security confidently in real-world environments.
Tune performance
Oracle performance tuning is vital for maintaining system speed and stability. During the course, you’ll explore tools such as AWR, SQL Tuning Advisor and adaptive execution plans. You’ll also learn how to identify bottlenecks, optimise queries and apply memory tuning strategies, giving you a solid foundation for performance diagnostics and the confidence to apply tuning solutions effectively.
Configure backups and recovery
Build the skills to protect Oracle databases through effective backup and recovery strategies. Learn to use flashback recovery, configure retention settings and recover from data loss with MTTR Advisor and undo management. You’ll also work through real-world simulations to prepare you for production challenges. With these skills, you'll be able to design and implement resilient recovery plans that keep your systems protected and operational.
What’s included
- Five days of immersive training
- Expert Oracle-certified instructor
- Practical exercises
- Digital course materials
- Post-course support resources
- Certification-aligned content
- Access to live lab environments
- Trainer-led demonstrations
Key facts
Ideal for
IT professionals responsible for Oracle database support, administration and performance tuning.
Prerequisites
Working knowledge of relational databases and Oracle SQL. Linux familiarity is useful but not essential.
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 course covers the core skills needed to administer, secure, monitor and recover Oracle 18c databases, supporting both day-to-day operations and certification preparation.
Which Oracle tools will I learn to use?
You’ll learn how to work with essential Oracle tools including SQL Developer, SQL*Plus and Enterprise Manager. These are used to configure, monitor and troubleshoot Oracle 18c environments, giving you the practical experience needed to perform real-world DBA tasks confidently in professional database settings, making you job-ready from day one.
How much focus is placed on real-world application?
The course places strong emphasis on real-world application. Each module includes practical live lab exercises that reflect actual DBA tasks such as user management, job scheduling and recovery. Guided by experienced instructors, you’ll build the confidence to apply skills effectively and handle challenges in Oracle 18c environments.
Does the course cover Oracle job scheduling and automation?
Yes, the course includes in-depth guidance on using Oracle Job Scheduler and Resource Manager. You’ll learn how to automate tasks, create time-based and event-driven schedules, and allocate resources efficiently. These automation skills help reduce manual workload, improve consistency and boost the performance of Oracle 18c database environments.
Is the course content aligned to Oracle certification exams?
Yes, the course is an excellent choice if you are preparing to take the Oracle Database Administration I: 1Z0-082 exam. It covers core topics including architecture, backup, performance tuning and user management. Combined with self-study and Oracle SQL Fundamentals, it supports thorough exam preparation with practical experience.
What our customers say
“Very well laid out and John does an amazing job of explaining things in detail.”
Ali, StayAhead Learner - Operations Technical Service Analyst – Utilities
“Really informative course, structured to support all forms of learning and at a good pace.”
Owen, StayAhead Learner - Graduate Trainee Engineer - 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