Oracle Database 18c Administration

Select your learning method

Overview Learning objectives What you’ll learn Key facts FAQs What our customers say Get in touch

Learn essential skills

Course overview

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.

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.