Our course develops the key skills required to manage Oracle 18c databases effectively. You’ll gain the knowledge to configure, troubleshoot and secure database environments, while preparing for the industry-recognised Oracle Database Administration I: 1Z0-082 certification.
15% off eLearning, up to 20% off virtual courses - use code: NSWOCT25EUR
View courses
98711086-0510-4db5-8045-e586692f9427
Oracle Database 18c Administration
Select your learning method
Learn essential skills
Course overview
Develop Oracle 18c administration expertise to advance your technical career
In just five days, you’ll build the expertise needed to confidently manage and support Oracle 18c databases. You’ll learn the practical skills that help you enhance system efficiency, improve data security and reduce risk, giving you the capabilities needed to succeed as a database administrator.
Learning Objectives
- Set up and maintain Oracle databases in a live environment
- Track performance metrics and apply tuning methods
- Define user roles and configure security protocols
- Automate administrative processes with scheduling tools
- Manage contention issues and lock handling
- Create and test backup and restore strategies
- Configure auditing and logging features
- Organise storage resources and manage undo settings
What you’ll learn
Develop the practical skills needed to effectively manage Oracle 18c databases. This immersive course covers core areas including user management, storage, backups, performance and security. You’ll also learn how to troubleshoot, optimise and recover databases in real-world environments with confidence and control.
Core database administration
Build core Oracle 18c administration skills, from setting up database instances to configuring parameters and monitoring performance. You’ll learn how to use tools including SQL Developer, SQL*Plus and Enterprise Manager, while gaining essential knowledge of Oracle architecture, memory and processes to support real-world database management.
Automate with Oracle Tools
Learn how to streamline database operations using Oracle tools such as Job Scheduler, Resource Manager, Data Pump and SQL Loader. You’ll also gain the skills that help you automate tasks, manage resources efficiently and simplify data import and export processes, giving you the capability to support scalable, high-performing Oracle environments in real-world business settings.
Optimise resource management
Effectively manage system resources with Oracle’s Resource Manager by creating tailored plans, setting directives and controlling CPU and session usage. These capabilities help ensure balanced workloads, stable performance and improved operational efficiency across enterprise-level Oracle database environments.
Move and transform data efficiently
Master Oracle’s data movement tools including Data Pump and SQL Loader. Gain the ability to export, import and transform large data sets, validate data accuracy, and support faster migrations, integrations and routine data handling tasks within high-demand business systems. These skills help ensure reliable and efficient data operations, which are crucial for maintaining performance and integrity in production Oracle database systems.
What’s included
- Five days of structured learning
- Led by an experienced Oracle-certified trainer
- Real-world practical activities
- Downloadable digital learning resources
- Follow-up support and guidance
- Aligned to the Oracle 1Z0-082 certification
- Hands-on access to live lab systems
- Live demonstrations from your trainer
Key facts
Ideal for
DBAs and IT professionals managing Oracle systems who want to strengthen their admin and performance capabilities.
Prerequisites
Good understanding of SQL and relational databases. Prior exposure to Linux is useful but not necessary.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
Supports daily operational responsibilities and helps learners prepare for the Oracle Database Administration I: 1Z0-082 certification. When combined with self-study and Oracle SQL skills, it provides strong exam preparation.
What Oracle tools and interfaces are used in this course?
You’ll learn how to use key Oracle tools such as SQL Developer, SQL*Plus and Enterprise Manager for managing databases, troubleshooting issues and monitoring performance. Guided labs help you apply each tool effectively, ensuring you’re prepared to carry out core Oracle 18c administration tasks independently.
Does the training include backup and recovery strategies?
Absolutely, the course provides in-depth coverage of Oracle backup and recovery. You’ll learn how to configure retention settings, use flashback technologies and apply MTTR techniques to recover from data loss. These skills help ensure business continuity in live Oracle 18c database environments.
How are troubleshooting and error resolution handled in the course?
You’ll work through scenarios where Oracle environments encounter faults, slowdowns or user-related issues. These exercises involve identifying root causes using system logs, metrics and views, then applying tested recovery and resolution methods. You’ll become confident managing common error types, session locks and performance drops. Equipping you with a reliable process for diagnosing and resolving problems that can disrupt live systems.
Does this course cover performance monitoring strategies?
Yes. Performance optimisation is a critical focus throughout. You’ll use tools such as the AWR, SQL Tuning Advisor, and Enterprise Manager to pinpoint bottlenecks. You'll learn to analyse query plans, monitor memory usage and apply best practices for tuning. Each concept is reinforced with practical tasks designed to help you apply tuning techniques to both simulated and real-world scenarios.
What our customers say
“Great course. Alan has been courteous and informative throughout. Highly recommended and will absolutely be coming back for more courses.”
Bradley, ILX Learner - Software Engineer - Government
“Thoroughly enjoyed the course, very informative and a good balance between instruction and practical work.”
Megan, ILX Learner - 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!